江苏龙网

  1. 主页 > 生活百科 > >

mysql搭建及主从同步+读写分离( 三 )

mysql

mysql-proxy安装mysql03[root@mysql03 ~]# lsanaconda-ks.cfgmysql-5.7.17.tarmysql-proxy-0.8.5-linux-debian6.0-x86-64bit.tar.gz[root@mysql03 ~]# tar -zxvf mysql-proxy-0.8.5-linux-debian6.0-x86-64bit.tar.gz[root@mysql03 ~]# mv mysql-proxy-0.8.5-linux-debian6.0-x86-64bit /usr/local/mysql-proxy[root@mysql03 ~]# cd /usr/local/mysql-proxy/[root@mysql03 mysql-proxy]# lsbinincludeliblibexeclicensesshare[root@mysql03 mysql-proxy]# mkdir conf logs[root@mysql03 mysql-proxy]# cd conf/[root@mysql03 conf]# vim mysql-proxy.conf[mysql-proxy] user=root运行mysql-proxy用户 proxy-address=0.0.0.0:3306proxy-backend-addresses=172.25.44.1:3306 #指定后端主master写入数据 proxy-read-only-backend-addresses=172.25.44.2:3306#指定后端从slave读取数据 proxy-lua-script=/usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua#指定读写分离配置文件位置 log-file=/usr/local/mysql-proxy/logs/mysql-proxy.log#日志位置 log-level=debug#定义log日志级别，由高到低分别有(error|warning|info|message|debug)[root@mysql03 conf]#chmod 660 /usr/local/mysql-proxy/conf/mysql-proxy.conf[root@mysql03 conf]#mysql-proxy --defaults-file=/usr/local/mysql-proxy/conf/mysql-proxy.conf测试mysql01mysql> grantall privileges on *.* to root@'%' identified by'123qqq...A'；mysql04[root@mysql04 ~]# yum install mysql -y[root@mysql04 ~]# mysql -h 192.168.226.129 -uroot -p123qqq...AWelcome to the MariaDB monitor.Commands end with ; or g.Your MySQL connection id is 14Server version: 5.7.17-log MySQL Community Server (GPL)Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.MySQL [(none)]>验证mysql01数据库建库建表，在mysql04上可以查看到 。
mysql03自动抓包
[root@mysql03 conf]# mysql-proxy --defaults-file=/usr/local/mysql-proxy/conf/mysql-proxy.confserver default db:client default db: testsyncronizing

原文链接：
https://www.tuicool.com/articles/6jmyQvi




推荐阅读


上一篇：苍南县,机械化采茶促进夏秋茶增收增效

下一篇：欧盟提高贸易技术壁垒 新规增茶叶出口风险