How to realize the Separation of read and write by mysql

This article will explain in detail how to achieve the separation of reading and writing in mysql. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

1. Amoeba is separated from reading and writing.

2. MySQL-Proxy read-write separation is an official middleware service provided by MySQL, which supports numerous client connections, and the backend can connect to multiple Mysql-Server servers.

3. Mycat is separated from reading and writing.

4. Based on the separation of program reading and writing.

The efficiency is high, the implementation is difficult, the development changes the code.

Example

Proxy: 192.168.75.133master: 192.168.75.134slave: 192.168.75.135 this is the end of the article on "how to achieve the separation of reading and writing in mysql". I hope the above content can be of some help to you so that you can learn more knowledge. if you think the article is good, please share it for more people to see.