Author: Edwin Wang

With support of multi-threads replication starting from MySQL 5.7, the operations on slave are slightly different from single-thread replication. Here is a list of some operation tips for the convenience of use as below: 1. Skip a statement for a…

Whenever we want a query’s results sorted, you may think of using the clause “order by.” You are correct: most of the time, MySQL will return the results in expected order with “order by.” Be careful, though. Sometimes MySQL may return…

Recently I received a request from one of our clients asking the way to mysqldump data only from a view. The request sounds reasonable at the first glance, but after thinking it a little bit further, we will find out…

Edwin Wang, MySQL DBA at Pythian, provides some important MySQL query best practices.

Edwin Wang, MySQL DBA at Pythian, details best practices for setting up MySQL replication filters.

“You are lucky,” the taxi driver told me when he picked me up at the Ottawa Airport. “It began snowing right after your flight landed.” I personally like snow — just like the Chinese saying, “heavy snow brings heavy harvest”….