mysql
lzj0470
这个作者很懒,什么都没留下…
展开
-
mysql同步复制抛Got fatal error 1236 Slave can not handle replication events with the checksum
做主主同步时,基本信息: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原创 2015-01-14 19:10:15 · 3498 阅读 · 0 评论 -
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in
执行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原创 2015-01-14 18:22:41 · 5635 阅读 · 0 评论 -
主主复制错误,Last_SQL_Errno: 1205
Last_SQL_Errno: 1205Last_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;原创 2015-01-17 00:36:12 · 3308 阅读 · 0 评论 -
mysql遇过的问题汇集
1、WARNING: The host 'MySQL' could not be looked up with resolveip.解决:DNS解析与主机名(uname -n)不同造成的,更改hosts文件即可如:vi /etc/hosts添加MySQL2、ERROR 2002 (HY000): Can't connect to local MySQL server throu原创 2014-12-10 09:42:26 · 544 阅读 · 0 评论