Bucardo/Failover

From Bucardo

Failover is possible using Bucardo, although that is not one of its primary goals. For swap syncs, of course, there is very little that needs to be done - just point your application to the other database. For a pushdelta sync on the other hand, making one of the slaves into a master involves the following steps:

• Set the old master as 'inactive' in the db table.
• Alter the sync so that the new master is the sourcedb.
• Run validate_sync so that triggers and other supporting items get created on the new master.
• If you are in doubt that the slaves are up to date, set onetimecopy to 2.
• Restart Bucardo