At 22:13 2002-03-19, Young Sul wrote: >Hi, > >I've got a website that uses a mysql backend database. Due to the way in >which >the database and development has been architected, I'm unable to >load-balance >the database between multiple DB servers, taking advantage of replication >inherent >in mysql. (this is due largely to developmental constraints, and heavy use >of write >only session-management) > >I *need* to somehow mirror and create a decent failover environment for my >database. > >Currently, I mirror the master DB on another server, and can switch over >...manually... >if the master dies. > >I'm wondering if others on this list have encountered a similar situation -- >how did >you finally architect your DB environment? > >TIA, > >-y
Check here: http://oss.sgi.com/projects/failsafe/ It doesn't specifically mention MySQL, but I just had a look at the other database failover scripts, and it shouldn't take You long to change them for MySQL. Once You do, You may want to put them up for others to use. Other than that it works like a charm. -------------------------------------------------- sql, query Tomasz Korycki [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
