List of articles dedicated to MySQL

Here below is a list of articles & ideas all dedicated to MySQL databases. Since most web projects are powered by MySQL when it comes to database, it’s important to understand certain aspects such as performance, tuning, security, replication, etc. Basic understanding of how databases work may come handy when reading the articles, of course. If you need expert consultations feel free to contact me.

• Performing regular backups and point-in-time recovery
• Enabling logging of issued SQL statements
• Understanding indexes
• Memory tuning & filesystem tuning & data optimisation
• Moving datafiles between two databases
• Difference between MYISAM and InnoDB engines
• Partitioning
• Enabling remote access to a MySQL database
• How to setup replication
• Rebuilding indexes and checking health of tables