0

I have two different servers(A1, B1) with mysql-5.1.73 and currently, I'm replicating DBs with another two servers(A2, B2).

I would like to know is it possible to do a centralized DB replication, which means replicating DBs of both Master_A1 and Master_B1 to a single Slave_A2.

P.S: database and their table names will be same in both Master servers.

Improve this question
7
  • Not with the antique 5.1.
    – Rick James
    Jun 20, 2018 at 15:23
  • @RickJames is it possible with any other version?
    – Siva
    Jun 21, 2018 at 7:01
  • Yes. Newer versions of MySQL 5.6(?) and MariaDB 10.0 can handle multiple Masters replicating to a single Slave. That was about 5 years ago. Development on 5.1 ended about 8 years ago. Look for phrases like "multi-source replication".
    – Rick James
    Jun 21, 2018 at 17:41
  • @Rick James is it possible with same DB name in both masters ?
    – Siva
    Jun 21, 2018 at 17:51
  • I doubt that you could replicate to the same table(s), since there is no "conflict resolution". Use a VIEW with a UNION on the receiving Slave?
    – Rick James
    Jun 21, 2018 at 17:55

0

Reset to default

Browse other questions tagged or ask your own question.