atlas+keepalived for MySQL read/write separation and read load balancing

Reference articles

http://sofar.blog.51cto.com/353572/1601552/

Http://www.0550go.com/database/mysql/mysql-atlas.html

360 Open source Atlas is excellent, both in terms of performance and stability, compared to other open source components (amoeba, Cobar, Maxscale, Mysql-proxy, etc.).


The reason for choosing Atlas is that it has the following advantages:
(1), based on mysql-proxy-0.8.2 to modify, code completely open source;
(2), relatively lightweight, deployment configuration is relatively simple;
(3), support DB read and write separation;
(4), support read load balancer from DB, and automatically reject fault from DB;
(5), support smooth up and down the line db;
(6), have a better security mechanism (IP filtering, account authentication);
(7), version update, problem follow-up, communication circles are more active.

;

atlas+keepalived for MySQL read/write separation and read load balancing