MySQL Backup and Security - Best practices

The MySQL Server is a very widely used open source database system which is often used as the storage backend for PHP-powered sites. Therefore performing MySQL backups and maintaining a secure installation are two very common tasks for any site administrator. In this talk, Lenz will provide useful hints and suggestions on how to improve the security of a MySQL installation and how to properly perform backups of the databases and tables. The session will cover both tools that are included in the MySQL Server distribution as well as common utilities and facilities provided by the operating system (Linux in particular). The part about improving MySQL Server security will talk about the available mechanisms on the server side and how they can be reinforced and accompanied with security features on the Operating System level. Various backup methods for MySQL exist (both logical and physical. The second part of the session will cover several available options and highlight some practical solutions as well as related tools. Users attending this session will hopefully pick up some useful hints and learn about best practices on how to secure their MySQL installations and how to perform proper and consistent backups.