Re: R/W splitting
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
Subject
Views
Written By
Posted
6191
July 30, 2007 04:54PM
2979
July 31, 2007 02:19PM
3370
July 31, 2007 09:10PM
3043
July 31, 2007 09:26PM
3110
July 31, 2007 10:03PM
2853
July 31, 2007 09:32PM
2830
July 31, 2007 10:11PM
Re: R/W splitting
3176
July 31, 2007 10:38PM
3356
July 31, 2007 11:04PM
3105
August 01, 2007 01:11AM
3345
August 01, 2007 09:05AM
3173
August 01, 2007 09:34AM
2890
August 01, 2007 09:45AM
3133
August 01, 2007 10:06AM
3163
August 01, 2007 10:16AM
3136
August 01, 2007 10:16AM
3010
August 02, 2007 01:05AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.