replication

MySQL special character rollback

August 16, 2017 Architect, Internals, MYSQL, replication No comments

Actually, Mysqlbinlog tools can’t miner mysql binlog exactly correct.

In this post ,a special environment we got may hexadecimal characters what we[……]

Read more

[JKDB] BACKUP AND RESTORE

May 11, 2017 Architect, backup, hardware, IDC, maintain, MYSQL, rdbms, replication, system No comments

JKDB PLATFORM – our company’s data management platform

In this post, we introduce backup-restore module,focus on automatic backup and restore in a[……]

Read more

MySQL distributed message system

April 12, 2016 Architect, Architecture, hardware, MYSQL, replication, software No comments

Based on messages, we create mysql replication platforms , using async message to build strong distributed subscription system.

read this PDF : htt[……]

Read more

MySQL checksum

August 19, 2015 MYSQL, replication, system No comments

how to use percona-tookit to verify mysql data

Read this PDF : mysql_checksum[……]

Read more

MariaDB : Bug when add index on Partition table

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

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

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

MySQL replication case 一则

September 10, 2013 MYSQL, replication No comments

最近同事处理了一则mysql复制错误.发出来参考下

MYSQL同步出错，报错信息如下：

Last_Errno: 1267
Last_Error: Error 'Illegal mix of collations (utf8_general_ci,COERCIBLE) and[......]
Read more