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?
manaila
0
Light Poster
Recommended Answers
Jump to PostWhy not use MySQL's replication.
All 2 Replies
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
manaila
0
Light Poster
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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.