MySQL Administration 101
summary
Covers concrete MySQL admin actions: how connection vs authorization phases match host then user, GRANT/REVOKE behavior (revoke is dumb; must revoke ALL then regrant to remove one right), password expiration and plugins in 5.6/5.7, use of SHOW/INFORMATION_SCHEMA and performance_schema for diagnostics, logs to collect (error, slow, general, binary) with recommendations like verbose error log and slow-query-as-first-defense, backups: logical (mysqldump rock solid, mysqlpump parallel dump in 5.7, SELECT INTO OUTFILE caveats) and physical (fs snapshots, binary logs for PITR).
AI-written summary · about
chapters (22)
- 0:00Intro
- 1:13Program Agenda
- 1:57Access Control
- 4:06User Accounts
- 5:20Passwords
- 10:17GRANT Examples
- 12:23REVOKE Examples
- 15:07INFORMATION SCHEMA
- 16:08SYS Schema
- 19:11Workbench -SYS Reports
- 19:55PERFORMANCE SCHEMA
- 22:29Error Log
- 25:22Slow Query Log
- 27:58General Query Log
- 33:18Backup Types
- 33:59Logical Backups
- 36:27mysglpump
- 37:39SELECT... INTO OUTFILE and LOAD DATA INFILE
- 38:48Physical Backup
- 39:20Filesystem Snapshot
- 39:56MySQL Enterprise Backup
- 40:37Don't Forget Your Binary Logs
related talks
15mMySQL for System Administrators- 15mMySQL for System Administrators
28mBecoming a DBA for 5 minutes a day, the most important things to know for sysadmins and developers
12mAdvanced database topics and Database 101 for Developers
20mHardening MySQL: MySQL Security Basics - MySQL security Tutorial
53mIntroduction to MySQL Performance Tuning - workshop 1hr
22mAn Overview of Security Features in MySQL 5.7
49mMySQL monitoring and debugging: maximum insight with minimal cost