VMCD.ORG

Focus on database architecture

Architecture of data warehouse which is based on MQ

Posted by admin on January 20th, 2015

Recently, we create a mysql data warehouse which is based on message queue.

Most companies must prepare for particular queries in their systems if[……]

Read more

Posted in Architect, Architecture, MYSQL, rdbms, software | No Comments »

MHA with binlog server

Posted by admin on December 31st, 2014

In this post ,we mainly talk about MHA GTID behavior, we test different cases and find something is different from previous versions .

we have four[……]

Read more

Posted in Architect, Architecture, MYSQL, software | No Comments »

MySQL-Oslayer-Performance-Optimization

Posted by admin on December 13th, 2014

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

Tags:
Posted in Architecture, MYSQL, performance | No Comments »

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, Architecture, MYSQL, replication, software | 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 Architecture, MYSQL, performance | 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, performance | 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 Internals, MYSQL, oracle | 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, performance | No Comments »

Talk about some MySQL HA architecture

Posted by admin on August 12th, 2014

Some tips for MySQL architecture

Tags: ,
Posted in Architecture, 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, performance | 2 Comments »