how to use percona-tookit to verify mysql data
Read this PDF : mysql_checksum[……]
August 19, 2015 MYSQL, replication, system No comments
August 6, 2015 Architect, Architecture, mongodb, MYSQL, NoSQL, rdbms, software No comments
In this article, we introduce myawr and mongoawr system .
Read this PDF, you will learn how to configure them.
July 24, 2015 Architect, Architecture, Internals, MYSQL, network, system No comments
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:
July 15, 2015 Architect, mongodb, MYSQL, software No comments
Architecture of WEBM system.
Reference:
http://www.vmcd.blog/2014/10/webm_v2-has-been-released/
http://www.vmcd.blog/2014/09/webm-mysql-database-performance-web-monitor/
View this PDF:
http://www.vmcd.blog/docs/How%20to%20configure%20WEBM.pdf[……]
April 24, 2015 system No comments
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[......]
April 23, 2015 Internals, MYSQL, replication No comments
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.[……]
April 22, 2015 Architect, MYSQL, software No comments
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:
March 13, 2015 system No comments
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[……]
January 20, 2015 Architect, Architecture, MYSQL, rdbms, software No comments
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[……]
December 31, 2014 Architect, Architecture, MYSQL, software No comments
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 machines for this test.
environment:
master server: 10.0.128.77 slave server : 10.0.128.110/113/114 port : 3306
———————–[……]