VMCD.ORG

Focus on database architecture

[Reprint]Injection MySQL – Function

Posted by admin on August 24th, 2015

Reprint a PDF for MySQL Injection Test

MySQL Error Based SQL Injection Using EXP

Posted in Internals, linux, MYSQL, rdbms | No Comments »

MySQL checksum

Posted by admin on August 19th, 2015

how to use percona-tookit to verify mysql data

Read this PDF : mysql_checksum

Posted in MYSQL, replication, system | No Comments »

How to configure AWR system

Posted by admin on August 6th, 2015

In this article, we introduce myawr and mongoawr system .

Read this PDF, you will learn how to configure them.

How to configure AWR system.

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

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 »