[Ilugc] Setting up mirror server and database server in Sync
- From: sudharsh@xxxxxxxxx (Sudharshan S)
- Date: Thu, 17 Nov 2011 14:26:36 +0530
1) setup a cron job to invoke the sync operation every n seconds
2) sync both ways(no master/slave relationship), the cron job is run
at every location
3) Make sure the DBs are not written to when the sync is
happening.Lock the DB whilst performing
?the sync
Won't this lock entire tables every n seconds? If the OP wants
immediate replication this 'n' will be very small.
And rsync'ing raw database files is never a good idea.
--
Sudharshan S
http://sudharsh.wordpress.com
Other related posts: