From: Luke H. Crouch Date: July 27 2004 3:01pm Subject: jdbc failover List-Archive: http://lists.mysql.com/cluster/202 Message-Id: <075C170BC7219F439DD3FE8C880648C1C3A543@red-ivy.red-man.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C473EA.8DB81B8E" ------_=_NextPart_001_01C473EA.8DB81B8E Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I notice in the Connector/J documentation that failover hosts are = connected to on 'read-only' basis. meaning if I have set up 4 mysqld = API's, and I use JDBC to connect to one of these, specify another one as = the failover, it will only allow read statement to go thru. in the = cluster environment, it DOES make sense to let the failover host perform = writing queries, so how can I configure Connector/J to allow write = queries on failover hosts? =20 thanks, -L Luke Crouch=20 IS Developer=20 Red Man Pipe & Supply=20 918-461-5326=20 luke.crouch@stripped=20 **NOTE: MY EMAIL HAS CHANGED AS OF 6/17/2004**=20 =20 ------_=_NextPart_001_01C473EA.8DB81B8E--