MySQL Master Master Replication and data loss

--=_4ik4nm28hzeo
Content-Type: text/plain;
charset=UTF-8
Content-Description: Plaintext Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit


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


--=_4ik4nm28hzeo
Content-Type: multipart/related;
boundary="=_4l6ub1npa1z4";
start="4l7f7xvty000@mail.artificialmachines.com"
Content-Transfer-Encoding: 7bit

This message is in MIME format.

--=_4l6ub1npa1z4
Content-Type: text/html;
charset=UTF-8
Content-Description: HTML Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-ID: 4l7f7xvty000@mail.artificialmachines.com

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,

Re: MySQL Master Master Replication and data loss

--001636e1fcae15bd9b047d0e1192
Content-Type: text/plain; charset=ISO-8859-1

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@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

--001636e1fcae15bd9b047d0e1192--

Re: MySQL Master Master Replication and data loss

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 :
> 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@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


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: MySQL Master Master Replication and data loss

--001636e0a80c455bdc047d1c4862
Content-Type: text/plain; charset=ISO-8859-1

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@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 :
>
>> 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@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

--001636e0a80c455bdc047d1c4862--