MySQL Tcpdump system : use percona-toolkit to analyze network packages
We can identify problem SQLs with high execution frequency.
With DBMON s[……]
Category: Architecture
Architecture of data warehouse which is based on MQ
Recently, we create a mysql data warehouse which is based on message queue.
Most companies must prepare for particular queries in their systems if[……]
MHA with binlog server
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[……]
MySQL-Oslayer-Performance-Optimization
upload on 2014.12
important tips of MySQL database design for better performance
Read : mysql-system-opt[……]
MySQL message subscription system
Introducing MQ system based on MySQL (canal + roma)
Using this system to subscribe message between different platforms.
View this PDF roma_syste[……]
MyAWR : MySQL Workload Report V3 release
myawr-v3 release now !
history of myawr:
————————–
v1: create by noodba
mysql load information and system information
[……]
Talk about some MySQL HA architecture
MySQL Fabric HA&Sharding solutions
Good news for MySQL HA solutions
Oracle Clusterware is portable cluster software that allows clustering of independent servers so that they cooperate as a single system. Oracle Clus[……]
news in mysqlbinlog – Back Up Master Binary Log Files
news in mysqlbinlog – Back Up Master Binary Log Files
从mysql5.6开始 mysqlbinlog开始支持远程读取master主机的binlog写入本地,极大的加强了binlog的备份策略,由于在mysql cluster复制环境中,b[……]