最近同事处理了一则mysql复制错误.发出来参考下
MYSQL同步出错，报错信息如下：
Last_Errno: 1267 Last_Error: Error 'Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'concat'' on query. Default database: 'inshop_app'. Query: 'INSERT INTO insho[......]
主要两种方法 ：
1.轮流改变oplog size (from primary to secondary)
2.重新初始化 secondary 定制oplog size 切换原来的primary
具体操作一下方法一的步骤,集体参考mongo oplog
1). 切换当前primary ->secondary
rs1:PRIMARY> rs.stepDown();
2). 关闭MongoDB
rs1:SECONDARY> db.shutdownServer();
3). 注释掉replSet选项，以单机模式启动 —切换port
4). 查询出最后的[……]
今天下午遇到的一个诡异CASE,现象为系统诡异的死亡,目前判定为sqluldr2工具导致 (同事使用sqluldr2 用具 执行了sqluldr2_linux64_10204.bin -help 命令)
抛出的错误如下 (/var/log/message)
Sep 11 09:00:54 db18 setroubleshoot: SELinux is preventing sqluldr2_linux6 from loading /home/oracle/product/10205/db1/lib/libnnz10.so which requires text relocation.[......]
[……]
某国内巨头的一起CASE,在系统繁忙情况下大量的CTAS 导致数据字典表的不一致,由原来10.0.2.4版本升级到10.0.2.5之后问题依旧。
具体表现为：
1. 尝试drop这些不一致的tablespace
15:00:18 SQL> @dropts_2012.0319.1500.sql 15:00:18 SQL> drop tablespace ODSCP1003 including contents; drop tablespace ODSCP1003 including contents * ERROR at line 1: ORA-00600: i[......]
JL刚刚写的一篇autotrace与bind variables 的行为：Autotrace trick
之前我们也发现过这个问题具体SR在这里：something seems confused [……]
UPDATE 12.2: you can download complete PDF from database design of YHD[……]
update 12.14 (add two docs) Download this PDF
overview of gc_doc2
[……]
The next generation of IBM’s X-series servers will be able to accommodate solid-state Flash drives clipped into their DIMM memory slots, potentially improving the response times of fast-paced enterprise applications.
On Thursday, IBM unveiled the Series 6 generation of its System X x86-based serv[……]
