Yes, i understand the difficulties of rsync'ing the raw database files. I need to proceed with DB replication procedure for database tables and data synchronizing.
Is anyone come across replication middleware available for Mysql and Postgresql ? Regards , Sathish.M Kumar On Thu, Nov 17, 2011 at 2:26 PM, Sudharshan S <[email protected]> wrote: > > > > 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 > _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
