mysql 读写分离提高并发

<?php
// 数据库连接配置
$masterConfig = [
    'host' => 'master_host',
    'user' => 'master_user',
    'password' => 'master_password',
    'database' => 'master_db',
];

$slaveConfig = [
    'host' => 'slave_host',
    'user' => 'slave_user',
    'password' => 'slave_password',
    'database' => 'slave_db',
];

// 写操作（连接主数据库）
$masterConn = new mysqli($masterConfig['host'], $masterConfig['user'], $masterConfig['password'], $masterConfig['database']);
if ($masterConn->connect_error) {
    die("主数据库连接失败: " . $masterConn->connect_error);
}

// 写入数据
$sql = "INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com')";
$masterConn->query($sql);

// 读操作（连接从数据库）
$slaveConn = new mysqli($slaveConfig['host'], $slaveConfig['user'], $slaveConfig['password'], $slaveConfig['database']);
if ($slaveConn->connect_error) {
    die("从数据库连接失败: " . $slaveConn->connect_error);
}

// 读取数据
$sql = "SELECT * FROM users";
$result = $slaveConn->query($sql);

while ($row = $result->fetch_assoc()) {
    echo $row['name'] . ' - ' . $row['email'] . '<br>';
}

// 关闭连接
$masterConn->close();
$slaveConn->close();
?>