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

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 num[......]

Read more

Posted in system | 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[……]

Read more

Posted in system | No Comments »

小型机迁移x86平台之老生常谈

Posted by admin on July 17th, 2014

You can view this presentation click here: x86_architect
注意使用chrome打开文件 不然可能乱码

Tags:
Posted in migration, oracle, system, unix | No Comments »

linux tools part 9– Monitoring system performance

Posted by admin on April 25th, 2014

淘宝的开源监控工具 –同事推荐安装测下来非常不错 可以配合zabbix进行数据的采集

link:http://tsar.taobao.org/

[mysql@mysqldb tmp]$ tsar 
 
Time           ---cpu-- ---mem-- ---tc[......]

Read more

Posted in linux, system | No Comments »

IBM will support Flash In DIMM using MCS

Posted by admin on January 17th, 2014

The next generation of IBM’s X-series servers will be able to accommodate solid-state Flash drives clipped into their DIMM memory slots, potentially i[……]

Read more

Tags:
Posted in Architect, hardware, system, unix | No Comments »

团队合照一张

Posted by admin on December 25th, 2013

团队圣诞合照一张,缺了一个同事,也走了几个同事,往事不堪回首 – -)

IMG_0975

Tags:
Posted in system | No Comments »

闲聊,闲扯

Posted by admin on October 30th, 2013

letsdiscusspng

一个月没写blog了,不想在10月打破连续每月blog的传统,那就说一说1号店今年的IT发展吧,纯属闲扯。

首先rdbms数据库方面,继续坚持之前制定的方针,大量的oracle转向的mysql(mysql在oracle接手之后,稳定性确实得到了极大的提高,innodb的并发能力提升[……]

Read more

Tags:
Posted in system | No Comments »