Reference Oracle AWR. These two was developed by python and perl.
Both of these are following data collection method.
Use these tools can help[……]
Category: MYSQL
MYSQL high performance
Talk about some MySQL HA architecture
Advanced Pagination for MySQL
看到叶金荣的一篇关于mysql分页的文章,结合雅虎之前发的一篇PDF 谈谈自己的看法
在叶子的文章里谈到了使用inner join 从而减少了对page的扫描也就是减少了所谓的回表 例如：
SELECT * FROM `t1` INNER JOIN ( SELECT id FROM `t[......]
MySQL Fabric HA&Sharding solutions
Good news for MySQL HA solutions
Oracle Clusterware is portable cluster software that allows clustering of independent servers so that they cooperate as a single system. Oracle Clus[……]
news in mysqlbinlog – Back Up Master Binary Log Files
news in mysqlbinlog – Back Up Master Binary Log Files
从mysql5.6开始 mysqlbinlog开始支持远程读取master主机的binlog写入本地,极大的加强了binlog的备份策略,由于在mysql cluster复制环境中,b[……]
Multi-Master-Rep in MySQL DB
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
[……]
MySQL 5.5&5.6 new features summary
upload on 2014.2 [MySQL 5.5&5.6 new features summary] Download this PDF[……]
MySQL replication case 一则
最近同事处理了一则mysql复制错误.发出来参考下
MYSQL同步出错，报错信息如下：
Last_Errno: 1267 Last_Error: Error 'Illegal mix of collations (utf8_general_ci,COERCIBLE) and[......]
MySQL InnoDB的一些非常规恢复
最近关于下厨房的数据恢复,讨论的很火热,乘机测试了把Percona Data Recovery Tool for InnoDB工具,并且事实证明这款工具对一些操作的恢复,还是比较困难的。
我们以一张小表为例做一个测试:
mysql> select * from customer;[......]