> > 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 _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
