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. Cheers, Claudio On Aug 3, 2011 7:19 AM, Jon Siebert jon.siebe...@gmail.com 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=discussedNewsgid=72881item=60056153type=membertrk=eml-anet_dig-b_pd-ttl-cn On Wed, Aug 3, 2011 at 1:10 AM, Angela liu yyll2...@yahoo.com 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
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=arch...@jab.org
does mysql support master to master replication
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
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 yyll2...@yahoo.com 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: does mysql support master to master replication
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 yyll2...@yahoo.com 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
Re: does mysql support master to master replication
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=discussedNewsgid=72881item=60056153type=membertrk=eml-anet_dig-b_pd-ttl-cn On Wed, Aug 3, 2011 at 1:10 AM, Angela liu yyll2...@yahoo.com 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