I have 4 servers running MySQL 5.7 in total , servers 1,2,3 each has single database on them For example:
Server 1 has the DB x_1 Server 2 has the DB x_2 Server 3 has the DB x_3
Server 4 has 3 databases in it:
x_1 x_2 x_3
What i want to achieve is master to master replication between the 3 servers and server 4 each to his own database:
Changes in x_1 in server 4 or server 1 will replicate both ways Changes in x_2 in server 4 or server 2 will replicate both ways . . .
Appreciate any guidance to the correct way to achieve this (Note: I already know about multi source replication single slave and multiple masters but i am not sure if it can be used here)