摘要：
Preface I got an replication error 1236 when I modified the password of a user without starting slave threads of replication.Further more,the user was 阅读全文
摘要：
Preface As a dba,We are obliged to master several basic tools(such as vmstat,top,netstat,iostat,df,etc.) to monitor system status or analyze the the i 阅读全文
摘要：
Preface If we want to check out how many slaves in our replication environment.We can execute "show processlit;" on master.Whatif we'd like to check t 阅读全文
摘要：
Preface Sometimes,the threads(especially the SQL_Thread) will be terminated by accident.The slave will stop until we fix the relevant error or just sk 阅读全文
摘要：
Preface In my last test of pt-heartbeat,both of master and slave were out of disk.And the mysql client was hang.In order to resolve the issue,I've try 阅读全文
摘要：
Preface Replication delay is a common issue in MySQL replications.Especially in those replications not using semi-synchronous method.Long term delay l 阅读全文
摘要：
Preface There're various data type in MySQL such as number,string,date,time,lob,etc.The data type will convert implicitly if we don't use a proper ope 阅读全文
摘要：
Preface Semi-synchronous replication is supported since MySQL 5.5 and then enhanced gradually in 5.6 & 5.7.It's also called enhanced semi-synchronous 阅读全文
摘要：
Preface I've demonstrated how to change character set in Oracle database in my previous blog.Now,I'm gonna do the similar operation in MySQL database, 阅读全文
摘要：
Preface Classic replication is commonly used in previous version of MySQL.It's really tough in managing them when our replications get into failures.M 阅读全文