MySQL for System Administrators
summary
Practical checklist for admins: show your prompt with mysql_ps1 so you never run commands on the wrong server; avoid command-line passwords and use .my.cnf or mysql_pwd for scripted auth; use mysqldump for schema and mysql.proc, use Percona XtraBackup or VM/LVM snapshots (mylvmbackup) for fast restores; check logs in /var/log/mysql/ (error, slow, general) and run SHOW REPLICA STATUS to verify lag; prefer InnoDB with file_per_table and use shell tools (sed/grep/awk) for quick queries and audits.
AI-written summary · about
chapters (18)
- 0:00Intro
- 0:18MySOL for System Administrators
- 1:10Upcoming Presentations
- 1:20Default MySQL prompt
- 1:42Percolating Selzer
- 3:07Cluster to three
- 3:17OpenSSH: the Home Game
- 3:59Interactive authentication
- 5:40Authorization / Privileges
- 6:15Stored Procedures
- 7:48Percona Xtra Backup
- 7:58Snapshots
- 9:58Querying Data
- 10:11Build your own pipeline
- 12:26Character sets
- 12:38Community
- 13:47Resources
- 14:12Credits
related talks
15mMySQL for System Administrators
44mMySQL Administration 101
28mBecoming a DBA for 5 minutes a day, the most important things to know for sysadmins and developers
01mAre you an "accidental" DBA?
53mMySQL DevOps
20mHardening MySQL: MySQL Security Basics - MySQL security Tutorial
53mIntroduction to MySQL Performance Tuning - workshop 1hr
45mMySQL backups strategy, tools, recovery scenarios