VMCD.ORG

Focus on database architecture

How to configure Tcpdump system

Posted by admin on July 24th, 2015

MySQL Tcpdump system : use percona-toolkit to analyze network packages

We can identify problem SQLs with high execution frequency.

With DBMON s[……]

Read more

Posted in Architect, Architecture, Internals, MYSQL, network, system | No Comments »

How to configure WEBM

Posted by admin on July 15th, 2015

Architecture of WEBM system.

Reference:

http://www.vmcd.org/2014/10/webm_v2-has-been-released/
http://www.vmcd.org/2014/09/webm-mysql-database[……]

Read more

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

MariaDB : Bug when add index on Partition table

Posted by admin on April 23rd, 2015

Version: 5.5.5-10.0.10-MariaDB-log MariaDB Server

When I use mariadb as multi-source slave DB I met a strange problem . Creating index on a vary la[……]

Read more

Posted in Internals, MYSQL, replication | No Comments »

MySQL 5.7 milestone

Posted by admin on April 22nd, 2015

MySQL 5.7 will be a great milestone in MySQL total history.
Oracle has released many useful new features in LAB version . MySQL is becoming more sim[……]

Read more

Posted in Architect, MYSQL, software | No Comments »

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 »