[Sqlrelay-discussion] Please help
Brought to you by:
mused
|
From: Henrik HJ <tes...@li...> - 2009-09-17 09:10:42
|
Can you please help me. I can't connect to SQLRelay, when I try to connect. The client freeze and stop working. I have 4 server: Serv1: 10.131.50.191 Database #1 Serv2: 10.131.50.192 Database #2 Serv3: 10.131.50.193 SQLRelay Serv4: 10.131.50.190 This is the server who have the client install. Thanks in advance Henrik Startup shell script #!/bin/sh /usr/local/firstworks/bin/sqlr-start -id master /usr/local/firstworks/bin/sqlr-start -id slave /usr/local/firstworks/bin/sqlr-start -id router SQLRELAY.CONF <?xml version="1.0"?> <!DOCTYPE instances SYSTEM "sqlrelay.dtd"> <instances> <!-- This instance maintains connections to the "master" Postgresql database on the masterdb machine. This instance only listens on the unix socket /tmp/master.socket and thus cannot be connected to by clients from another machine. --> <instance id="master" port="" socket="/tmp/master.socket" dbase="postgresql" connections="3" maxconnections="15" maxqueuelength="5" growby="1" ttl="60" endofsession="commit" sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" handoff="pass" deniedips="" allowedips="" debug="none" maxquerysize="65536" maxstringbindvaluelength="4000" maxlobbindvaluelength="71680" idleclienttimeout="-1"> <users> <user user="postgres" password="xxx"/> </users> <connections> <connection connectionid="db" string="user=postgres;password=xxx;host=10.131.50.191;db=duc;" metric="1" behindloadbalancer="no"/> </connections> </instance> <!-- This instance maintains connections to 1 "slave" Postgresql databases on 1 slave machines. This instance only listens on the unix socket /tmp/slave.socket and thus cannot be connected to by clients from another machine. --> <instance id="slave" port="" socket="/tmp/slave.socket" dbase="postgresql" connections="3" maxconnections="15" maxqueuelength="5" growby="1" ttl="60" endofsession="commit" sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" handoff="pass" deniedips="" allowedips="" debug="none" maxquerysize="65536" maxstringbindvaluelength="4000" maxlobbindvaluelength="71680" idleclienttimeout="-1"> <users> <user user="postgres" password="xxx"/> </users> <connections> <connection connectionid="db1" string="user=postgres;password=xxx;host=10.131.50.192;db=duc;" metric="1" behindloadbalancer="no"/> </connections> </instance> <!-- This instance sends DML (insert,update,delete) and DDL (create/delete) queries to the "master" SQL Relay instance which, in turn, sends them to the "master" database. This instance sends any other queries to the "slave" SQL Relay instance which, in turn, distributes them over the "slave" databases. --> <instance id="router" port="9000" socket="/tmp/router.socket" dbase="router" connections="3" maxconnections="15" maxqueuelength="5" growby="1" ttl="60" endofsession="commit" sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" handoff="pass" deniedips="" allowedips="" debug="none" maxquerysize="65536" maxstringbindvaluelength="4000" maxlobbindvaluelength="71680" idleclienttimeout="-1"> <users> <user user="postgres" password="xxx"/> </users> <router> <!-- send all DML/DDL queries to "master" --> <route host="" port="" socket="/tmp/master.socket" user="masteruser" password="masterpassword"> <query pattern="^\s*select\s+.*\s+from\s+"/> <query pattern="^\s*insert\s+into\s+"/> <query pattern="^\s*update\s+"/> <query pattern="^\s*delete\s+from\s+"/> <query pattern="^\s*drop\s+table\s+"/> <query pattern="^\s*create\s+table\s+"/> </route> <!-- send all other queries to "slave" --> <route host="" port="" socket="/tmp/slave.socket" user="slaveuser" password="slavepassword"> <query pattern=".*"/> </route> </router> </instance> </instances> Output Warning: using default id. Starting listener: sqlr-listener -id master -config /usr/local/firstworks/etc/sqlrelay.conf Starting 3 connections to db : sqlr-connection-postgresql -id master -connectionid db -config /usr/local/firstworks/etc/sqlrelay.conf sqlr-connection-postgresql -id master -connectionid db -config /usr/local/firstworks/etc/sqlrelay.conf sqlr-connection-postgresql -id master -connectionid db -config /usr/local/firstworks/etc/sqlrelay.conf Starting scaler: sqlr-scaler -id master -config /usr/local/firstworks/etc/sqlrelay.conf Starting cache manager: sqlr-cachemanager Thanks to MP3.com for sponsoring: Clustered/Replicated database support. Perl API. Thanks to FeedLounge for sponsoring: Query routing and filtering. Starting listener: sqlr-listener -id slave -config /usr/local/firstworks/etc/sqlrelay.conf Starting 3 connections to db1 : sqlr-connection-postgresql -id slave -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf sqlr-connection-postgresql -id slave -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf sqlr-connection-postgresql -id slave -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf Starting scaler: sqlr-scaler -id slave -config /usr/local/firstworks/etc/sqlrelay.conf cache manager already running. Thanks to MP3.com for sponsoring: Clustered/Replicated database support. Perl API. Thanks to FeedLounge for sponsoring: Query routing and filtering. Couldn't set autocommit off. Couldn't set autocommit off. Starting listener: sqlr-listener -id router -config /usr/local/firstworks/etc/sqlrelay.conf Starting 3 connections to defaultid : sqlr-connection-router -id router -connectionid defaultid -config /usr/local/firstworks/etc/sqlrelay.conf sqlr-connection-router -id router -connectionid defaultid -config /usr/local/firstworks/etc/sqlrelay.conf sqlr-connection-router -id router -connectionid defaultid -config /usr/local/firstworks/etc/sqlrelay.conf Starting scaler: sqlr-scaler -id router -config /usr/local/firstworks/etc/sqlrelay.conf cache manager already running. Thanks to MP3.com for sponsoring: Clustered/Replicated database support. Perl API. Thanks to FeedLounge for sponsoring: Query routing and filtering. Couldn't set autocommit off. _________________________________________________________________ Få 25 GB lagerplads på nettet! http://www.microsoft.com/danmark/windows/windowslive/products/skydrive.aspx |