MySQL for System Administrators
Offered By: linux.conf.au via YouTube
Course Description
Overview
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
Taught by
linux.conf.au
Related Courses
Managing Big Data with MySQLDuke University via Coursera Database Management Essentials
University of Colorado System via Coursera Business Metrics for Data-Driven Companies
Duke University via Coursera Bases de données relationnelles : Comprendre pour maîtriser
Inria (French Institute for Research in Computer Science and Automation) via France Université Numerique Базы данных (Databases)
Saint Petersburg State University via Coursera