Re: MySQL Master Master Replication and data loss

2010-01-14 Thread Suresh Kuna
Hi Manasi, Inside MySQL, there are no such parameters and the Slave delay depends on different things like network between Master and Slave, load of the MySQLD server etc... To make the slave behind for a particular period of time, use mk-slave-delay tool from the the maakit. It help your slave to

Re: MySQL Master Master Replication and data loss

2010-01-14 Thread Manasi Save
Dear Suresh, Thank you. In MySQL Replication, as the slave itself takes the writes from master but in how much time period does slave goes to master. is there any parameter where I can set this. that after every 60 seconds slave should write data from master to its own local database. --

Re: MySQL Master Master Replication and data loss

2010-01-13 Thread Suresh Kuna
Hi Manasi, As both are implemented by replication, there is a possibility for loosing data. Thanks Suresh Kuna MySQL DBA On Wed, Jan 13, 2010 at 8:20 PM, Manasi Save < manasi.s...@artificialmachines.com> wrote: > Hi All, > > > I want to implement MySQL Master Master Replication. But I have read