lzj0470的专栏

做主主同步时， 基本信息：1.master1 mysql版本是5.6.12                   2.master2 mysql版本时5.5.36 一：在master1做同步复制成功。 二：在master2做同步复制失败。       Last_IO_Error: Got fatal error 1236 from master when rea

执行 change master to master_host='ip', master_port=3306, master_user='xxx',master_password='xxx', master_log_file='mysql-bin.000012',master_log_pos=107; 抛出错误 ERROR 1201 (HY000): Could not initiali

Last_SQL_Errno: 1205 Last_SQL_Error: Slave SQL thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. 解决办法： stop slave;

1、WARNING: The host 'MySQL' could not be looked up with resolveip. 解决：DNS解析与主机名（uname -n）不同造成的，更改hosts文件即可 如：vi /etc/hosts 添加MySQL 2、ERROR 2002 (HY000): Can't connect to local MySQL server throu