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
Introduction to LinuxLinux Foundation via edX Rapid Deployment of SAP Solutions
SAP Learning SAP Screen Personas
SAP Learning Office 365: Managing Identities and Services
Microsoft via edX Microsoft Exchange Server 2016 - 3: Mailbox Databases
Microsoft via edX