Some tips for MySQL architecture
read : JKDB-mysql-arc[……]
August 12, 2014 Architecture, MYSQL No comments architecture, mysql
July 28, 2014 MYSQL, performance 2 comments mysql
看到叶金荣的一篇关于mysql分页的文章,结合雅虎之前发的一篇PDF 谈谈自己的看法
在叶子的文章里谈到了使用inner join 从而减少了对page的扫描也就是减少了所谓的回表 例如：
SELECT * FROM `t1` INNER JOIN ( SELECT id FROM `t[......]
June 18, 2014 Architecture, MYSQL No comments architecture
June 9, 2014 Architecture, MYSQL, replication No comments HA
Oracle Clusterware is portable cluster software that allows clustering of independent servers so that they cooperate as a single system. Oracle Clus[……]
May 13, 2014 Architecture, MYSQL, replication No comments architecture
news in mysqlbinlog – Back Up Master Binary Log Files
从mysql5.6开始 mysqlbinlog开始支持远程读取master主机的binlog写入本地,极大的加强了binlog的备份策略,由于在mysql cluster复制环境中,b[……]
May 12, 2014 Architecture, MYSQL, replication No comments
Multi-master-rep
two masters: -- 192.168.126.128 mysql 5.6.12 -- 192.168.126.129 mysql 5.6.12
slave : -- 192.168.126.130 MariaDB 10.0
[……]
February 10, 2014 Architecture, MYSQL, performance No comments architecture
upload on 2014.2 [MySQL 5.5&5.6 new features summary] Download this PDF[……]
September 10, 2013 MYSQL, replication No comments mysql
最近同事处理了一则mysql复制错误.发出来参考下
MYSQL同步出错，报错信息如下：
Last_Errno: 1267 Last_Error: Error 'Illegal mix of collations (utf8_general_ci,COERCIBLE) and[......]
July 9, 2013 Internals, MYSQL 2 comments mysql
最近关于下厨房的数据恢复,讨论的很火热,乘机测试了把Percona Data Recovery Tool for InnoDB工具,并且事实证明这款工具对一些操作的恢复,还是比较困难的。
我们以一张小表为例做一个测试:
mysql> select * from customer;[......]
June 14, 2013 MYSQL, performance 2 comments mysql
最近team基于mysql的性能基准测试,包含多种场景[……]