There are 3 shops. In each of these is a mysql server. I want all servers to synchronize their date if at least one server changes the date. I read a bit of literature and realized that I need master master replication. However, I must take into account the fact that one or more of the databases can work a couple of hours in offline mode (e.g. shut down Internet). How will this work in this case? Will there be duplication of column with Primary key? if so then do I need to take this into account?
Advise me, please. I'm new to mysql.