I have 3 MySQL Database (Master 1, Master 2, Master 3) at three different locations, i would like to get the data from all 3 Location to a Central Database (Slave 1)located in my office.
All data from masters should be available in slave 1, syncing data across masters is not required.
Is there any way to achieve the same with any other methods? , i actually need to sync only two tables in database.
Please help me in achieving the same.
What I have tried:
I have found articles for muter slave replication, but not Multimaster replication.