Actually, Mysqlbinlog tools can’t miner mysql binlog exactly correct.
In this post ,a special environment we got may hexadecimal characters what we[……]
Category: replication
[JKDB] BACKUP AND RESTORE
JKDB PLATFORM – our company’s data management platform
In this post, we introduce backup-restore module,focus on automatic backup and restore in a[……]
MySQL distributed message system
MySQL checksum
MariaDB : Bug when add index on Partition table
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[……]
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[……]
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
[……]
MySQL replication case 一则
最近同事处理了一则mysql复制错误.发出来参考下
MYSQL同步出错，报错信息如下：
Last_Errno: 1267 Last_Error: Error 'Illegal mix of collations (utf8_general_ci,COERCIBLE) and[......]