YoVDO

MySQL for System Administrators

Offered By: linux.conf.au via YouTube

Tags

linux.conf.au Courses MySQL Courses System Administration Courses Database Management Courses Shell Scripting Courses Stored Procedures Courses Command Line Interface Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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

The Open-Source Chatbot That Accidentally Built a Community
linux.conf.au via YouTube Add Depth - Stereoscopic Imagery for Everyone
linux.conf.au via YouTube Becoming a Tyrant - Implementing Secure Boot in Embedded Devices
linux.conf.au via YouTube The seL4 Foundation - Growing Through Upheaval
linux.conf.au via YouTube Conference Close
linux.conf.au via YouTube