wiki:DbOutOfSync

Version 4 (modified by Jon Ewald, 9 years ago) (diff)

Updated with new procedure provided by Dom on 9/1/16

From dbshow you will see if the Slave_IO isn’t running or if the flights tables are out of sync. Perform the following steps to get TDLS databases back in sync.

  • Run service tdls stop on the standby server then on the active server
  • Run the ‘config’ command from the server that shows the Slave_IO isn’t running or the one with less TDLS flights
  • Input ‘8’ as the choice to copy complete configuration from the other server
  • Run service tdls start on the server you wish to be active first, the on the other server
  • Run dbshow again to verify databases are synced