MySQL for System Administrators
summary
Shows exactly what to change and where: set a mysql_ps1 prompt to avoid typing on the wrong host, use .my.cnf/mysql_pwd files rather than plaintext passwords on the command line, and pipe SQL output to sed/grep/awk for quick checks. Recommends mysqldump for schema dumps, Percona XtraBackup or VM/LVM snapshots (mylvmbackup) for fast restores, and points at /var/log/mysql/ slow/general logs and SHOW REPLICA STATUS; prefer InnoDB with file_per_table and tune for faster shutdowns.
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
53mMySQL DevOps
01mAre you an "accidental" DBA?
20mHardening MySQL: MySQL Security Basics - MySQL security Tutorial
53mIntroduction to MySQL Performance Tuning - workshop 1hr
57mThe Evolution of a MySQL Database System