升级

1.停止数据库3306数据库
2.做airquality的软连接
ln -s /export/mysqldata1/sock/mysql.sock /tmp/mysqld.sock
3.停止4001库的从库服务
stop slave;
reset slave;


4.停止4001库的从库服务
stop slave;
reset slave;
reset master;


5.修改配置文件
cd /etc
mv my_4001.cnf my_3307.cnf


vi my_3307.cnf
bin/mysqld_safe --defaults-file=/etc/my_3307.cnf &




change master to master_host='10.159.33.32',master_port=3307,master_log_file='mysql-bin.000001',master_log_pos=120,master_user='slaveuser',master_password='slaveuser';