MySQL の読み取りと書き込みの分離と負荷分散を学習するためのテクニックは何ですか?

[mysqld]
server-id=1
log-bin=mysql-bin
binlog-do-db=mydatabase

[mysqld]
server-id=2

SHOW MASTER STATUS;
SHOW SLAVE STATUS;

# 创建一个与数据库对应的后端连接池
INSERT INTO mysql_servers(hostgroup_id, hostname, port) VALUES (0, '192.168.0.1', 3306);
INSERT INTO mysql_servers(hostgroup_id, hostname, port) VALUES (1, '192.168.0.2', 3306);

# 创建读写分离规则
INSERT INTO mysql_query_rules(match_pattern, destination_hostgroup) VALUES ('^SELECT', 1);
INSERT INTO mysql_query_rules(match_pattern, destination_hostgroup) VALUES ('^UPDATE', 0);

import org.apache.commons.dbcp2.BasicDataSource;

public class ConnectionPoolDemo {
    public static void main(String[] args) {
        BasicDataSource dataSource = new BasicDataSource();
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql://localhost:3306/mydatabase");
        dataSource.setUsername("root");
        dataSource.setPassword("password");
      
        // 从连接池中获取连接
        try (Connection connection = dataSource.getConnection()) {
            // 执行数据库操作
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}