If such existed, there would be a big caveat... The various masters
should not replicate to the same tables. If they do, there is a big
risk of errors discovered on the Slave (duplicate key, etc). These
freeze replication until a human takes some kind of action.
Since replication is single threaded on the slave, it might be desirable
to have both threads duplicated. Then, IF the user keeps his Masters
from stepping into each other's turf, you could get parallelism that
does not exist today! :)
MySQL Geeks - Consulting & Review
> -----Original Message-----
> From: Simon J Mudd [mailto:sjmudd@stripped]
> Sent: Thursday, August 28, 2008 3:12 AM
> To: replication@stripped
> Subject: Thoughts on MySQL replication
> Hello all,
> I've been using MySQL replication for some time but come from a
> replication background using Sybase.
> MySQL replication works very well is quick and simple to configure but
> has some limitations, notably that you can't configure a MySQL server
> as a slave of multiple masters.
> One of the things which struck me is that AFAICS the MySQL replication
> code has 2 major parts:
> 1. a part which connects to the master and pulls the binlog
> to the local server, storing it in the relay-logs.
> 2. a part which applies the relay logs talking to the
> database as if it
> were a SQL client.
> The description may not be exactly right but I think it's close.
> Now if this MySQL code were put into an external program you could
> configure 1 or more replication servers and solve many of the
> limitations of the current code. You also simplify the MySQL server
> as it's replication knowledge is reduced, and potentially can improve
> replication behaviour (upgrades in the replication processes) without
> affecting the MySQL server itself.
> Would it be perhaps worthwhile doing something like this to
> allow for more
> sophisticated replication configurations in larger mysql
> Just wonder what people think about this idea.
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe: