php解决mysql主从同步

<?php
// 主服务器配置
$master_host = 'master_host';
$master_user = 'master_user';
$master_password = 'master_password';
$master_db = 'master_db';

// 从服务器配置
$slave_host = 'slave_host';
$slave_user = 'slave_user';
$slave_password = 'slave_password';
$slave_db = 'slave_db';

// 连接主服务器
$master_conn = mysqli_connect($master_host, $master_user, $master_password, $master_db);

if (!$master_conn) {
    die('连接主服务器失败: ' . mysqli_connect_error());
}

// 连接从服务器
$slave_conn = mysqli_connect($slave_host, $slave_user, $slave_password, $slave_db);

if (!$slave_conn) {
    die('连接从服务器失败: ' . mysqli_connect_error());
}

// 查询主服务器数据
$sql = "SELECT * FROM table_name";
$result = mysqli_query($master_conn, $sql);

if ($result) {
    while ($row = mysqli_fetch_assoc($result)) {
        // 处理数据
        echo $row['column_name'] . "<br>";
    }
    mysqli_free_result($result);
} else {
    echo '查询失败: ' . mysqli_error($master_conn);
}

// 关闭连接
mysqli_close($master_conn);
mysqli_close($slave_conn);
?>