Mysql replication may in fact guard against duplicate jobids, since the same 
jobids will be in both databases, in theory.
It's the replication lag that will be the problem. During the lag it will still 
be possible to create duplicate bacula jobids.

-----Original Message-----
From: Danixu86 [mailto:bacula-forum AT backupcentral DOT com] 
Sent: Wednesday, November 26, 2014 11:18 AM
To: bacula-users AT lists.sourceforge DOT net
Subject: [Bacula-users] How to do Cross Replication Site1<=>Site2 (DR)

What about mysql cluster?

http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-nodes-groups.html
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-online-add-node.html

I've never tried this before, but maybe is a good solution ;)

greetings!!



Interesting problem.
If we were just talking MySQL replication, there is a setting "increment" where 
you would set it to 2 in this case and no duplicate record numbers would be 
generated.
In this case we need an "increment" setting for bacula jobids, or perhaps a 
"number of sites" or "sites" setting, which would accomplish the same thing so 
non-duplicating jobids would be generated within bacula.


-----Original Message-----
From: Heitor Faria [mailto:heitor < at > bacula.com.br]
Sent: Wednesday, November 26, 2014 7:00 AM
To: bacula-users < at > lists.sourceforge.net
Subject: Re: [Bacula-users] How to do Cross Replication Site1<=>Site2 (DR)

"SITE 1 <----------> INTERNET <-------------> SITE2
Dir1.............................................................Dir2
(Catalog)................(REPLICATED)................(Catalog)
SD1.......................(REPLICATED)..................SD2
FD...............................................................FD
FD...............................................................FD
FD...............................................................FD

The volumes can be easily replicated using any OS tool, that's OK. The problem 
is the DB (Catalog) since i understand that job ids may be duplicated in case i 
sync both sites databases."

Bacula Copy Job with SelectionType=PoolUncopiedJobs would produce similar 
redundancy results (mirroring) with the proper database index you need in 
Bacula database.

Regards,
==============================================================================
Heitor Medrado de Faria - LPIC-III | ITIL-F
12 a 23 de janeiro de 2015 - Treinamento Telepresencial Bacula: 
http://www.bacula.com.br/?p=2174
61 2021-8260 | 8268-4220
Site: www.bacula.com.br | Facebook: heitor.faria | Gtalk: heitorfaria < at > 
gmail.com 
===============================================================================

----- Mensagem original -----
De: "Pr0sper0" <bacula-forum < at > backupcentral.com>
Para: bacula-users < at > lists.sourceforge.net
Enviadas: Terça-feira, 25 de novembro de 2014 22:21:06
Assunto: [Bacula-users] How to do Cross Replication Site1<=>Site2 (DR)

Hello All,

After reading the official Bacula documentation i couldn't found a solution for 
my situation. I wonder if someone had the same issue.

This is what i need to do in order to address Disaster Recovery:

SITE 1 <----------> INTERNET <-------------> SITE2
Dir1.............................................................Dir2
(Catalog)................(REPLICATED)................(Catalog)
SD1.......................(REPLICATED)..................SD2
FD...............................................................FD
FD...............................................................FD
FD...............................................................FD

The volumes can be easily replicated using any OS tool, that's OK. The problem 
is the DB (Catalog) since i understand that job ids may be duplicated in case i 
sync both sites databases.

Is there any way to address this safely ?

Thanks a lot for your response.
Have an excelente day! Smile

+----------------------------------------------------------------------
|This was sent by danielmadrid19 AT gmail DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------




------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users