I want to make every single change on a local database to also be immediately done on the remote database. The remote database is always online but the local one is not. I was hoping of using RabbitMQ to queue the records so they could be sent immediately when the local PC is online, although I have not gone deeper into how to impliment it.
What are the better ways of achieving this?
Hi pritaeas, my problem with MySQL's replication is that I have many (similar) DBs (masters) from different places which all have to update one remote DB (slave). So I thought MySQL does not support Multiple-masters/Single-slave architecture(?).
Any workaround for this?