: Replication from multiple masters?
Good point about the bin-logs. Yup - that would sink it. If
mysql used individual binary logs per master database, it would work.
Ya, if someone was silly enough to have two different
databases with the same name, it would be bad, even with
separate binary
Does anyone know if it's possible to replicate to a single slave from
different databases on different masters?
For instance:
M1:dbAM2:dbB
\ /
rep rep
\ /
Slave
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
On 3/1/06, Jeff [EMAIL PROTECTED] wrote:
Does anyone know if it's possible to replicate to a single slave from
different databases on different masters?
For instance:
M1:dbAM2:dbB
\ /
rep rep
\ /
Slave
That's not entirely true.
You can have two instances of mysql running on the slave, and dbA connects to
one instance, and dbB connects to the other.
Jeff, when you say, different databases, do you mean that each master has a
single mysql instance, and if you typed on M1,
show databases
MySQL cannot handle more than one incoming binlog at a time. The
facilities are just not in the code.
You also run into a nightmare if a database exists on BOTH masters (same
name on both systems) and the PK values of any tables (also with matching
names) overlap. If both masters update the
Good point about the bin-logs. Yup - that would sink it. If mysql used individual binary logs per master database, it would work.
Ya, if someone was silly enough to have two different databases with the same name, it would be bad, even with separate binary
logs for each database.
If you have
I saw some time ago a post on this list with a script for managing
multiple masters but I have lost it and I can not found it on a google,
mysql list archives, anywhere.
I have wrote a program in c for managing it but I would like to compare
if I didn't forgot about something.
I would be very