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 system and AWR system we can find problem SQLs in a special time (high frequency, occurs over a period of time)

View this PDF:

http://www.vmcd.o[……]

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-performance-web-monitor/

View this PDF:

http://www.vmcd.org/docs/How%20to%20configure%20WEBM.pdf

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

linux tools part 10– Monitoring process iostat

Posted by admin on April 24th, 2015

We can use iopp tool to monitor process io performance

download from github : https://github.com/markwkm/iopp

pid: The process id.
rchar: The number of bytes which this task has caused to be read from storage.
wchar: The number of bytes which this task has caused, or shall cause to be written[......]

Read more

Posted in system | 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 large partition table , Mariadb do — copy to tmp table on the slave side. It takes a long time and still not finish over 9 hours.

Primary : MySQL 5.[……]

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 similar to Oracle database :)

Read this presentation I post on slideshare:

MySQL 5.7 milestone

Posted in Architect, MYSQL, software | No Comments »

Design for “seckilling ” on MySQL

Posted by admin on March 13th, 2015

Today I read a nice article , which give a new design for mysql database . In this article , Author (Mr.lou) uses OneSQL (a branch of MySQL) for the whole test.

you can read from : http://www.onexsoft.com/?page_id=378

This article explain how to use mysql in seckilling scenario (especially f[……]

Read more

Posted in system | 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 they consider to split their databases or tables into many pieces.

some problems should be solved in this situation:

1. how to get correct re[……]

Read more

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