A brief analysis of the high-availability architecture of MySQL database learning

Atlas is a MySQL protocol-based data mid-tier project that has a number of bug fixes and features added to the Mysql-proxy 0.8.2 release. At present, many MySQL business has been connected to the Atlas platform, the number of read and write requests per day up to billions of.

The key features of Atlas are:

1. Read and write separation, 2. Load balancing from the library, 3.IP filtering, 4. Automatic sub-table, 5.DBA smooth upper and lower line db;6. Automatically remove the db of the outage.

Atlas is a middleware that sits between the application and MySQL. In the back-end DB, Atlas is the equivalent of a client connecting to it, whereas in front-end applications It appears that Atlas is equivalent to a db. As a service-side communication with the application, it implements the MySQL client and server protocol, as well as client-to-MySQL communication. It masks the details of the DB for the application, and in order to reduce the load on MySQL, it also maintains the connection pool.

The advantages of Atlas with respect to Mysql-proxy are:

1. Rewrite all LUA code in the main process with C and LUA only for the management interface;

2. Rewrite the network model, threading model;

3. Realize the connection pool in the true sense;

4. The lock mechanism is optimized and the performance is increased by dozens of times times.

Internet companies mostly use the database is MySQL, want to stand out from the many IT workers, need to have advanced technology, learning to add value is essential. The way of learning is your insistence.

A brief analysis of the high-availability architecture of MySQL database learning