1
Good morning, I have a local Mysql database where the availability is 24h, however I have another database in another location 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 in the two databases! Is there any method to do this?
1
What you want is a MASTER-MASTER data replication.
You have a step-by-step link http://blog.websolute.com.br/como-configurar-replicacao-multi-master-para-mysql-no-jelastic/
The process is even simple but requires attention when setting the offset of the autoincrement.
Offline link =(
Browser other questions tagged mysql sql
You are not signed in. Login or sign up in order to post.
with the detail of what changes are made in the two databases! So you used the term replication mistakenly.
– durtto
I understand, I’ll change!
– Paul Polidoro
Do you want to make a copy of your official database? Is that it? or do you want to synchronize two databases, take data from one to the other?
– durtto
I want to take data from one to the other, so that the two are identical. If you update one, the other also update and vice versa. Taking into account that one of them will not be available 24 hours.
– Paul Polidoro