One base for two servers. What are the implementation options?

Question

MySQL

The task is as follows:
there is server 1 and server 2, if server 1 for some reason could not process the request, then it (the request) is sent to server 2. It is necessary that both servers use the same database. How to do it the smartest way? The option to take a third server, put mysql on it and give a remote connection to two servers seems to me not very correct.

Answer 1

Raise Bases on server 1 and server 2. Set up master-master replication between them.
Let the scripts on server 1 and 2 query the database by localhost so as not to make an external request to the second server.
If 2 servers are used to improve fault tolerance, then using a 3rd dependent server will only reduce it.
Let's say server 3 is down, then neither server 1 nor server 2 will have any meaning at all.

Answer 2

Comparing different cluster implementations for MySQL?

Answer 3

make a database with constant updating on both servers, that is, information goes to one database, and then the missing part from the first is copied to another. And protect yourself from breakdowns - if one server is broken, the second one has a complete copy of the database. Open external access to the database on both servers and let them exchange data over the local network.

Answer 4

I am doing a similar task. in the project, data + files from one server (master) are transferred to several others. Change data only on the master. All done with php. Made as an experiment, but so far it works great. With a replica, the slave server receives logs from the master, and this is difficult for us. Due to the location of the master in the closed part of the Internet, it is completely closed from the outside. the master itself can send https requests, and they also transmit data. Additionally, symmetric encryption is used. So if the task is not standard - look for or develop non-standard solutions