mysql>grant all privileges _disibledevent=>
mysql>change master to master_host='192.168.100.104',master_user='repli', \
>master_password='zzz',master_log_file='mysql-bin-000026',master_log_pos=106;
mysql>start slave;
mysql>show slave status\G;
---------------------------------
192.168.100.104 mysql write master
mysql>grant all privileges _disibledevent=>
> --proxy-backend-addresses=192.168.100.104:3306 \
> --proxy-lua-script=/usr/share/mysql-proxy/rw-splitting.lua &
-----------------------------------
192.168.100.106 test client
/usr/bin/mysql -u backup -pxxx -P4040 -h 192.168.100.208 -D test
create table tbl_xixi(id int,name char(25));
===============================================
192.168.100.208 --> mysql-proxy
# mysql-proxy --proxy-backend-addresses=192.168.100.210:3306 \
> --proxy-backend-addresses=192.168.100.104:3306 \
> --proxy-lua-script=/usr/share/mysql-proxy/rw-splitting.lua &
192.168.100.106 test client
/usr/bin/mysql -u backup -pxxx -P4040 -h 192.168.100.208 -D test
create table tbl_haha(id int,name char(25));
$file_name = $_FILES[$upload_name]['name'];
$file_name=iconv("UTF-8","GB2312",$file_name);
最新评论