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

Managing Big Data with MySQL
Duke 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