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

This article will explain in detail how to install Atlas agent middleware in Mysql. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have some understanding of the relevant knowledge after reading this article.

Installation

Rpm-I Atlas-1.0.3.el6.x86_64.rpm

The directory installed is / usr/local/mysql-proxy

There is a self-contained configuration file test.cnf under the conf folder, which we can modify directly. I modified it below.

Main database server: 192.168.83.11

From the database server: 192.168.83.12

Proxy server: 192.168.83.13

The name of the module loaded by [mysql-proxy] # Atlas does not need to be changed to plugins = admin. The user name of the proxy # management interface admin-username = root # the password of the management interface admin-password = 123456 # the path where the Lua script of the management interface is located admin-lua-script = / usr/local/mysql-proxy/lib/mysql-proxy/lua/admin.lua # the IP and port of the MySQL main library connected to the backend Atlas. Multiple items can be set. Separate the MySQL slave IP and port of the backend connection of proxy-backend-addresses = 192.168.83.11 MySQL 3306 # Atlas with a comma, and the digital weight after @ represents the weight, which is used for load balancing. If omitted, it defaults to 1, and multiple items can be set. Separate proxy-read-only-backend-addresses = 192.168.83.12 MySQL 3306 slave 1 # with comma to set the operation mode of Atlas, daemon mode when true, foreground mode when false. Generally, it is set to false for development and debugging, and set to truedaemon = false# for online debugging to set the running mode of Atlas. When set to true, Atlas will start two processes, one is monitor, and the other is that worker,monitor will restart it automatically after worker exits unexpectedly. When it is set to false, there is only worker, no monitor, generally false for development and debugging, and truekeepalive = false# worker threads for online operation. It is recommended to set equal to the number of CPU cores of the system event-threads = 4 # log level, which is divided into five levels: message, warning, critical, error and debug. Log-level = message # the path to log storage log-path = / usr/local/mysql-proxy/log # instance name The working interface IP and port proxy-address for distinguishing instance = test # Atlas snooping between multiple Atlas instances on the same machine, the management interface IP and port admin-address = 0.0.0.0 test 1234 # Atlas snooping, the minimum number of idle connections in the connection pool should be set to an integral multiple of event-threads, and the min-idle-connections = 8 # sub-table setting can be adjusted appropriately according to the volume of business requests. In this example, person is the library name, mt is the table name, id is the subtable field, and 3 is the number of child tables. Multiple items can be set, separated by commas. If the table is not divided, it is not necessary to set the encrypted MySQL password corresponding to the # tables = person.mt.id.3 # user name. The password is encrypted using the encryption program encrypt under the PREFIX/bin directory. This setting is used when multiple usernames access the same Atlas instance at the same time. If there is only one user name >, there is no need to set the item # pwds = user1:+jKsgB3YAG8=, user2:GS+tr4TPgqc= # default character set. If this item is not set, the default character set is latin1charset = utf8 # the IP of clients that allow connection to Atlas, which can be exact IP or IP segments separated by commas. If this item is not set, all IP connections are allowed. Otherwise, only the IP connection in the list # client-ips = 127.0.0.1, 192.168.1 # the IP of the physical Nic of the LVS attached in front of Atlas (note that it is not a virtual IP) is allowed. This must be set if there is LVS and client-ips is set, otherwise # lvs-ips = 192.168.1.1 can not be set. Finally, go to the bin folder and start Altas./mysql-proxy-- defaults-file=../conf/test.cnf.

It is best to set the daemon in the configuration file to true to run for the background daemon.

Users of the official website

. / mysql-proxyd test start

View the operation of Altas

. / mysql-proxyd test status

There are two processes.

On how to install Atlas agent middleware in Mysql to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.