Php Programming Code Examples
Php > Database Related Code Examples
MySQL Replication Connection Fail Over
MySQL Replication Connection Fail Over
<?php
function mysql_rep_connect(){
$timeout = 15;
$mysql_servers = array(
array("mysql1.yourdomain.tdl", "username", "password"),
array("mysql2.yourdomain.tdl, "username", "password")
);
$connection = false;
foreach($mysql_servers as $server){
list($hostname, $username, $passwd) = $server;
if($fp = fsockopen($hostname, 3306, &$errno, &$errstr, $timeout)){
fclose($fp);
$connection = @mysql_pconnect($hostname, $username, $passwd);
if($connection > 0)break;
}
}
return $connection;
}
?>
