Re: Fail Over / Round Robin
"Mark Matthews" <[email protected]> Sat, 4 Aug 2007 18:20:14 -0500 (CDT)
| Newsgroups | gmane.comp.db.mysql.java |
|---|---|
| Message-ID | <[email protected]> |
> 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/[email protected]