Greetings, On Thu, Nov 17, 2011 at 2:44 PM, Sathish M Kumar <[email protected]> wrote: > 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 ? >
For postgresql, you can use the two phase commit (Prepare and commit across servers to maintain consistancy) at the application level. If the geolocation are very well connected, say by redundant fibres, perhaps you should look at DRBD for block level replication. I have done DRBD, but within a campus where reliable connectivity could be guaranteed, and not across districts/continents etc. -- Regards, Rajagopal _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
