VMCD.ORG

Focus on DB architect mail:ylouis83#gmail.com

webm_v2 has been released

Posted by admin on October 21st, 2014

Webm_v2 was add oracle and mongodb monitor module

webm was agent uploaded mode to save statistics

we use mysql database as monitor server

w[……]

Read more

Posted in Architect, MYSQL, NoSQL, Oracle Experience | No Comments »

Webm: MySQL database performance web monitor

Posted by admin on September 28th, 2014

You can download webm from github: https://github.com/ylouis83/webm

webm: mysql web key performance monitor

webm is a tool that display key val[……]

Read more

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

关于Dell 推出第13代服务器的一些想法

Posted by admin on September 12th, 2014

戴尔近日推出了旗下的13G服务器,其主力机型为R730xd,包含了诸多的特性,为其成为主流db server以及规模存储集群打下了良好的基础。

具体参考:http://www.storagereview.com/dell_poweredge_13g_r730xd_review
http://[……]

Read more

Tags:
Posted in MYSQL, NoSQL, Oracle Experience, Unix/Linux | No Comments »

关于Partial write for all MySQL and Oracle

Posted by admin on September 2nd, 2014

很久之前看过这个帖子,当时没有细究,这几天看了下mysql相关的internal 突然想起这个问题,跟三四个朋友讨论了下 想把这个问题展开讲一讲。

源帖子内容见:https://community.oracle.com/thread/1087650?start=0&tstart=0

这个[……]

Read more

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

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 »

Advanced Pagination for MySQL

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 »