Automatic Database Synchronization in MySQL

1

Hello, I have a local MySQL database where the availability is 24h, however I have another database in another place that is available for a few hours, anyway ... I want to synchronize two identical databases automatically when both are available, with the detail of what changes are made to both databases! Is there a method that does this?

    
asked by anonymous 21.03.2016 / 14:24

1 answer

1

What you want is a MASTER-MASTER data replication.

You have a step-by-step link in the link

The process is even simple but requires attention when setting the autoincrement offset.

    
21.03.2016 / 17:56