How to implement scaling and fault tolerance of MySQL database?

Question

MySQL

I am writing a project in PHP. I chose MySQL as the DBMS. Since there are many users, and the high availability of the service will not hurt, I want to ask you how to make the database fault-tolerant and productive at the same time. There are 2 more or less powerful dedicated servers. How in this case to organize the most affordable and productive solution?
The relevance of the data is required. That is, almost instant duplication of data on both servers.

Answer 1

master-slave replication, what is there to think
2 slaves
write to the master, read from the slaves
to the scheme for a hundred years at lunch
separately daily dumps of the disk with the database

Answer 2

Man, asking for advice on a toaster is good, but not enough.
Here you will get vague answers to your question.
It is best to know good and useful books on your topic. Read and only then you can ask a specific question if something is not clear.
1. search here https://ruhighload.com/
2. read the following books.
Making MySQL-Based Systems Highly Available Charles Bell
MySQL Optimizing MySQL Performance Baron Schwartz Maximizing
MySQL Baron Schwartz
High-Load Applications Martin Klepman
I think this way you will find more benefits, answers and specific steps to do.

Answer 3

If you are not satisfied with the speed of replication, then look towards proxysql and similar things, there you can make the record mirrored to all servers, and the reading is balanced in turn.