Mysql master-slave synchronization can one slave correspond to multiple different master

if MySQL is a few questions about master-slave synchronization

1) can one slave synchronize data from multiple master, or can one slave only work for one master and one master for multiple slave
2) must their database names be the same for master and slave?


generally speaking, one master is used for multiple cluster machines

the name of the database is generally the same, and it can also be accurate to the table

.

1. For multiple masters and one slave, you can learn about MySQL5.7 's multi-source replication , new_db". Portal

when you look up data, you will find that there is very little heterogeneous synchronization data, because there are few such requirements, and it is also a problem when master-slave synchronization errors are to be fixed. Individuals do not recommend heterogeneous synchronization.

Menu