Php Codes

Php > Database Related sample source codes

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; 
} 

?>

Privacy Policy | Link to Us | Links