Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Best Setup for Slave of Master-Master Replication?
Best Setup for Slave of Master-Master Replication? [message #1563] Fri, 27 July 2007 03:01 Go to previous message
sykosoft is currently offline 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
[Message index]

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

  

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

Current Time: Fri Jul 10 03:32:17 EDT 2009

Total time taken to generate the page: 0.02164 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.