Author: Edwin Wang

MySQL 5.7 Multi-threads replication operation tips

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…

Read More >

MySQL may return results in non-deterministic order with ‘order by’

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…

Read More >

The rlwrap utility for DBA.

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…

Read More >

MySQL Query best practices

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

Read More >

Best practice for setting up MySQL replication filters

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

Read More >

My first week at Pythian

“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”….

Read More >