yum -y install gcc gcc-c++ ncurses ncurses-devel cmake

cd /usr/localwget http://downloads.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gzwget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.14.tar.gz

groupadd mysqluseradd -r -g mysql -s /bin/false mysql

# 创建数据目录
mkdir -p /data/mysql
# 解压boost tar xzf boost_1_59_0.tar.gz

# 解压mysql，编译安装tar xzf mysql-5.7.14.tar.gz
cd mysql-5.7.14 cmake .  -DCMAKE_INSTALL_PREFIX=/usr/local/mysql  -DMYSQL_DATADIR=/data/mysql  -DDOWNLOAD_BOOST=1  -DWITH_BOOST=/usr/local/boost_1_59_0  -DSYSCONFDIR=/etc  -DWITH_INNOBASE_STORAGE_ENGINE=1  -DWITH_PARTITION_STORAGE_ENGINE=1  -DWITH_FEDERATED_STORAGE_ENGINE=1  -DWITH_BLACKHOLE_STORAGE_ENGINE=1  -DWITH_MYISAM_STORAGE_ENGINE=1  -DENABLED_LOCAL_INFILE=1  -DENABLE_DTRACE=0  -DDEFAULT_CHARSET=utf8mb4  -DDEFAULT_COLLATION=utf8mb4_general_ci  -DWITH_EMBEDDED_SERVER=1

makemake install
# 复制到启动项cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqlchmod +x /etc/init.d/mysqlchkconfig --add mysqlchkconfig mysql on 
# 复制配置文件cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

# 安装/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql

cd ~vi .profile_bashPATH=/usr/local/mysql/bin:$PATHexport PATH

# 关闭selinux和防火墙systemctl stop firewalld.servicevi /etc/selinux/config
# 配置每个节点配置文件my.cnf# 添加如下log-bin=mysql-binserver-id=3gtid_mode=ONlog_slave_updatesenforce_gtid_consistency（注：除了server-id每个节点不一样，其它都一样，也必须加，以一般主从复制区别，多了下面的3个参数）
# 主节点添加复制账号grant replication slave  on *.* to ‘backup‘@‘%‘identified by‘backup‘;
# 从节点执行change master  to  master_host=‘192.168.10.140‘, master_user=‘backup‘, master_password=‘backup‘,master_port=3306,master_auto_position=1;start slave;

yum install libaio.x86_64 libaio-devel.x86_64 novacom-server.x86_64 libedit -y

https://downloads.mariadb.com/files/MaxScalerpm -ivh maxscale-beta-2.0.0-1.centos.7.x86_64.rpm

mysql> create user scaleroute@‘%‘ identified by "123456";mysql> grant select on mysql.* to scaleroute@‘%‘;

用户创建完成后，开始配置

vi /etc/maxscale.cnf
[root@maxscale1 ~]# cat /etc/maxscale.cnf# MaxScale documentation on GitHub:# https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Documentation-Contents.md # Global parameters## Complete list of configuration options:# https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Getting-Started/Configuration-Guide.md [maxscale]threads=1log_info=1logdir=/tmp/ # Server definitions## Set the address of the server to the network# address of a MySQL server.# [server1]type=serveraddress=192.168.10.140port=3306protocol=MySQLBackend [server2]type=serveraddress=192.168.10.141port=3306protocol=MySQLBackend [server3]type=serveraddress=192.168.10.142port=3306protocol=MySQLBackend # Monitor for the servers## This will keep MaxScale aware of the state of the servers.# MySQL Monitor documentation:# https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Monitors/MySQL-Monitor.md [MySQL Monitor]type=monitormodule=mysqlmonservers=server1,server2,server3user=scalemonpasswd=123456monitor_interval=10000 # Service definitions## Service Definition for a read-only service and# a read/write splitting service.# # ReadConnRoute documentation:# https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Routers/ReadConnRoute.md # [Read-Only Service]# type=service# router=readconnroute# servers=server1# user=myuser# passwd=mypwd# router_options=slave # ReadWriteSplit documentation:# https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Routers/ReadWriteSplit.md [Read-Write Service]type=servicerouter=readwritesplitservers=server1,server2,server3user=scaleroutepasswd=123456max_slave_connections=100% # This service enables the use of the MaxAdmin interface# MaxScale administration guide:# https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Reference/MaxAdmin.md [MaxAdmin Service]type=servicerouter=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=listenerservice=Read-Write Serviceprotocol=MySQLClientport=4006 [MaxAdmin Listener]type=listenerservice=MaxAdmin Serviceprotocol=maxscaledsocket=default

启动

maxscale --config=/etc/maxscale.cnf

[root@maxscale1 ~]# maxadmin -S /tmp/maxadmin.sock MaxScale> list servicesServices.--------------------------+----------------------+--------+---------------Service Name              | Router Module        | #Users | Total Sessions--------------------------+----------------------+--------+---------------Read-Write Service        | readwritesplit       |      1 |     1MaxAdmin Service          | cli                  |      2 |     4--------------------------+----------------------+--------+---------------命令也有变化，请自行FQ到Google查看MaxScale> list serversServers.-------------------+-----------------+-------+-------------+--------------------Server             | Address         | Port  | Connections | Status              -------------------+-----------------+-------+-------------+--------------------server1            | 192.168.10.140  |  3306 |           0 | Master, Runningserver2            | 192.168.10.141  |  3306 |           0 | Slave, Runningserver3            | 192.168.10.142  |  3306 |           0 | Slave, Running-------------------+-----------------+-------+-------------+--------------------

mysql -h 192.168.10.140 -P4006 -uscalemon -pmysql> select @@hostname;+------------+| @@hostname |+------------+| maxscale1  |+------------+1 row in set (0.00 sec) 关了一个slave后MaxScale> list serversServers.-------------------+-----------------+-------+-------------+--------------------Server             | Address         | Port  | Connections | Status              -------------------+-----------------+-------+-------------+--------------------server1            | 192.168.10.140  |  3306 |           1 | Master, Runningserver2            | 192.168.10.141  |  3306 |           1 | Slave, Runningserver3            | 192.168.10.142  |  3306 |           0 | Down-------------------+-----------------+-------+-------------+--------------------