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-fo...@backupcentral.com] Sent: Wednesday, November 26, 2014 11:18 AM To: bacula-users@lists.sourceforge.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 danielmadri...@gmail.com via Backup Central. |Forward SPAM to ab...@backupcentral.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
