Re: [Sqlrelay-discussion] r/w splitting configuration question

[<jan...@id...>]

ok sorry. 
If I omit the query statements (which is senseless) I am able to start the router instance.

# sqlr-start -id test -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
Starting listener:
  sqlr-listener -id test -config /opt/sqlrelay-0.44/etc/sqlrelay.conf

Starting 1 connections to defaultid :
  sqlr-connection-router -id test -connectionid defaultid -config /opt/sqlrelay-0.44/etc/sqlrelay.conf

Starting scaler:
  sqlr-scaler -id test -config /opt/sqlrelay-0.44/etc/sqlrelay.conf

cache manager already running.
[...]

But how can I use the query patterns sucessfully ?

kind regards,

---

Jan
________________________________________
Von: Zeller, Jan (ID)
Gesendet: Donnerstag, 8. März 2012 12:14
An: sql...@li...
Betreff: r/w splitting configuration question

dear sqlrelay list,

i try to configure r/w splitting.

i am able to start the following instances "master" & "slave" but not the router instance called "test".

The error message is :

unexpected tag <query> within <route>
Couldn't parse config file /opt/sqlrelay-0.44/etc/sqlrelay.conf.
Couldn't find id test.


By the way what is the purpose of "sqlr-connection-router" ?
Should "sqlr-connection-router" or "sqlr-start" be used to start the router instance ?
Anyway it fails with both programs.

The config file used is nearly the same as stated on http://sqlrelay.sourceforge.net/sqlrelay/router.html


# sqlr-start -id master -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
[...]
# sqlr-start -id slave -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
[...]

# pgrep -lf sql
27998 sqlr-listener -id master -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
28028 sqlr-connection-mysql -id master -connectionid db1 -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
28060 sqlr-scaler -id master -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
28067 sqlr-cachemanager
29266 sqlr-listener -id slave -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
29271 sqlr-connection-mysql -id slave -connectionid db1 -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
29288 sqlr-scaler -id slave -config /opt/sqlrelay-0.44/etc/sqlrelay.conf

What am I doing wrong ?
Any hints ?

kind regards,

Jan