Hello Hexide,

that’s a good point, didn’t think about that. We should do that.

It will help, if main-server is down (hardware, os, ..).
1) but it will not help, if DNS-entry is taken.
2) and we’d have to check, if the devices DNS-client can handle this at the moment. Maybe I could check that offline.

Also we then/still have the problem of syncing several (in this case) MySQL-master-databases.
I only know about syncing from one master’DB to several client’DBs. There data is written to one DB only – and users read (requests…) from the client’DBs where a minimum mismatch doesn’t matter (not the newest data available).

In our new scenario we’d need to synchronic several master’DBs, which are all written

Is this possible with MySQL? What about the conflicting primary-keys?

Vinz

P.S: The correct words to search are “replication” and “master-master-replication”.