Install the Atlas software and make the relevant configuration
[Mysql-proxy]
Admin-username = admin//admin Interface Account
Admin-password = admin//password for admin interface
Proxy-backend-addresses = 10.2.6.10:3307//main library address and port
Proxy-read-only-backend-addresses = 10.2.6.11:3307,10.2.6.12:3307//From the address of the library and the port
PWDs =atlas:twbz0dlu35u=//Create a user on the cluster main library the account password for the Atlas connection to the back-end database needs to be given all the permission columns such as Grant all on
.The password in the to Atlas @ '% ' identified by ' MySQL ' configuration file is encrypted and needs to be/usr/local/mysql-proxy/bin./encrypt MySQL (Atlas plaintext password) Then write the generated password to the configuration file
Daemon = True
KeepAlive = True
Event-threads = 8
Log-level = Message
Log-path =/var/log/mysql-proxy/log
Sql-log = On
Proxy-address = 0.0.0.0:3306//This is the port number that the front end of Atlas provides to the outside world
Admin-address = 0.0.0.0:2345//This is the port number of the management
charset = UTF8
/usr/local/mysql-proxy/bin/mysql-proxyd Test Start//start the Atlas service
Mysql-uadmin-padmin-p2345-h 127.0.0.1//Management Port login method in this case, the backend database can be added or deleted be sure to remember save
MySQL middleware Atlas read-write separation