2015年07月_lwei_998

原创 Mycat ERROR 1064 (HY000): bad insert sql

CREATE TABLE `t` ( `tid` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(10) DEFAULT NULL, `sdate` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`tid`)) ENGINE=In

2015-07-29 16:05:37 9267

原创 slave_net_timeout

http://dev.mysql.com/doc/refman/5.6/en/replication-options-slave.html#sysvar_slave_net_timeout1.先了解一下mysql中与复制有关的三个参数的含义slave_net_timeoutThe number of seconds to wait for more data from a

2015-07-13 16:45:25 4119

原创 MySQL event execution failed

现象描述：Master中错误日志如下：tail -100f /data/mysql01.err[ERROR] Event Scheduler: [test@%][QA.qa_e_p_tf] DROP command denied to user 'test'@'%' for table 'texplor_rent'[Note] Event Scheduler: [test@%].[

2015-07-10 14:49:28 2599

原创 skip_grant_tables与半同步的冲突

MySQL Server version: 5.6.24用skip_grant_tables重启MySQL时遇到下述错误[ERROR] /mysql5.6/bin/mysqld: unknown variable 'rpl_semi_sync_slave_enabled=ON'[ERROR] Aborting难道skip_grant_tables与r

2015-07-10 14:34:15 1114

原创 Slave failed to initialize relay log info structure from the repository

mysql> show slave status\G*************************** 1. row ***************************Slave_IO_Running: NoSlave_SQL_Running: NoLast_SQL_Errno: 1872Last_SQL_Error: Slave failed to initializ

2015-07-09 08:54:18 8201

原创 Got fatal error 1236 from master when reading data from binary log

模拟断电，master和slave非正常关机，slave重启后出现如下错误。Last_IO_Errno: 1236Last_IO_Error: Got fatal error 1236 from master when reading data from binary log:'Client requested master to start replication from posi

2015-07-08 09:46:11 2156

原创 log event entry exceeded max_allowed_packet

现象：[ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master', Error_code: 1236[Not

2015-07-07 14:46:46 5191

原创 MySQL 多实例使用mysql_secure_installation

一台server上有两个MySQL实例分别占用3306,3307 端口，如何使用mysql_secure_installation去删除匿名用户呢？$netstat -antp|grep mysqld(Not all processes could be identified, non-owned process info will not be shown, you woul

2015-07-07 14:44:50 3874

原创 MySQL SLAVE Exec_Master_Log_Pos 不变

2015-07-07 14:39:21 8568

原创 Bringing up interface eth2: Error: No suitable device found: no device found for connection 'System

# service network restartShutting down loopback interface: [ OK ]Bringing up loopback interface: [ OK ]Bringing up interface eth0: Error:

2015-07-04 17:43:40 5197

lwei_998的专栏