mysql读写分离的作用

import pymysql

# 主数据库配置
master_config = {
    'host': 'master_host',
    'user': 'master_user',
    'password': 'master_password',
    'database': 'master_db'
}

# 从数据库配置
slave_config = {
    'host': 'slave_host',
    'user': 'slave_user',
    'password': 'slave_password',
    'database': 'slave_db'
}

def execute_write_query(query, params=None):
    with pymysql.connect(**master_config) as conn:
        with conn.cursor() as cursor:
            cursor.execute(query, params)
        conn.commit()

def execute_read_query(query, params=None):
    with pymysql.connect(**slave_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)