PLUG Video: der.hans: MySQL for System Administrators

[Brian Cluff]

Presented at the Phoenix Linux Users Group (PLUG) on May 14th 2015 by 
der,hans.

MySQL is ubiquitous. It will be for many years. A little knowledge will 
go a long way to having a good MySQL setup. A little knowledge will also 
leverage your command line knowledge when working with MySQL.

Restorals are paramount, but you can't just backup the files. Databases 
have special requirements for proper backups. MySQL has mechanisms for 
controlling access, but general system administration tools can be used 
in addition to the MySQL grants.

MySQL has several database engines available, choose wisely and 
configure it properly before starting.

The slow query log can be useful for finding long-running queries, but 
it's not the only place to find useful log information.

The presentation will also cover OS changes and good practices that will 
help the system administrator use and administer MySQL without having to 
become a DBA.

https://youtu.be/uqnbaclN48A

Brian Cluff