Re: Fail Over / Round Robin

> Fantastic Ronald ... just what i was looking for.
>

Alan,

Connector/J has had simiar functionality built-in for some time now, if you don't want as many "moving" pieces in your setup. Basically, you specify your master, and slaves, and tell C/J when you want to use one or the other by calling Connection.setReadOnly(boolean) "false" for write (or read) to/from the master, and "true" for read-only from one of the slaves.

See
http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-replication-connection.html for more info.

  -Mark

-- 
MySQL Java Mailing List
For list archives: 
http://lists.mysql.com/java
To unsubscribe:    
http://lists.mysql.com/java?unsub=lists@pantek.com