这篇文章主要介绍了php实现的mysql主从数据库状态检测功能,结合具体实例形式分析了php检测多个mysql主从数据库连接状态的相关实现技巧,需要的朋友可以参考下
实例：
<?php
/**
* 检测多个主从数据库是否挂掉
* 建立从数据库$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 )无法连接 ！ <br/>";
$content .= mysql_error() . "<br/>";
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 )挂掉了！ <br/>";
}
mysql_free_result($result);
mysql_close($slave_link);
}
//若报错信息不为空，发送报错邮件
if(!empty($content)) {
$title = '主从数据库状态检测报错 ';
$content = date("y-m-d h:i:s",time()) . "<br/>" . $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("<br/>", "\n", $content);
$message .= $content;
error_log($message,3,"error.log");
}
}
<?php
$title = $_get['title'];
$content = $_get['content'];
$content = str_replace("<br/>", "\n", $content);
error_log($title."\n",3,'error.log');
error_log($content."\n",3,'error.log');
echo 'ok';
相关推荐：php实现的redis主从数据库状态检测功能的方法
php自动备份数据库表的方法
php读取csv大文件导入数据库的方法
以上就是php实现mysql主从数据库状态检测功能的方法的详细内容。