主mysql down掉,无法开启,以下为切换从mysql到主mysql.
1.停用mysql slave
stop slave;
2.关闭mysql
service mysql stop
3.修改/usr/my.conf,注释掉read_only=on.
4.修改服务器IP为主服务器IP.
vi /etc/sysconfig/network-scripts/ifcfg-ethX
service network restart
5.启动mysql.
service mysql start