On Sat, Oct 29, 2011 at 8:59 PM, ashwin kesavan <ashwin.chn at gmail.com>wrote:
On 29 October 2011 11:06, Arun Venkataswamy <arun289 at gmail.com> wrote:
Thanks all for pitching in to help!at
I am not in a position to change the database software from MySQL.
I guess the only way to do it is programmatically record all the changes
the master side (all SQL update/insert/delete commands) on a per branch
basis and send that information for playback at the branch databases.
If you plan to implement the above. I think the following information
would be helpful. Mysql maintains a binlog file ( as specified in
my.cnf configuration file) which has a log of all mysql db changes
made. So having a application to reading it and updating the db would
be far easier than having to write a application to record all db
changes and relaying to the master db.
--ashwin
_______________________________________________
ILUGC Mailing List:
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc