mysql 读写分离好处

import mysql.connector

# 写操作连接配置
write_config = {
    'host': 'master_host',
    'user': 'user',
    'password': 'password',
    'database': 'database'
}

# 读操作连接配置
read_config = {
    'host': 'slave_host',
    'user': 'user',
    'password': 'password',
    'database': 'database'
}

def execute_write_query(query, params=None):
    with mysql.connector.connect(**write_config) as conn:
        with conn.cursor() as cursor:
            cursor.execute(query, params)
            conn.commit()

def execute_read_query(query, params=None):
    with mysql.connector.connect(**read_config) as conn:
        with conn.cursor() as cursor:
            cursor.execute(query, params)
            return cursor.fetchall()

# 示例：插入数据
execute_write_query("INSERT INTO users (name, email) VALUES (%s, %s)", ('Alice', 'alice@example.com'))

# 示例：查询数据
result = execute_read_query("SELECT * FROM users WHERE name = %s", ('Alice',))
print(result)