How to achieve read-write separation in mysql

This article focuses on "how to achieve the separation of mysql reading and writing". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "how to achieve the separation of mysql reading and writing".

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 so far, I believe you have a better understanding of "how to achieve mysql read-write separation". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!