Imagine, you're connecting to a mySQL database with PHP, but hell, you want a bit more robustness. So why would you want just one database? You'd use a failover right? So if the first database is down or just doesn't connect, it can connect to the next one. Here's how to do that (I'm assuming you're already replicating between databases so that they're roughly in sync).
Here's how you do it. Firstly, you'll have to define some things...View the comments, they are simple yet... informative.Now, the one thing that can make all of this come true:That will connect to the mySQL database with the currently defined variables.So, obviously, if
$connectdoes that, what would
$connect2do?It connects to the database! But, oh, it's the second one. Strange, isn't it?Now, you can check if the database connected or not by checking if its true, or false.Of course, how does it connect to the second database? Simple!Now, that's all this really does. It has some
mysql_error()stuff in it too, and checks if the url is
connection.php?type=1before executing the code. I basically combined all of that into one script, all you have to do is edit the variables, and do:Here's the full script: