Shulou(Shulou.com)06/03 Report--

This article mainly introduces "the specific implementation method of mysql read-write separation". In daily operation, I believe many people have doubts about the specific implementation method of mysql read-write separation. Xiaobian consulted various materials and sorted out simple and easy operation methods. I hope to help you answer the doubts of "the specific implementation method of mysql read-write separation"! Next, please follow the small series to learn together!

1. Based on internal implementation of program code. Classifying routes in code by select and insert is the most widely used method in production environments today.

The advantage is that the performance is good because it is implemented in program code and does not require additional equipment as hardware expenditure;

The downside is that developers need to implement it.

Not all applications are suitable for implementing read-write separation in program code. If you want some large and complex Java applications, if you implement read-write separation in program code, the code will change greatly.

2. Implementation based on intermediate agent. Proxy is generally located between client and server.

After the proxy server receives the client request, it forwards it to the backend database by judgment.

Representative procedures:

(1) MySQL-Proxy:MySQL open source project, SQL is judged by its own lua script.

Atlas: is a MySQL protocol-based data middle tier project, developed and maintained by Qihoo 360Web Platform Infrastructure Team;

It is an optimization of mysql-proxy version 0.8.2, adding some new features.

The mysql business uses Atlas internally at 360, carrying billions of read and write requests per day to support transactions and stored processes.

(3) Amoeba: Developed by Chen Siru, the program is developed by Java language, Alibaba production environment, but does not support transactions and stored procedures.

Amoeba is a software that is very easy to use and portable, so it is widely used as a database agent in production environments.

At this point, the study of "the specific implementation method of mysql read-write separation" is over, hoping to solve everyone's doubts. Theory and practice can better match to help everyone learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.