MySQL Forums
Forum List  »  Replication

Re: MYSQL Replication 4.0.X
Posted by: Christian Meisinger
Date: May 11, 2005 12:56AM

you just cannot replicate from two diff. mysql masters into one mysql slave.
what you can to is to run 2 mysql slaves on the slave pc.
that's what we do.
then if you do any staistics you can connect to both mysql (on localhost) and get the data.
that's fast enough for us.

with simple copy i meant to replicate from master 1 and master 2 to the slave and NOT merging the data. which would be possible i think. maybe you could read the binary log from each master with a script, translate the database name and execute the commands on one slave. maybe :)
but such a selfmade script sounds very dangerous too.

merging would be very hard because of unique and primary keys.

another possibility would be to replicate from master 1 to master 2 and then to the slave.
for this setup you need diff. database resp. table names on master 1 and 2 to prevent conflicts.

Options: ReplyQuote


Subject
Views
Written By
Posted
3042
May 03, 2005 01:31PM
1946
May 10, 2005 07:29AM
Re: MYSQL Replication 4.0.X
2051
May 11, 2005 12:56AM
1972
May 11, 2005 07:05AM
2100
May 11, 2005 10:53AM
1948
May 13, 2005 02:24PM
2086
May 15, 2005 07:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.