This is just a copy from the origin article https://plusbryan.com/mysql-replication-without-downtime The original site has been taken down. Since this is very useful, I am posting the original content here for future reference. Setting up MySQL replication without the downtime I clearly
Set up a MySQL user dedicated to backups
It is not a good idea to use the root MySQL account to do backups. So, let’s create a user dedicated exclusively to doing backups. Log on to MySQL as root: mysql -u root -p Then create the new user
Oracle – Change the behavior of ORDER BY
There are times when you would like to order the results of a query in such a way that it cannot be accomplished by the default behavior of the order by clause. For example, let’s look at the following table: