php mysql 主从_PHP实现的mysql主从数据库状态检测功能示例

本文实例讲述了PHP实现的mysql主从数据库状态检测功能。分享给大家供大家参考，具体如下：

实例：

/**

* 检测多个主从数据库是否挂掉

* 建立从数据库$slave_db的二维数组，内容包含每个从服务器的配置数据

*/

header("Content-Type: text/html; charset=utf-8");

set_time_limit(0);

$slave_db = array(

'db1'=>array(

'hostname' => '127.0.0.1',

'port' => 3306,

'database' => 'test',

'username' => 'root',

'password' => '111111',

'charset' => 'utf8',

),

'db2'=>array(

'hostname' => '127.0.0.2',

'port' => 3306,

'database' => 'test',

'username' => 'root',

'password' => '111111',

'charset' => 'utf8',

),

);

$content = '';

foreach ($slave_db as $db_key) {

$host = $db_key['hostname'];

$port = $db_key['port'];

$db_user = $db_key['username'];

$db_pass = $db_key['password'];

$slave_link = mysql_connect($host,$db_user,$db_pass);

if(mysql_errno()) {

$content .= "从数据库( $host )无法连接 ！
";

$content .= mysql_error() . "
";

continue;

}

$sql = "show slave status";

$result = mysql_query($sql, $slave_link);

$row = mysql_fetch_assoc($result);

$Slave_IO_Running = $row['Slave_IO_Running'];

$Slave_SQL_Running = $row['Slave_SQL_Running'];

if ('Yes' == $Slave_IO_Running && 'Yes' == $Slave_SQL_Running) {

} else {

$content .= "从数据库( $host )挂掉了！
";

}

mysql_free_result($result);

mysql_close($slave_link);

}

//若报错信息不为空，发送报错邮件

if(!empty($content)) {

$title = '主从数据库状态检测报错 ';

$content = date("Y-m-d H:i:s",time()) . "
" . $content;

$sendurl = "http://localhost/api.ftrend.com/test.php?title=".$title."&content=".$content;

$result = file_get_contents($sendurl);

if('ok' != $result) {

$message = date("Y-m-d H:i:s",time()).'slaveStatus.php主从数据库状态检测报错,邮件发送失败!'."\n";

$content = str_replace("
", "\n", $content);

$message .= $content;

error_log($message,3,"error.log");

}

}

$title = $_GET['title'];

$content = $_GET['content'];

$content = str_replace("
", "\n", $content);

error_log($title."\n",3,'error.log');

error_log($content."\n",3,'error.log');

echo 'ok';

希望本文所述对大家PHP程序设计有所帮助。