VMCD.ORG

Focus on DB architect mail:ylouis83#gmail.com

Some data collection display

Posted by admin on August 21st, 2014

Reference Oracle AWR. These two was developed by python and perl.

Both of these are following data collection method.

Use these tools can help[......]

Read more

Tags: , , ,
Posted in MYSQL, NoSQL | No Comments »

Talk about some MySQL HA architecture

Posted by admin on August 12th, 2014

Some tips for MySQL architecture

Tags: ,
Posted in MYSQL | No Comments »

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 »