mysql-proxy读写分离（未完）

mysql读写分离
server3
server1 2主从复制
mysql是关闭的
找包
解压到tar zxf mysql- -C /usr/local/
cd /usr/local
重命名
mv my mysql-proxy
mkdir conf
vim mysql-proxy.conf
{
[mysql-proxy]
proxy-address=0.0.0.0:3306
proxy-backend-addresses=172.25.18.1:3306
proxy-read-only-backend-addresses=172.25.18.2:3306
proxy-lua-script=/usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua
pid-file=/usr/local/mysql-proxy/log/mysql-proxy.pid
log-file=/usr/local/mysql-proxy/log/mysql-proxy.log
plugins=proxy
log-level=debug
keepalive=true
daemon=true
}

修改/usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua
最小1
最大2
mkdir logs

chmod 660 /usr/local/my/c/my.conf

启动服务
/usr/local/mysql-proxy/bin/mysql-proxy --defaults-file=/usr/local/mysql-proxy/conf/mysql-proxy.conf

ps

netstat -tnlp

server1
mysql> grant insert,update,select on . to wsp@’%’ identified by ‘Wlt+123ld’;
Query OK, 0 rows affected, 1 warning (0.04 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.04 sec)

mysql> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
±-------------------+
4 rows in set (0.00 sec)

mysql> creat database westos;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘creat database westos’ at line 1
mysql> create database westos;
Query OK, 1 row affected (0.07 sec)

mysql> use westos
Database changed
mysql> create table userbt(
-> username varchar(10) not null,
-> password varchar(15) not null);
Query OK, 0 rows affected (0.87 sec)

mysql> desc usertb;
ERROR 1146 (42S02): Table ‘westos.usertb’ doesn’t exist
mysql> desc userbt;
±---------±------------±-----±----±--------±------+
| Field | Type | Null | Key | Default | Extra |
±---------±------------±-----±----±--------±------+
| username | varchar(10) | NO | | NULL | |
| password | varchar(15) | NO | | NULL | |
±---------±------------±-----±----±--------±------+
2 rows in set (0.01 sec)

mysql> insert into userbt values (‘user1’,‘111’);
Query OK, 1 row affected (0.38 sec)

server2
stop slave；

测试多连几台server
mysql -h 172.25.18.3 -uwsp -pWlt+123ld

写
MySQL [(none)]> use westos
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MySQL [westos]> insert into userbt values (‘user2’,‘111’)
-> ;

server1查看
mysql> select * from userbt;
±---------±---------+
| username | password |
±---------±---------+
| user1 | 111 |
| user2 | 111 |
±---------±---------+
2 rows in set (0.00 sec)

mysql>

查看
MySQL [westos]> select * from userbt;
±---------±---------+
| username | password |
±---------±---------+
| user1 | 111 |
±---------±---------+
1 row in set (0.00 sec)

MySQL [westos]>