Replicate DigitalOcean OLD data to INT server

[jrwdunham]

A/C:

• Devise a system whereby we can create a follower copy of the production OLD data (both MySQL and filesystem data) from leader DigitalOcean on the follower INT server.
  • Likely use mysqldump and rsync with some scripting.
• The synchronization system does not need to be rapidly or automatically consistent, but it does need to be eventually and semi-automatically consistent.
  • That is, we want to be able to shut down a DO OLD, fully replicate its partially-replicated data to INT, and then start up that OLD instance on the INT server, with minimal manual labour and error.

References:

• https://dba.stackexchange.com/questions/65351/sync-two-mysql-databases-in-two-different-locations

[jrwdunham]

This is now complete. See How to Migrate the OLD Data from DO to INT of the DVB runbook.

Core replication commands:

  dodative:$ ./dump-old-dbs.sh
  local:$ ./sync-do-old-to-local.sh
  int:mysql> source /home/joel/load-do-mysql-dumps.sql