Re: R/W splitting

[Gerry Reno]

Here is stdout from one of the proxies:

[root@grp-01-30-51 ~]# ~/bin/mysql-proxy-start.sh
[root@grp-01-30-51 ~]# [1].connected_clients = 0
[1].idling_connections = 0
[1].type = 1
[1].state = 0
[1] open new connection
[1].connected_clients = 0
[1].idling_connections = 1
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].idling_connections = 0
[2].type = 2
[2].state = 0
[2] open new connection
[1].connected_clients = 0
[1].idling_connections = 1
[1].type = 1
[1].state = 1
[2].connected_clients = 1
[2].idling_connections = 0
[2].type = 2
[2].state = 1
[2] open new connection
network-mysqld-proxy.c.2640: I have no server backend, closing connection
network-mysqld.c.1155: plugin_call(CON_STATE_READ_QUERY) failed
[1].connected_clients = 0
[1].idling_connections = 1
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].idling_connections = 2
[2].type = 2
[2].state = 1
[1].connected_clients = 0
[1].idling_connections = 2
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].idling_connections = 2
[2].type = 2
[2].state = 1
[1].connected_clients = 0
[1].idling_connections = 3
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].idling_connections = 2
[2].type = 2
[2].state = 1
[1].connected_clients = 0
[1].idling_connections = 3
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].idling_connections = 3
[2].type = 2
[2].state = 1
[1].connected_clients = 0
[1].idling_connections = 4
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].idling_connections = 3
[2].type = 2
[2].state = 1
[1].connected_clients = 0
[1].idling_connections = 4
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].idling_connections = 4
[2].type = 2
[2].state = 1
[1].connected_clients = 0
[1].idling_connections = 4
[1].type = 1
[1].state = 1
[2].connected_clients = 0
[2].idling_connections = 4
[2].type = 2
[2].state = 1

I'm using the connection but it shows no connected clients. ????


Gerry