I need to setup a MySQL master and slave, between an office and a webserver in a datacenter.
The master will be in the office.
What would happen if the internet connection would fail in the office?
I assume the slave wil continue to work, but the slave and the master will no longer be in sync when the connection comes back.
Will MySQL / InnoDB correct for this?
Is there a way to make MySQL fix this automatically?
Does anyone have a working example?
MariaDB will be the database of choice.