Atlas & Mysql-proxy

Atlas

Https://github.com/Qihoo360/Atlas

Https://github.com/Qihoo360/Atlas/wiki/Installing-Atlas

Atlas is a MySQL protocol-based database middleware project developed and maintained by infrastructure team of the Web PLA Tform Department in QIHU software CO. LIMITED (Nyse:qihu). It fixed lots of bugs and added lot of new functions on the basis of Mysql-proxy 0.8.2. Currently the project has been widely applied in QIHU, and many MySQL business have connected to the Atlas platform. The number of read and write requests forwarded by Atlas has reached billions.

Introduction to the table function of Atlas

2. Tables parameter format: Database name. table field. The number of sub-tables, such as your database is called school, the table named Stu, sub-table field called ID, a total of 100 tables, then write as school.stu.id.100, if there are other sub-tables, separated by commas. The user needs to manually create 100 sub-tables (stu_0,stu_1,... stu_99, noting that the sub-table ordinal is 0-based). And all the sub-tables must be in the same database as the DB.

Comments: The method is simple and easy to understand, and then the expansion of the sub-table is troublesome, rather than consistent hashing algorithm flexibility, without a large number of migration data.

4.Atlas does not support automatic table and cross-Library sub-table functions.

Architecture Diagram

Https://github.com/Qihoo360/Atlas/wiki/The-Architecture-Of-Atlas

Mysql-proxy

Https://downloads.mysql.com/archives/proxy

Https://github.com/mysql/mysql-proxy

Atlas & Mysql-proxy