does mysql support master to master replication

--0-2055454923-1312348205=:63115
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi, Folks: Does mysql support master to master replication, or master =
to slave replication on;y?=A0 I did not find the answer in MySQL manual, bu=
t found some discussion over the internet. Does anybody know?=A0 if so=
, anybody has implemented master to master replication in production? =
Thanks Angela=0A
--0-2055454923-1312348205=:63115--

Re: does mysql support master to master replication

I have been using the M-M replication over years.
But we only write to one node at any time.
When this node is unusable, we write to another node.


On Wed, Aug 3, 2011 at 1:10 PM, Angela liu wrote:
> Hi, Folks:
>
> Does mysql support master to master replication, or master to slave repli=
cation on;y?  I did not find the answer in MySQL manual, but found som=
e discussion over the internet.
>
> Does anybody know?  if so, anybody has implemented master to master =
replication in production?
>
> Thanks
>
> Angela
>

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

Re: does mysql support master to master replication

--00235452f63079a32f04a992f78d
Content-Type: text/plain; charset=ISO-8859-1

MySQL, to my knowledge, supports only Master to Slave replication- as well
as Master-slave-slave replication.

http://dev.mysql.com/doc/refman/5.0/en/replication.html

On Wed, Aug 3, 2011 at 1:10 AM, Angela liu wrote:

> Hi, Folks:
>
> Does mysql support master to master replication, or master to slave
> replication on;y? I did not find the answer in MySQL manual, but found some
> discussion over the internet.
>
> Does anybody know? if so, anybody has implemented master to master
> replication in production?
>
> Thanks
>
> Angela
>

--00235452f63079a32f04a992f78d--

Re: does mysql support master to master replication

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

I had seen a discussion here as well, but honestly did not test it. It may
be of help.

http://www.linkedin.com/groupItem?view=&srchtype=discussedNe ws&gid=72881&item=60056153&type=member&trk=eml-anet_dig-b_pd -ttl-cn

On Wed, Aug 3, 2011 at 1:10 AM, Angela liu wrote:

> Hi, Folks:
>
> Does mysql support master to master replication, or master to slave
> replication on;y? I did not find the answer in MySQL manual, but found some
> discussion over the internet.
>
> Does anybody know? if so, anybody has implemented master to master
> replication in production?
>
> Thanks
>
> Angela
>

--bcaec5485f9a158bc204a9930244--

Re: does mysql support master to master replication

--90e6ba6e8804c6922004a9948ca6
Content-Type: text/plain; charset=ISO-8859-1

Any mysql instance can replicate from any other as long as binary logging is
enabled on the designated master.
Two instances can replicate from one another yes, but precautions must be
taken especially in the case of active-active configuration.
Cheers,
Claudio
On Aug 3, 2011 7:19 AM, "Jon Siebert" wrote:
> I had seen a discussion here as well, but honestly did not test it. It may
> be of help.
>
>
http://www.linkedin.com/groupItem?view=&srchtype=discussedNe ws&gid=72881&item=60056153&type=member&trk=eml-anet_dig-b_pd -ttl-cn
>
> On Wed, Aug 3, 2011 at 1:10 AM, Angela liu wrote:
>
>> Hi, Folks:
>>
>> Does mysql support master to master replication, or master to slave
>> replication on;y? I did not find the answer in MySQL manual, but found
some
>> discussion over the internet.
>>
>> Does anybody know? if so, anybody has implemented master to master
>> replication in production?
>>
>> Thanks
>>
>> Angela
>>

--90e6ba6e8804c6922004a9948ca6--

Re: does mysql support master to master replication

> Any mysql instance can replicate from any other as long as binary logging
> is enabled on the designated master.
> Two instances can replicate from one another yes, but precautions must be
> taken especially in the case of active-active configuration.

Works perfectly indeed, to name the precautions to take:

1, Set proper server_id's

2. When using auto-incrementing fields, set the auto_increment_offset &
auto_increment_increment.

3. If you write on 2 servers simultaneously, UNIQUE indexes can break
replication. If your application requires both enforcing them AND writing to
both servers, look at clustering instead.
--
Rik Wasmus

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