Member Avatar for manaila

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?

Edited by manaila because: correct heading
  • 2 Contributors
  • 2 Replies
  • 179 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by manaila
Member Avatar for manaila

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.