Search code examples
symmetricds

SymmetricDS: Failover of master node

I inherited a setup that is using SymmetricDS 3.7 to sync a SQL Server database (call this machine SQL1) to a Mariadb copy. SQL1 also hosts my Master Symmetric Node. I use SQL server replication to back up the same database on another SQL Server machine (SQL2).

In the event that my SQL1 fails, I would like failover to SQL2 as the Symmetric Master Node, and continue Symmetric sync to mariadb (without redoing the initial provision to mariadb).

I have been scouring the official documents, forums, and SO for any clues as to how this might be handled. At the moment, I'm thinking I will either need to:

  • A) SQL Server replicate SQL1's Symmetric database (i.e. the one containing the sym_data and other tables), so that SQL2 has ~2s old copy, OR
  • B) Have my replication copy (SQL2) Symmetric sync from SQL1, and (somehow?) make it become the Master Node should db1 fail.

Thanks in advance!

Solution

  • SQL1 When fails will be unavailable for symmetricds anyway. So just change the db URL to hit the replicated SQL2. To be sure that symmetricds stays intact move it to a third machine