This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
If someone has implemented a failover scenario with MySQL 4.0, I'd be more than happy to hear about the details... I have an application running on WebLogic Express 8.1, which has a "high-availability" configured multipool capable of switching to an alternative connection pool when the primary doesn't work anymore, but I'm having difficulty in figuring out how to stop the MySQL slave automatically when the master has died so that the secondary connection pool starts working (a MySQL slave can only execute SELECT queries while in slave mode so it needs to be stopped somehow). There's always the manual option, executing "stop slave" by hand, but I would like to get a bit more swift failover functionality
You might want to checkout the Clustered JDBC Project. It is OSS and supports clustering a myriad of different databases including MySQL. I have no experience with it but I saw the product announcement on TSS (which probably means that you saw it too ) and I figured I would drop a note. If you do end up using it I expect a full report. [ February 11, 2004: Message edited by: Chris Mathews ]
Joined: Jan 23, 2002
Thanks Chris! I looked at C-JDBC some months ago and quickly abandoned it because of its status (0.x). Now that it's already a release candidate, I just might take a swing at it (and if I will get a chance to use it, I'll sure report the experience)