摘要：
Preface We used to use "find" command in linux or AIX when we need to get a certain file but cannot rember the precise name.We will execute "find /pat 阅读全文
摘要：
Preface Sometimes we need to collect information of MySQL server as a report when we first time take over the system by someone else.Espcially there'r 阅读全文
摘要：
Preface I've implemented ProxySQL on PXC yesterday but got some errors when configured query rules.I'm gonna do it again in my master-slave environmen 阅读全文
摘要：
Preface As we all know,it's a common sense that separate reading and writing operations can immensely increse the performance of MySQL database.Especi 阅读全文
摘要：
Preface When we add a new node into PXC structure,it will estimate the mothed(IST/SST) to transfer data to the new node.It's no wonder that sst will b 阅读全文
摘要：
Preface Yesterday I implemented a three-nodes PXC,but there were some errors when proceeding it.So I decide to research what's wrong with it.The opera 阅读全文
摘要：
Preface Today,I'm gonna implement a PXC,Let's see the procedure. Framework Hostname IP Port OS Version MySQL Version Xtrabackup version zlm2 192.168.1 阅读全文
摘要：
Preface I supposed we are encountering a situation that there's an anonymous user has connected in our MySQL database with an account which has large 阅读全文
摘要：
Preface ibdata1 file is a shared system tablespace of innodb engine.Although we always set variable of "innodb_file_per_table" to "on" which means put 阅读全文
摘要：
Preface I've installed MasterHA yesterday,Now let's test the master-slave switch and failover feature. Framework Hostname IP Port Identity OS Version 阅读全文