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
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss
(text/plain)