MySQL administration 101
Submitted by ligaya turmelle (@lig) on Friday, 10 March 2017
Section: Full talk of 40 mins duration Technical level: Intermediate
Many sites need their employees to do more then one job - Programmer, DBA, SysAdmin. The more skills you have, the more you can contribute to the overall success of the site and improve your own marketability. Learn the basic commands of MySQL Server Administration that every SysAdmin should know.
The MySQL administration areas we will potentially go over (adjusted for timeslot and if troubleshooting talk also accepted):
- Access Control (2 stages, user accounts & passwords, GRANT/REVOKE) - Metadata (SHOW and INFORMATION SCHEMA) - Server State (option files, GLOBAL VARIABLES/STATUS, PROCESSLIST, InnoDB, Monitoring) - Logs (Error, Slow Query, General, Binary) - Backups (basics on types and methods)
Ligaya Turmelle is a full time Goddess, part time MySQL DBA, occasional PHP programmer, and frequent world traveler. She currently has visited or lived in 21 countries and now resides in Florida with her husband and their Belgian Malinois. As a MySQL Support Engineer for Oracle she still manages to stay involved with the PHP Community as a founding Principal of phpwomen.org and long-time busy body of the PHPCommunity channel (#phpc) on freenode. She hopes to one day actually meet all the people she talks to. Now for all the letters – OCP: MySQL 5.6 DBA, OCP: MySQL 5.6 Dev, CMDBA (5.0), CMDEV (5.0), MySQL Core (4.1), ZCE (PHP4&5) and Oracle ACE for MySQL.