摘要：
Preface We've used pt-table-checksum to checksum the different table data bwtween replication master and slaves yesterday.In this case,i'll use anothe 阅读全文
摘要：
Preface The master-slave replication is commonly used in our product evironment.On account of network lag or replicaton mode,slaves probablly be delay 阅读全文
摘要：
Preface As we all know,it's really a troublesome thing to DBA in scenario of changing table structure online.Since MySQL 5.6,it support online ddl ope 阅读全文
摘要：
Preface There's a common case that we neet to archive amount of records in some tables to a file or another table in different database even delete th 阅读全文
摘要：
Preface We commonly use VMware or VirtualBox to install our Virtual Machines before.For the sake of creating a simple testing environment with less re 阅读全文
摘要：
Preface In my previous two blogs,we have known about the tool of backing up MySQL db.I'm gonna use another tool named "MySQL Data Dumper" to do some t 阅读全文
摘要：
Preface Today,I'm gonna use the Xtrabackup tool to demonstrate the procedure of backing up MySQL db server.The lastest version of Xtrabackup is 2.4.11 阅读全文
摘要：
Preface The day before yesterday,there's a motif about the lock procedure when backing up MySQL using mysqldump or Xtrabackup in "Ask Ye" which is lik 阅读全文
摘要：
Preface I've implemented the Group Replication with three servers yesterday,What a shame it eventually terminated in several glitches.Now that it does 阅读全文
摘要：
Preface We've learned the machenism of MGR yesterday,Let's configurate an environment and have some test today.MGR can be installed as plugin like sem 阅读全文