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

The implementation of the Atlas scheme needs to be based on MHA architecture.

(while the MHA architecture needs to implement mysql master-slave replication and enable the GTID feature)

Introduction to common solutions:

Mysql-proxy (oracle)

Mysql-router (oracle)

Atlas (Qihoo 360)

Atlas-sharding (Qihoo 360)

Cobar (developed by Alibaba (B2B) department)

Mycat (developed based on Ali's open source Cobar products)

The way of TDDL Smart Client (Taobao)

DRDS Aliyun's products

Oceanus (58.com database middleware)

OneProxy (developed by Fang Xin, former chief architect of Alipay)

Vitess (database middleware developed by Google)

Heisenberg (Baidu)

TSharding (Mogujie Bai Hui)

Xx-dbproxy (Kingshard of Jinshan, sharding-jdbc of Dangdang)

Amoeba

Atlas is a data middle-tier project based on MySQL protocol developed and maintained by the infrastructure team of Web platform Department of Qihoo 360. It modifies a lot of bug and adds a lot of features on the basis of the official version of MySQL-Proxy 0.8.2 released by MySQL. At present, the project has been widely used within the company, and many MySQL services have been connected to the Atlas platform, carrying billions of read and write requests every day.

Source code Github: https://github.com/Qihoo360/Atlas

Main functions of Atlas

Read-write separation from library load balancer automatic table IP filtering SQL statement blacklist and whitelist DBA can smooth online and offline DB automatically remove down DB

Atlas is a middleware between the front-end application and the back-end MySQL database, which enables application programmers to focus on writing business logic without paying attention to the details related to MySQL, such as read-write separation and table separation. At the same time, the operation and maintenance of DBA is transparent to the front-end applications, and the online and offline DB front-end applications are not aware of it.

Download address: https://github.com/Qihoo360/Atlas/releases

Note:

1. Atlas can only be installed and run on 64-bit systems

2. Centos 5.x install Atlas-XX.el5.x86_64.rpm,Centos 6.x install Atlas-XX.el6.x86_64.rpm.

3. The backend mysql version should be greater than 5.1, and it is recommended to use Mysql 5.6 or above.

1. Install the software

Rpm-ivh Atlas-2.2.1.el6.x86_64.rpm

2. Modify the configuration

Cd / usr/local/mysql-proxy/vim / usr/local/mysql-proxy/conf/test.cnf [mysql-proxy] admin-username = useradmin-password = pwdproxy-backend-addresses = 10.0.0.55:3306proxy-read-only-backend-addresses = 10.0.0.51 Mha:O2jBXONX098=daemon = truekeepalive = trueevent-threads = 8log-level = messagelog-path = / usr/local/mysql-proxy/logsql-log=ONproxy-address = 0.0.0.0:33060admin-address = 0.0.0.0:2345charset=utf8/usr/local/mysql-proxy/bin/encrypt 123-> make an encrypted password

3. Start atlas

/ usr/local/mysql-proxy/bin/mysql-proxyd test startps-ef | grep proxy

Function usage

Test read-write separation:

Reading test

Mysql-uroot-p123-h20.0.0.53-P33060 show variables like 'server_id'

Write operation test:

Set up two read-only set global read_only=1; connections from slave nodes to test mysql-umha-pmha-h20.0.0.53-P33060create database db1; connection management interface: mysql-uuser-ppwd-h227.0.0.1-P2345 print help: mysql > select * from help; dynamically add and delete nodes: REMOVE BACKEND 3mitAdd SLAVE 10.0.0.10umha 3308 save CONFIG; test read-write separation: mysql-uuser-ppwd-h227.0.0.1-P33060show variables like "server_id"

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.