VMCD.ORG

Focus on DB architect mail:ylouis83#gmail.com

Advance for MySQL Pagination

Posted by admin on July 28th, 2014

看到叶金荣的一篇关于mysql分页的文章,结合雅虎之前发的一篇PDF 谈谈自己的看法

在叶子的文章里谈到了使用inner join 从而减少了对page的扫描也就是减少了所谓的回表 例如:

SELECT * FROM `t1` INNER JOIN ( SELECT id FROM `t[......]

Read more

Tags:
Posted in MYSQL | No Comments »

MySQL Fabric HA&Sharding solutions

Posted by admin on June 18th, 2014

MySQL Fabric

Download : MySQL fabric solutions

Tags:
Posted in MYSQL | No Comments »

Good news for MySQL HA solutions

Posted by admin on June 9th, 2014


Oracle Clusterware is portable cluster software that allows clustering of independent servers so that they cooperate as a single system. Oracle Clus[......]

Read more

Tags:
Posted in MYSQL, Oracle Experience | No Comments »

news in mysqlbinlog – Back Up Master Binary Log Files

Posted by admin on May 13th, 2014

news in mysqlbinlog – Back Up Master Binary Log Files

从mysql5.6开始 mysqlbinlog开始支持远程读取master主机的binlog写入本地,极大的加强了binlog的备份策略,由于在mysql cluster复制环境中,b[......]

Read more

Tags:
Posted in MYSQL | No Comments »

Multi-Master-Rep in MySQL DB

Posted by admin on May 12th, 2014

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

[......]

Read more

Posted in MYSQL | No Comments »

MySQL 5.5&5.6 new features summary

Posted by admin on February 10th, 2014

upload on 2014.2 [MySQL 5.5&5.6 new features summary] Download this PDF

Tags:
Posted in MYSQL | No Comments »

MySQL-Oslayer-Performance-Optimization

Posted by admin on January 13th, 2014

upload on 2014.1 [ten important tips of MySQL database design for better performance] Download this PDF

Tags:
Posted in MYSQL | No Comments »

MySQL replication case 一则

Posted by admin on September 10th, 2013

最近同事处理了一则mysql复制错误.发出来参考下

MYSQL同步出错,报错信息如下:

Last_Errno: 1267
Last_Error: Error 'Illegal mix of collations (utf8_general_ci,COERCIBLE) and[......]

Read more

Tags:
Posted in MYSQL | No Comments »

MySQL InnoDB的一些非常规恢复

Posted by admin on July 9th, 2013

最近关于下厨房的数据恢复,讨论的很火热,乘机测试了把Percona Data Recovery Tool for InnoDB工具,并且事实证明这款工具对一些操作的恢复,还是比较困难的。

我们以一张小表为例做一个测试:

mysql> select * from  customer;[......]

Read more

Tags:
Posted in MYSQL | 2 Comments »

Recent MySQL performance Test detial

Posted by admin on June 14th, 2013

最近team基于mysql的性能基准测试,包含多种场景

Tags:
Posted in MYSQL | 2 Comments »