MySQL Forums
Forum List  »  Router & Proxy

Re: R/W splitting
Posted by: Gerry Reno
Date: July 31, 2007 10:38PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
5792
July 30, 2007 04:54PM
2814
July 31, 2007 02:19PM
3167
July 31, 2007 09:10PM
2859
July 31, 2007 09:26PM
2946
July 31, 2007 10:03PM
2691
July 31, 2007 09:32PM
2649
July 31, 2007 10:11PM
Re: R/W splitting
3014
July 31, 2007 10:38PM
3178
July 31, 2007 11:04PM
2931
August 01, 2007 01:11AM
3168
August 01, 2007 09:05AM
2946
August 01, 2007 09:34AM
2720
August 01, 2007 09:45AM
2937
August 01, 2007 10:06AM
2995
August 01, 2007 10:16AM
2946
August 01, 2007 10:16AM
2873
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.