Having a strategy of backup information is really important. We tend to neglect it and think about it after the first loss of information. Here is my backup script of my MySQL databases.

Writing unit or functional tests on code has almost become a standard. Having a server that automates the verification of these tests and deploys the code is the goal of many development teams. Despite this, these good practices are rarely implemented for database schema migrations. In this article, I'll show you how with a little bash and Jenkins, I test and automate my SQL migrations.

Alter table operation can be a very long task, depending on your database. It's often that database administrator wait too run these operations and do it late in the night to avoid disturbing user. But solutions exist to allow alter table without locking table, pt-online-schema-change from Percona Toolkit is one of these solutions.

Manipulating dates in a programming language (PHP, Java ....) is simple and known to all. But what about in the MySQL database? In this article I present what it is possible to do in SQL queries: operation, date interval ...

Background: One site offers its members to vote to elect the member of the month. Each month the counters are reset to zero. On a dedicated page, the site displays the history of the top 5 members of each month over a period of one year.