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