Creating MySQL replicas for scaling and high availability
When your application is small, you can use a single MySQL server for all your database needs. As your application becomes popular and you get more and more requests, the database starts becoming a bottleneck for application performance. With thousands of queries per second, the database write queue gets longer and read latency increases. To solve this problem, you can use multiple replicas of the same database and separate read and write queries between them.
In this recipe, we will learn how to set up replication with the MySQL server.
You will need two MySQL servers and access to administrative accounts on both.
Make sure that port
3306 is open and available on both servers. ...