MySQL Forums
Forum List  »  Replication

Replication: 2 masters -> 1 slave
Posted by: Des Rodman
Date: January 15, 2015 05:17AM

Hello

Bought a separate server as a repository / reserve where I want to replicate all their sites (site on two other servers).

How to set up a replica of a master - slave i know ... a lot of time doing.


But here's how to make that slave database collected from two other servers (different databases on all servers) can not understand.

I'm asking who I pull replica (slave) and which server and what position ... and then you need to with one pulled from the first position, and the other - on the other position.

Under the mean position of the parameter position on the master:
File: bin.000140
Position: 48369483
Binlog_Do_DB: db1
Binlog_Ignore_DB:


File: bin.000320
Position: 483
Binlog_Do_DB: db2
Binlog_Ignore_DB:


Who can tell me how to come up with such a situation, to the third server (slave) merged two replica database from two different servers?

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication: 2 masters -> 1 slave
2004
January 15, 2015 05:17AM
1082
January 17, 2015 12:02AM


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.