VMCD.ORG

Focus on database architecture

MySQL message subscription system

Posted by admin on December 9th, 2014

Introducing MQ system based on MySQL (canal + roma)
Using this system to subscribe message between different platforms.

View this PDF roma_syste[……]

Read more

Tags:
Posted in Architect, MYSQL | No Comments »

MyAWR : MySQL Workload Report V3 release

Posted by admin on December 2nd, 2014


myawr-v3 release now !

history of myawr:

————————–
v1: create by noodba

mysql load information and system information 

[……]

Read more

Tags:
Posted in Architect, MYSQL | No Comments »

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 | 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, system | 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 | 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 »