Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Failover with MySQL

 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Chris Mathews
Ranch Hand
Posts: 2712
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic