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[……]
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 la[……]
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 sim[……]
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[……]
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[……]
December 13, 2014 Architecture, MYSQL, performance No comments architecture
upload on 2014.12
important tips of MySQL database design for better performance
Read : mysql-system-opt[……]
December 9, 2014 Architect, Architecture, MYSQL, replication, software No comments MQ
Introducing MQ system based on MySQL (canal + roma)
Using this system to subscribe message between different platforms.
View this PDF roma_syste[……]
December 2, 2014 Architecture, MYSQL, performance No comments mysqlawr
history of myawr:
————————–
v1: create by noodba
mysql load information and system information
[……]
September 28, 2014 Architect, MYSQL, performance No comments architecture, mysql, webm
You can download webm from github: https://github.com/ylouis83/webm
webm: mysql web key performance monitor
webm is a tool that display key val[……]
September 2, 2014 Internals, MYSQL, oracle No comments internal
很久之前看过这个帖子,当时没有细究,这几天看了下mysql相关的internal 突然想起这个问题,跟三四个朋友讨论了下 想把这个问题展开讲一讲。
源帖子内容见：https://community.oracle.com/thread/1087650?start=0&tstart=0
这个[……]
August 21, 2014 MYSQL, performance No comments architecture, mongodb, mysqlawr, nosql
Reference Oracle AWR. These two was developed by python and perl.
Both of these are following data collection method.
Use these tools can help[……]