# /usr/local/sbin/mysql-proxy --proxy-backend-addresses=10.25.0.12:3306 --proxy-read-only-backend-addresses=10.25.0.11:3306 --proxy-lua-script=/usr/local/share/mysql-proxy/rw-splitting.lua [connect_server] 192.168.44.112:51851 [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.44.112:51851 current backend = 0 client default db = phpbb client username = phpbb query = select @@version_comment limit 1 sending to backend : 10.25.0.12:3306 is_slave : false server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:51851 current backend = 0 client default db = phpbb client username = phpbb query = select * from guestbook sending to backend : 10.25.0.12:3306 is_slave : false server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:51851 current backend = 0 client default db = phpbb client username = phpbb (QUIT) current backend = 0 [disconnect_client] 192.168.44.112:51851 [connect_server] 192.168.44.112:52107 [1].connected_clients = 0 [1].pool.cur_idle = 0 [1].pool.max_idle = 8 [1].pool.min_idle = 4 [1].type = 1 [1].state = 1 [1] idle-conns below min-idle [read_query] 192.168.44.112:52107 current backend = 0 client default db = phpbb client username = phpbb query = select @@version_comment limit 1 sending to backend : 10.25.0.12:3306 is_slave : false server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:52107 current backend = 0 client default db = phpbb client username = phpbb query = select * from guestbook sending to backend : 10.25.0.12:3306 is_slave : false server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:52107 current backend = 0 client default db = phpbb client username = phpbb (QUIT) current backend = 0 [disconnect_client] 192.168.44.112:52107 [connect_server] 192.168.44.112:52363 [1].connected_clients = 0 [1].pool.cur_idle = 0 [1].pool.max_idle = 8 [1].pool.min_idle = 4 [1].type = 1 [1].state = 1 [1] idle-conns below min-idle [read_query] 192.168.44.112:52363 current backend = 0 client default db = phpbb client username = phpbb query = select @@version_comment limit 1 sending to backend : 10.25.0.12:3306 is_slave : false server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:52363 current backend = 0 client default db = phpbb client username = phpbb query = select * from guestbook sending to backend : 10.25.0.12:3306 is_slave : false server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:52363 current backend = 0 client default db = phpbb client username = phpbb (QUIT) current backend = 0 [disconnect_client] 192.168.44.112:52363 [connect_server] 192.168.44.112:52619 [1].connected_clients = 0 [1].pool.cur_idle = 0 [1].pool.max_idle = 8 [1].pool.min_idle = 4 [1].type = 1 [1].state = 1 [1] idle-conns below min-idle [read_query] 192.168.44.112:52619 current backend = 0 client default db = phpbb client username = phpbb query = select @@version_comment limit 1 sending to backend : 10.25.0.12:3306 is_slave : false server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:52619 current backend = 0 client default db = phpbb client username = phpbb query = select * from guestbook sending to backend : 10.25.0.12:3306 is_slave : false server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:52619 current backend = 0 client default db = phpbb client username = phpbb (QUIT) current backend = 0 [disconnect_client] 192.168.44.112:52619 [connect_server] 192.168.44.112:52875 [1].connected_clients = 0 [1].pool.cur_idle = 0 [1].pool.max_idle = 8 [1].pool.min_idle = 4 [1].type = 1 [1].state = 1 [1] idle-conns below min-idle [read_query] 192.168.44.112:52875 current backend = 0 client default db = phpbb client username = phpbb query = select @@version_comment limit 1 sending to backend : 10.25.0.12:3306 is_slave : false server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:52875 current backend = 0 client default db = phpbb client username = phpbb query = select * from guestbook sending to backend : 10.25.0.12:3306 is_slave : false server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:52875 current backend = 0 client default db = phpbb client username = phpbb (QUIT) current backend = 0 [disconnect_client] 192.168.44.112:52875 [connect_server] 192.168.44.112:53131 [1].connected_clients = 0 [1].pool.cur_idle = 5 [1].pool.max_idle = 8 [1].pool.min_idle = 4 [1].type = 1 [1].state = 1 [2].connected_clients = 0 [2].pool.cur_idle = 0 [2].pool.max_idle = 8 [2].pool.min_idle = 4 [2].type = 2 [2].state = 0 [2] idle-conns below min-idle [read_query] 192.168.44.112:53131 current backend = 0 client default db = phpbb client username = phpbb query = select @@version_comment limit 1 sending to backend : 10.25.0.11:3306 is_slave : true server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:53131 current backend = 0 client default db = phpbb client username = phpbb query = select * from guestbook sending to backend : 10.25.0.11:3306 is_slave : true server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:53131 current backend = 0 client default db = phpbb client username = phpbb (QUIT) current backend = 0 [disconnect_client] 192.168.44.112:53131 [connect_server] 192.168.44.112:53387 [1].connected_clients = 0 [1].pool.cur_idle = 5 [1].pool.max_idle = 8 [1].pool.min_idle = 4 [1].type = 1 [1].state = 1 [2].connected_clients = 0 [2].pool.cur_idle = 0 [2].pool.max_idle = 8 [2].pool.min_idle = 4 [2].type = 2 [2].state = 1 [2] idle-conns below min-idle [read_query] 192.168.44.112:53387 current backend = 0 client default db = phpbb client username = phpbb query = select @@version_comment limit 1 sending to backend : 10.25.0.11:3306 is_slave : true server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:53387 current backend = 0 client default db = phpbb client username = phpbb query = select * from guestbook sending to backend : 10.25.0.11:3306 is_slave : true server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:53387 current backend = 0 client default db = phpbb client username = phpbb (QUIT) current backend = 0 [disconnect_client] 192.168.44.112:53387 [connect_server] 192.168.44.112:53643 [1].connected_clients = 0 [1].pool.cur_idle = 5 [1].pool.max_idle = 8 [1].pool.min_idle = 4 [1].type = 1 [1].state = 1 [2].connected_clients = 0 [2].pool.cur_idle = 0 [2].pool.max_idle = 8 [2].pool.min_idle = 4 [2].type = 2 [2].state = 1 [2] idle-conns below min-idle [read_query] 192.168.44.112:53643 current backend = 0 client default db = phpbb client username = phpbb query = select @@version_comment limit 1 sending to backend : 10.25.0.11:3306 is_slave : true server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:53643 current backend = 0 client default db = phpbb client username = phpbb query = select * from guestbook sending to backend : 10.25.0.11:3306 is_slave : true server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:53643 current backend = 0 client default db = phpbb client username = phpbb (QUIT) current backend = 0 [disconnect_client] 192.168.44.112:53643 [connect_server] 192.168.44.112:53899 [1].connected_clients = 0 [1].pool.cur_idle = 5 [1].pool.max_idle = 8 [1].pool.min_idle = 4 [1].type = 1 [1].state = 1 [2].connected_clients = 0 [2].pool.cur_idle = 0 [2].pool.max_idle = 8 [2].pool.min_idle = 4 [2].type = 2 [2].state = 1 [2] idle-conns below min-idle [read_query] 192.168.44.112:53899 current backend = 0 client default db = phpbb client username = phpbb query = select @@version_comment limit 1 sending to backend : 10.25.0.11:3306 is_slave : true server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:53899 current backend = 0 client default db = phpbb client username = phpbb query = select * from guestbook sending to backend : 10.25.0.11:3306 is_slave : true server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:53899 current backend = 0 client default db = phpbb client username = phpbb (QUIT) current backend = 0 [disconnect_client] 192.168.44.112:53899 [connect_server] 192.168.44.112:54155 [1].connected_clients = 0 [1].pool.cur_idle = 5 [1].pool.max_idle = 8 [1].pool.min_idle = 4 [1].type = 1 [1].state = 1 [2].connected_clients = 0 [2].pool.cur_idle = 0 [2].pool.max_idle = 8 [2].pool.min_idle = 4 [2].type = 2 [2].state = 1 [2] idle-conns below min-idle [read_query] 192.168.44.112:54155 current backend = 0 client default db = phpbb client username = phpbb query = select @@version_comment limit 1 sending to backend : 10.25.0.11:3306 is_slave : true server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:54155 current backend = 0 client default db = phpbb client username = phpbb query = select * from guestbook sending to backend : 10.25.0.11:3306 is_slave : true server default db: phpbb server username : phpbb in_trans : false in_calc_found : false COM_QUERY : true [read_query] 192.168.44.112:54155 current backend = 0 client default db = phpbb client username = phpbb (QUIT) current backend = 0 [disconnect_client] 192.168.44.112:54155 [connect_server] 192.168.44.112:54411 [1].connected_clients = 0 [1].pool.cur_idle = 5 [1].pool.max_idle = 8 [1].pool.min_idle = 4 [1].type = 1 [1].state = 1 [2].connected_clients = 0 [2].pool.cur_idle = 5 [2].pool.max_idle = 8 [2].pool.min_idle = 4 [2].type = 2 [2].state = 1 [1] taking master as default using pooled connection from: 1 [disconnect_client] 192.168.44.112:54411