摘要：
Preface MasterHA is a tool which can be used in MySQL HA architecture.I'm gonna implement it and have some tests depend on it later. Framework Hostnam 阅读全文
摘要：
Preface I've stuck twice in my previous experiments in backing up dropped tables.I am still not sure that why I got failure yesterday.Therefore,I deci 阅读全文
摘要：
Preface In my previous blogs,I've demonstrated several mothods of how to rescue a dropped table(or truncated table as well). full mysqldump backup + b 阅读全文
摘要：
Preface We're used to get a logical backup set(whole instance) by simply specifying "--single-transaction" and "--master-data" options.For innodb engi 阅读全文
摘要：
Preface Today I'm gonna test how to rescue a dropped table from binlog server based on a full Xtrabackup backup set. Preface Today I'm gonna test how 阅读全文
摘要：
Preface Yesterday,I've demonstratated how to rescue a droped and a truncated table based on mysqldump backup.Let's see what's different in rescuing th 阅读全文
摘要：
Preface How to rescue a dropped or truncated table online?Dropping or truncating is ddl operation which cannot be flashed back by the populare flashba 阅读全文
摘要：
Preface I've been demonstrated how to implement a master-slave structure using mysqldump in my previous blog.I'm gonna use Xtrabackup to do it again n 阅读全文
摘要：
Preface I suppose that we have a requirement of checking out how many duplicated indexes on a certain table or even on several specific databases.what 阅读全文
摘要：
Preface There always be some table join operations in our SQL statement.Although we can know details of table join information from explain opertion b 阅读全文