这里有新鲜出炉的Mysql教程,程序狗速度看过来!
MySQL是一个开放源码的小型关联式数据库管理系统,开发者为瑞典MySQL AB公司。MySQL被广泛地应用在Internet上的中小型网站中。由于其体积小、速度快、总体拥有成本低,尤其是开放源码这一特点,许多中小型网站为了降低网站总体拥有成本而选择了MySQL作为网站数据库。
这篇文章主要介绍了PHP实现的mysql主从数据库状态检测功能,结合具体实例形式分析了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程序设计有所帮助。
来源: http://www.phperz.com/article/17/1026/350691.html