MySQL Performance: MySQL => Best Setup for Slave of Master-Master Replication?

Members

Help

Home

Home » Performance » MySQL » Best Setup for Slave of Master-Master Replication?

Show: Today's Messages :: Show Polls :: Message Navigator

Best Setup for Slave of Master-Master Replication? [message #1563]

Fri, 27 July 2007 03:01

sykosoft
Messages: 2
Registered: July 2007
Location: Silicon Valley, CA

Junior Member

I have in production a 2 master (master-master) replication, and a slave of the master. Currently, the slave is master of one server, so it looks like this:

Master1<----->Master2
|
|
|
Slave1

What happens, is if I have to switch to master2 for writes, the slave never receives the updates, so it essentially is "out of sync". What is the best way to overcome this problem?

Thanks,
Michael

Report message to a moderator

Re: Best Setup for Slave of Master-Master Replication? [message #1565 is a reply to message #1563 ]

Mon, 30 July 2007 05:22

stark
Messages: 11
Registered: July 2007

Junior Member

You probably forgot to set "log-slave-updates" on Master1, see http://dev.mysql.com/doc/refman/5.0/en/replication-options.h tml

Hope this helps,
Martin

Report message to a moderator

Re: Best Setup for Slave of Master-Master Replication? [message #1566 is a reply to message #1563 ]

Mon, 30 July 2007 13:07

sykosoft
Messages: 2
Registered: July 2007
Location: Silicon Valley, CA

Junior Member

Why, I think you're right! I'll make sure, and let you know.

Thanks bunches,
Michael

Report message to a moderator

Previous Topic:	Any suggestions to a query with multiple joins?
Next Topic:	Multiple databases vs. multiple tables

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 8 17:48:01 EST 2009

Total time taken to generate the page: 0.04947 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.