-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi!
I'm currently in the preliminary planning phases of a content delivery system. We will be generating pdfs on the fly containing our member's statements. The system will be accessible both from our internal systems and through our web-banking portal. As we hope to eventually migrate a large percentage of our membership away from paper statements entirely (with their permission of course:) it is of paramount importance that the system be available 24/7 with as little downtime as possible (I personally am shooting for 99.99% uptime, but I've only told management we can do 97-99%:) due to regulatory snd disclosure issues. Due to budget restraints (and the fact that I'm sick of every system here being a proprietary, closed source system that I can't even configure without the vendor holding my hand because they refuse to document anything) I've decided to implement the system using Linux and mySQL. For the most part, the design is looking good... We'll be replicating the statements database among several slaves, and there are several front-end machines serving up the pdfs. I think I've eliminated almost all the single points of failure I feasibly can... except for the database master. It's important that I can eliminate this as a point of failure, because for auditing purposes every access must be logged, and to make it easier to produce activity reports and the like, I'd like to store it in the database. Unfortunately, this means there has to be a write every time a member or staff look at a statement. I've been playing with some ideas on how to have the slaves arbitrate amongst themselves and take over as master in case the master does go down. I've also heard that automated failover is supposed to be in 4.x at some point as well. I was wondering if anyone else had any example scripts/code/software, etc to do this that they'd be willing to share. Or should I wait for it to get into 4.x (my launch deadline is 6/30/02)? Sorry about the long-winded post, but any help would be greatly appreciated. ******************************* Gregory M. Symons Systems Analyst Research Federal Credit Union [EMAIL PROTECTED] 1-800-967-7929, ext 1234 ******************************** -----BEGIN PGP SIGNATURE----- Version: PGP 7.1 iQA/AwUBPDN6DeK6A2HNDZlBEQJ8KQCg4TNrvPiBehQfsDOSaMOzcbBiRRoAmwch 6/QmTDL+sbj1FxwFB7iIjeEu =7+IY -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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