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?

Recommended Answers

All 2 Replies

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.