实例：

    1. <?php
    2. /**
    3.  * 检测多个主从数据库是否挂掉
    4.  * 建立从数据库$slave_db的二维数组，内容包含每个从服务器的配置数据
    5.  */
    7. header("Content-Type: text/html; charset=utf-8");
    8. set_time_limit(0);
    9. $slave_db = array(
    10.     'db1'=>array(
    11.         'hostname' => '127.0.0.1',
    12.         'port' => 3306,
    13.         'database' => 'test',
    14.         'username' => 'root',
    15.         'password' => '111111',
    16.         'charset' => 'utf8',
    17.     ),
    18.     'db2'=>array(
    19.         'hostname' => '127.0.0.2',
    20.         'port' => 3306,
    21.         'database' => 'test',
    22.         'username' => 'root',
    23.         'password' => '111111',
    24.         'charset' => 'utf8',
    25.     ),
    27. );
    29. $content = '';
    30. foreach ($slave_db as $db_key) {
    31.     $host = $db_key['hostname'];
    32.     $port = $db_key['port'];
    33.     $db_user = $db_key['username'];
    34.     $db_pass = $db_key['password'];
    36.     $slave_link = mysql_connect($host,$db_user,$db_pass);
    37.     if(mysql_errno()) {
    38.         $content .= "从数据库( $host )无法连接 ！ <br/>";
    39.         $content .= mysql_error() . "<br/>";
    40.         continue;
    41.     }
    43.     $sql = "show slave status";
    44.     $result = mysql_query($sql, $slave_link);
    45.     $row = mysql_fetch_assoc($result);
    47.     $Slave_IO_Running = $row['Slave_IO_Running'];
    48.     $Slave_SQL_Running = $row['Slave_SQL_Running'];
    50.     if ('Yes' == $Slave_IO_Running && 'Yes' == $Slave_SQL_Running) {
    52.     } else {
    53.         $content .= "从数据库( $host )挂掉了！ <br/>";
    54.     }
    55.     mysql_free_result($result);
    56.     mysql_close($slave_link);
    58. }
    60. //若报错信息不为空，发送报错邮件
    61. if(!empty($content)) {
    62.     $title = '主从数据库状态检测报错 ';
    63.     $content = date("Y-m-d H:i:s",time()) . "<br/>" . $content;
    64.     $sendurl = "http://localhost/api.ftrend.com/test.php?title=".$title."&content=".$content;
    65.     $result = file_get_contents($sendurl);
    66.     if('ok' != $result) {
    67.         $message = date("Y-m-d H:i:s",time()).'slaveStatus.php主从数据库状态检测报错,邮件发送失败!'."\n";
    68.         $content = str_replace("<br/>", "\n", $content);
    69.         $message .= $content;
    70.         error_log($message,3,"error.log");
    71.     }
    72. }
    <?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';