Architecture

Architecture of data warehouse which is based on MQ

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[……]

Read more

MHA with binlog server

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[……]

Read more

MySQL-Oslayer-Performance-Optimization

December 13, 2014 Architecture, MYSQL, performance No comments

upload on 2014.12

important tips of MySQL database design for better performance

Read : mysql-system-opt[……]

Read more

MySQL message subscription system

December 9, 2014 Architect, Architecture, MYSQL, replication, software No comments

Introducing MQ system based on MySQL (canal + roma)
Using this system to subscribe message between different platforms.

View this PDF roma_syste[……]

Read more

MyAWR : MySQL Workload Report V3 release

December 2, 2014 Architecture, MYSQL, performance No comments

myawr-v3 release now !

history of myawr:

————————–
v1: create by noodba

mysql load information and system information 

[……]

Read more

Talk about some MySQL HA architecture

August 12, 2014 Architecture, MYSQL No comments ,

Some tips for MySQL architecture

read : JKDB-mysql-arc[……]

Read more

MySQL Fabric HA&Sharding solutions

June 18, 2014 Architecture, MYSQL No comments

MySQL Fabric

Download : MySQL fabric solutions[……]

Read more

Good news for MySQL HA solutions

June 9, 2014 Architecture, MYSQL, replication No comments


Oracle Clusterware is portable cluster software that allows clustering of independent servers so that they cooperate as a single system. Oracle Clus[……]

Read more

news in mysqlbinlog – Back Up Master Binary Log Files

May 13, 2014 Architecture, MYSQL, replication No comments

news in mysqlbinlog – Back Up Master Binary Log Files

从mysql5.6开始 mysqlbinlog开始支持远程读取master主机的binlog写入本地,极大的加强了binlog的备份策略,由于在mysql cluster复制环境中,b[……]

Read more

Multi-Master-Rep in MySQL DB

May 12, 2014 Architecture, MYSQL, replication No comments

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

[……]

Read more