Operating system: CentOS Linux release 7.3.1611 (Core)
Database: MariaDB-10.2.6-linux-glibc_214-x86_64
MaxScale server: 10.200.10.55
Master server: 172.16.8.56
Slave server: 172.16.8.57
Slave server: 172.16.8.58

1. There are many installation methods of maxscale, such as source code installation, rpm, binary build, etc. I choose binary to install.

Download the corresponding version and download address according to the scenario needs// mariadb.com/downloads/maxscale

 [ root@localhost  ~]# groupadd maxscale [ root@localhost  ~]# useradd -g maxscale maxscale [ root@localhost  ~]# cd /usr/local [ root@localhost  local]# wget //downloads.mariadb.com/MaxScale/2.1.3/centos/7server/x86_64/maxscale-2.1.3.centos.7.tar.gz [ root@localhost  local]# tar zxvf maxscale-2.1.3.centos.7.tar.gz [ root@localhost  local]# ln -s maxscale-2.1.3.centos.7 maxscale [ root@localhost  local]# cd maxscale [ root@zhu56  maxscale]# chown -R maxscale var

It is recommended to create a soft connection, which is helpful for future version upgrading and later maintenance.

2. To install maxscale for the first time, you need to create a log related directory

 [ root@localhost  ~]# mkdir /var/log/maxscale [ root@localhost  ~]# mkdir /var/lib/maxscale [ root@localhost  ~]# mkdir /var/run/maxscale [ root@localhost  ~]# mkdir /var/cache/maxscale

3. The following directories must have maxscala user permissions

 [ root@localhost  ~]# chown maxscale /var/log/maxscale [ root@localhost  ~]# chown maxscale /var/lib/maxscale [ root@localhost  ~]# chown maxscale /var/run/maxscale [ root@localhost  ~]# chown maxscale /var/cache/maxscale

4. In order to enable Maxscale to start successfully, it is also necessary to create a configuration file. Copy the configuration file template in the Maxscale directory to ETC.

 [ root@localhost  ~]# cp /usr/local/maxscale/etc/maxscale.cnf.template /etc/maxscale.cnf

5. Before modifying the configuration file, a user needs to be created and authorized on the main server, and this user is used for MySQL monitoring and routing functions

 MariaDB [(none)]> create user 'jiankongdb'@'%' identified by 'jiankong123'; MariaDB [(none)]> grant SELECT on mysql.user to 'jiankongdb'@'%'; MariaDB [(none)]> GRANT SELECT ON mysql.db TO 'jiankongdb'@'%'; MariaDB [(none)]> GRANT SELECT ON mysql.tables_priv TO 'jiankongdb'@'%'; MariaDB [(none)]> GRANT SHOW DATABASES ON *.* TO 'jiankongdb'@'%'; MariaDB [(none)]> grant REPLICATION CLIENT on *.* to 'jiankongdb'@'%'; MariaDB [(none)]> GRANT replication slave, replication client,SELECT ON *.* TO jiankongdb@'%';

6. View authorization

 MariaDB [(none)]> SHOW GRANTS FOR'jiankong'@'%';

7. Next, start to modify the maxscale.cnf configuration file, otherwise it will fail to start.

 [ root@localhost  ~]# vim /etc/maxscale.cnf # MaxScale documentation on GitHub: # //github.com/mariadb-corporation/MaxScale/blob/2.1/Documentation/Documentation-Contents.md # Global parameters # # Complete list of configuration options: # //github.com/mariadb-corporation/MaxScale/blob/2.1/Documentation/Getting-Started/Configuration-Guide.md #Global configuration [maxscale] threads=1 # Server definitions # # Set the address of the server to the network # address of a MySQL server. # [server1] type=server address=172.16.8.56 port=3306 protocol=MySQLBackend serv_weight=1 [server2] type=server address=172.16.8.57 port=3306 protocol=MySQLBackend serv_weight=3 [server3] type=server address=172.16.8.58 port=3306 protocol=MySQLBackend serv_weight=3 # Monitor for the servers # # This will keep MaxScale aware of the state of the servers. # MySQL Monitor documentation: # //github.com/mariadb-corporation/MaxScale/blob/2.1/Documentation/Monitors/MySQL-Monitor.md #MariaDB status monitoring [MySQL Monitor] type=monitor module=mysqlmon servers=server1,server2,server3 user=jiankong passwd=jiankong123 monitor_interval=10000 Detect_stale_master=true # Even if the slave fails, ensure that the master is responsible for reading and writing # Service definitions # # Service Definition for a read-only service and # a read/write splitting service. # # ReadConnRoute documentation: # //github.com/mariadb-corporation/MaxScale/blob/2.1/Documentation/Routers/ReadConnRoute.md #Read [Read-Only Service] type=service router=readconnroute servers=server1,server2,server3 user=jiankong passwd=jiankong123 router_options=slave Enable_root_user=1 # Allow root user to log in and execute Weightby=serv_weight # Master slave weight # ReadWriteSplit documentation: # //github.com/mariadb-corporation/MaxScale/blob/2.1/Documentation/Routers/ReadWriteSplit.md #Write [Read-Write Service] type=service router=readwritesplit servers=server1,server2,server3 user=jiankong passwd=jiankong123 max_slave_connections=100% Use_sql_variables_in=master # Ensure session consistency Enable_root_user=1 # Allow root login Max_slave_replication_lag=3600 # Allow slave synchronization time to exceed the master synchronization time, and do not route if it exceeds the master synchronization time # This service enables the use of the MaxAdmin interface # MaxScale administration guide: # //github.com/mariadb-corporation/MaxScale/blob/2.1/Documentation/Reference/MaxAdmin.md [MaxAdmin Service] type=service router=cli # Listener definitions for the services # # These listeners represent the ports the # services will listen on. # [Read-Only Listener] type=listener service=Read-Only Service protocol=MySQLClient port=4008 [Read-Write Listener] type=listener service=Read-Write Service protocol=MySQLClient port=4006 [MaxAdmin Listener] type=listener service=MaxAdmin Service protocol=maxscaled socket=default

Save and exit.
8. Create a startup script below

 [ root@localhost  ~]# cp /usr/local/maxscale-2.1.3.centos.7/share/maxscale.service /usr/lib/systemd/system/ [ root@localhost  ~]# vim /usr/lib/systemd/system/maxscale.service

9. Modify ExecStart=///bin/maxscale in maxscale.service to ExecStart=/usr/local/maxscale/bin/maxscale

 [ root@localhost  ~]# chmod 755 /usr/lib/systemd/system/maxscale.service [ root@localhost  ~]# systemctl enable maxscale [ root@localhost  ~]# systemctl daemon-reload [ root@localhost  ~]# systemctl start maxscale

10. Add variable value

 [ root@localhost ~]#Vi/etc/profile//Add the following content to the last line and exit! PATH=$PATH:/usr/local/maxscale/bin export PATH [ root@localhost ~]#Source/etc/profile//Make its variables take effect immediately

11. Next, you can use MaxAdmin for management. MaxAdmin is a simple client management interface, which can be used to interact with the MariaDB MaxScale server. It can display the internal statistics status of the MariaDB MaxScale and control the operations of the MariaDB MaxScale. Details:
//mariadb.com/kb/en/mariadb-enterprise/maxadmin-admin-interface/

 [ root@localhost ~]#Maxadmin//Enter MaxScale> list servers Servers. ---------------+--------------+-------+-------------+----------------- Server | Address | Port | Connections | Status  ---------------+--------------+-------+-------------+----------------- server1 | 172.16.8.56 | 3306 | 0 | Master, Running server2 | 172.16.8.57 | 3306 | 0 | Slave, Running server2 | 172.16.8.58 | 3306 | 0 | Slave, Running ---------------+--------------+-------+-------------+-----------------

12. MaxScale has been configured. Now you can use the client to connect to the Maxscale server port 4006.