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 be lack for a particular period of time.
On Thu, Jan 14, 2010 at 2:11 PM, Manasi Save < manasi.s...@artificialmachines.com> wrote: > > 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. > -- > Regards, > Manasi Save > > > > > Quoting Suresh Kuna <sureshkumar...@gmail.com>: > >> 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 in >> the >> > various documentation that in mysql replication it is possible that I >> loose >> > data. > >> > Is it also applicable to MySQL Master Master Replication. > >> > >> > Thanks in advance. > >> > >> > -- >> > >> > Regards, >> > Manasi Save >> > >> > >> >> >> -- Thanks >> Suresh Kuna >> MySQL DBA >> > > -- Thanks Suresh Kuna MySQL DBA
