Hi One of my servers was hit by a network DoS attack and was offline for an hour on Thursday and I am looking at high availability solutions.
I can make sure the php site is always up by redundancy, but making sure the database is ok is more difficult. The situation I want to cater for is this Joe Bloggs is part way through placing his first order for 5000 widgets and the server crashes, or gets hit by a DoS attack. The site seamlessly switches to backup and his order also continues seamlessly, as his order is also written to the backup database. By duplicating the site, and DNS set up, at another datacenter, the site switches to backup. What I need is a way of duplicating the database (in real time or close) so it continues seamlessly if one server goes down. It will automatically switch back to the main server when it is available, at which point the main server needs to update itself from the backup database. Some of the tables use auto increment fields which could get badly out of sync if I am not careful. (Though this might justify switching to another way of doing things) Am I trying to do the impossible, or conversely is there a standard way of doing this like replication or running all INSERT and UPDATE queries on both databases? Any thoughts appreciated Peter sql etc etc ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 ----------------------------------------------- --------------------------------------------------------------------- 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
