MySQL for System Administrators

Discover essential MySQL skills for system administrators in this 15-minute conference talk from linux.conf.au 2021. Learn to leverage command-line expertise for MySQL administration, covering topics such as shell environment setup, authentication, custom prompts, backups and restorals, database engine selection, log management, and monitoring. Gain practical knowledge to maintain MySQL instances effectively, even with limited DBA support, and understand how to balance sysadmin and DBA roles in database management.

Syllabus

Intro
MySOL for System Administrators
Upcoming Presentations
Default MySQL prompt
Percolating Selzer
MYSQL PS1 example
Cluster to three
OpenSSH: the Home Game
Non-automagic authentication
Interactive authentication
Authorization / Privileges
Stored Procedures
Percona Xtra Backup
Snapshots
Querying Data
Build your own pipeline
Use your favorite CLI tools
Sysadminny examples
Character sets
Community
Resources
Credits