[Sqlrelay-discussion] sqlrelay INSERTS going to "slave"

[Sekou A. <sek...@to...>]

Hi,

I am running sqlrelay-0.38
I have sqlrelay in routing and filtering mode. It is configured to route
DML/DDL queries to "master" and other quries to "slave"
all queries including INSERTS are going to the "slave" and nothing is =
going
to "master"

find below my router definition:


	<router>
                        <!-- he haw haw sekou! this will send all =
DML/DDL
queries to "master"  -->
                        <route host=3D"" port=3D"" =
socket=3D"/tmp/master.socket"
user=3D"master" password=3D"masterpass">
                                <query =
pattern=3D"^\s*select\s+.*\s+from\s+"/>
                                <query =
pattern=3D"^\s*insert\s+into\s+"/>
                                <query pattern=3D"^\s*update\s+"/>
                                <query =
pattern=3D"^\s*delete\s+from\s+"/>
                                <query pattern=3D"^\s*drop\s+table\s+"/>
                                <query =
pattern=3D"^\s*create\s+table\s+"/>
                        </route>
                        <!-- grab a doughnut ... this sends all other
queries to "slave" -->
                        <route host=3D"" port=3D"" =
socket=3D"/tmp/slave.socket"
user=3D"slave" password=3D"slavepass">
                                <query pattern=3D".*"/>
                        </route>
                </router>

Any ideas?

			S. Sekou Abodunrin=20
		=09

This email is confidential and may also be privileged. If you are not =
the intended recipient please notify us immediately by telephoning +44 =
(0)20 7452 5300 or email pos...@to.... You should not copy =
it or use it for any purpose nor disclose its contents to any other =
person. Touch Local cannot accept liability for statements made which =
are clearly the sender's own and are not made on behalf of the firm.

Touch Local Limited
Registered Number: 2885607
VAT Number: GB896112114
Cardinal Tower, 12 Farringdon Road, London EC1M 3NN
+44 (0)20 7452 5300