[转]一个比较两个MySQL实例参数的Python脚本

#!/usr/bin/env python3  
import pymysql  
import csv  

cfg1 = {"host": "host1", "port": 3306, "user": "user1", "password": "password1"}  
cfg2 = {"host": "host2", "port": 3306, "user": "user2", "password": "password2"}  

def get_vars(cfg):  
    conn = pymysql.connect(**cfg)  
    with conn.cursor() as cur:  
        cur.execute("SHOW VARIABLES")  
        return dict(cur.fetchall())  

vars1 = get_vars(cfg1)  
vars2 = get_vars(cfg2)  

diffs = []  
for k in sorted(set(vars1) | set(vars2)):  
    v1, v2 = vars1.get(k), vars2.get(k)  
    if v1 != v2:  
        diffs.append((k, v1, v2))  

# ======== 保存为 CSV ========def save_to_csv(diffs, filename="mysql_diff.csv"):  
    with open(filename, "w", newline="", encoding="utf-8") as f:  
        writer = csv.writer(f)  
        writer.writerow(["参数名", "实例1值", "实例2值"])  
        writer.writerows(diffs)  
    print(f"\n📄 差异结果已保存到: {filename}")  

if diffs:  
    print(f"❗ 共发现 {len(diffs)} 个参数不一致：\n")  
    print(f"{'参数名':40s} {'实例1值':35s} {'实例2值'}")  
    print("-" * 100)  
    for k, v1, v2 in diffs:  
        print(f"{k:40s} {str(v1):35s} {str(v2)}")  
    save_to_csv(diffs)  
else:  
    print("✅ 两个实例参数完全一致。")