Recently, we create a mysql data warehouse which is based on message queue.
Most companies must prepare for particular queries in their systems if[……]
Category: Architecture
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[……]
Multi-Master-Rep in MySQL DB
Multi-master-rep
two masters: -- 192.168.126.128 mysql 5.6.12 -- 192.168.126.129 mysql 5.6.12
slave : -- 192.168.126.130 MariaDB 10.0
[……]