Live replication of MySQL records

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?

Contributors

Replies

6 Days

Discussion Span

8 Months Ago

Last Updated

Views

manaila

Light Poster

43 posts since Jul 2010

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

8 Months Ago

Why not use MySQL's replication.

pritaeas

Posting Prodigy

Moderator

9,265 posts since Jul 2006

Reputation Points: 1,173

Solved Threads: 1,456

Skill Endorsements: 86

8 Months Ago

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?

manaila

Light Poster

43 posts since Jul 2010

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

This article has been dead for over three months: Start a new discussion instead

You