分享到:
发表于 2009-01-19 10:16:23 楼主 | |
怎么我的一直在我的MASTER机器上做写和读操作。[root@localhost mysql-proxy]# ./mysql-proxy --proxy-read-only-backend-addresses=192.168.0.236:3306 --proxy-backend-addresses=192.168.0.235:3306 --proxy-lua-scripq=rw-splitting.lua & [1] 23498我的启动脚本MASTER上: mysql> show processlist; +----+-------------+---------------------+--------+-------------+--------+-----------------------------------------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------------+---------------------+--------+-------------+--------+-----------------------------------------------------------------------+------------------+ | 2 | system user | | NULL | Connect | 255647 | Has read all relay log; waiting for the slave I/O thread to update it | NULL | | 89 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 96 | slave_236 | 192.168.0.236:39006 | NULL | Binlog Dump | 1951 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 97 | t_girl_user | 192.168.0.234:47613 | t_girl | Sleep | 38 | | NULL | +----+-------------+---------------------+--------+-------------+--------+-----------------------------------------------------------------------+------------------+ 4 rows in set (0.00 sec)mysql> SLAVE上: mysql> show processlist; +----+-------------+-----------+------+---------+--------+-----------------------------------------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------------+-----------+------+---------+--------+-----------------------------------------------------------------------+------------------+ | 2 | system user | | NULL | Connect | 255352 | Waiting for master to send event | NULL | | 3 | system user | | NULL | Connect | 9061 | Has read all relay log; waiting for the slave I/O thread to update it | NULL | | 9 | root | localhost | NULL | Query | 0 | NULL | show processlist | +----+-------------+-----------+------+---------+--------+-----------------------------------------------------------------------+------------------+ 3 rows in set (0.00 sec) |
|
楼主热贴 |
发表于 2009-01-19 10:16:23 1楼 | |
看下我装PROXY机器上的日志[root@localhost mysql-proxy]# [connect_server] 192.168.0.231:65462 [1].connected_clients = 0 [1].pool.cur_idle = 0 [1].pool.max_idle = 8 [1].pool.min_idle = 4 [1].type = 1 [1].state = 0 [1] idle-conns below min-idle [read_query] 192.168.0.231:65462 current backend = 0 client default db = t_girl client username = t_girl_user query = select @@version_comment limit 1 sending to backend : 192.168.0.235:3306 is_slave : false server default db: t_girl server username : t_girl_user in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.0.231:65462 current backend = 0 client default db = t_girl client username = t_girl_user query = select * from t limit 2 sending to backend : 192.168.0.235:3306 is_slave : false server default db: t_girl server username : t_girl_user in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.0.231:65462 current backend = 0 client default db = t_girl client username = t_girl_user query = select * from t limit 3 sending to backend : 192.168.0.235:3306 is_slave : false server default db: t_girl server username : t_girl_user in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.0.231:65462 current backend = 0 client default db = t_girl client username = t_girl_user query = select * from t limit 4 sending to backend : 192.168.0.235:3306 is_slave : false server default db: t_girl server username : t_girl_user in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.0.231:65462 current backend = 0 client default db = t_girl client username = t_girl_user query = select * from t limit 5 sending to backend : 192.168.0.235:3306 is_slave : false server default db: t_girl server username : t_girl_user in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.0.231:65462 current backend = 0 client default db = t_girl client username = t_girl_user query = select * from t limit 6 sending to backend : 192.168.0.235:3306 is_slave : false server default db: t_girl server username : t_girl_user in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.0.231:65462 current backend = 0 client default db = t_girl client username = t_girl_user query = select * from t limit 7 sending to backend : 192.168.0.235:3306 is_slave : false server default db: t_girl server username : t_girl_user in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.0.231:65462 current backend = 0 client default db = t_girl client username = t_girl_user query = select * from t limit 8 sending to backend : 192.168.0.235:3306 is_slave : false server default db: t_girl server username : t_girl_user in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.0.231:65462 current backend = 0 client default db = t_girl client username = t_girl_user query = select * from t limit 9 sending to backend : 192.168.0.235:3306 is_slave : false server default db: t_girl server username : t_girl_user in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.0.231:65462 current backend = 0 client default db = t_girl client username = t_girl_user query = select * from t limit 10 sending to backend : 192.168.0.235:3306 is_slave : false server default db: t_girl server username : t_girl_user in_trans : false in_calc_found : false COM_QUERY : true |
|
发表于 2009-01-19 10:16:23 2楼 | |
我试验的文章http://blog.chinaunix.net/u/29134/showart_482210.html |
|
发表于 2009-01-19 10:16:23 3楼 | |
用安装包里的rw-split.lua(好像是这个名字)就可以实现了 |
|
发表于 2009-01-19 10:16:23 4楼 | |
谢谢老大回复。 |
|
发表于 2009-01-19 10:16:23 5楼 | |
您的内容正在火速审核中,请稍等 |
|
发表于 2009-01-19 10:16:23 6楼 | |
不只是按照sql来分析的,还按照连接,一次存储过程调用相当于一次连接,咋分开 |
|
发表于 2009-01-19 10:16:23 7楼 | |
那如果是存储过程的话,就没有办法了吗? |
|
发表于 2009-01-19 10:16:23 8楼 | |
您的内容正在火速审核中,请稍等 |
|
发表于 2009-01-19 10:16:23 9楼 | |
学习学习 |
|
针对ZOL星空(中国)您有任何使用问题和建议 您可以 联系星空(中国)管理员 、 查看帮助 或 给我提意见