Good morning, I'm doing a project in which I need to synchronize a mysql database locahost, with a mysql mounted on a server, so that if the internet is going to continue working on the php web application. What would be the proper way to perform this operation? Thank you for your time.
You need to first make the replication with mysql. If you want a web application to be available even if one of the servers goes down, you need to put a http proxy for balancing and loading, apache and nginx have these options if my memory does not fail me. However you would need a total of 3 servers minimum, one proxy and two slaves. The proxy must ensure that it is always available, it must be in datacenter.
Another option is to contract domain services, which if one server goes down will direct you to another, I do not remember if cloudflare gives you that service.