On Sat, Oct 29, 2011 at 8:59 PM, ashwin kesavan <[email protected]>wrote:
> On 29 October 2011 11:06, Arun Venkataswamy <[email protected]> wrote: > > Thanks all for pitching in to help! > > 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 > at > > 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 > You can use inotify to detect changes. Whenever there is a change in a file an event will be generated by the system. Your application can register for that event and do necessary things, in other time the application can sit idle (wait for the event without using any system resources). _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
