List:General Discussion« Previous MessageNext Message »
From:Suresh Kuna Date:January 14 2010 9:12am
Subject:Re: MySQL Master Master Replication and data loss
View as plain text  
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.save@stripped> 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 <sureshkumarilu@stripped>:
>
>> 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.save@stripped> 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

Thread
MySQL Master Master Replication and data lossManasi Save13 Jan
  • Re: MySQL Master Master Replication and data lossSuresh Kuna13 Jan
Re: MySQL Master Master Replication and data lossManasi Save14 Jan
  • Re: MySQL Master Master Replication and data lossSuresh Kuna14 Jan