MySQL Database Basics
- Basics of RDBMS
- MySQL Intro
- MySQL DBA Carrier & Growth
- The architecture of MySQL(Physical, Logical)
Installation and Configuration
- Installation of MySQL: Windows, Linux
- Working with MySQL objects: (Tables, Views, Stored procedure, Events)
- Error handling
- Pluggable engines: (MyISAM, InnoDB, Memory, CSV, Federated, Blackhole, Merge)
- Working with MySQL configuration file.
SQL Basics for DBA
- SQL basics
- DDL Commands and Datatypes.
- DML, DCL, and TCL Commands
Users and security
- Topics: Creating Users
- Granting and revoking privileges
- Taking user backup, changing passwords.
Configuration
- Config file for InnoDB in detail.
- Configuring log files (slow log, general log)
- The architecture of MySQL(Physical)
MySQL Backup
- Topics: Backup requirement
- Physical and logical backup
- Cold and hot backup
- Enabling and disabling binary logging
- Understanding the binary log architecture
- Different backup techniques in MySQL (MySQL dump, Full backup, Transactional backup, Percona Xtrabackup)
- Restoring MySQL backup, Purging old logs
- MySQL Binlog utility and PITR(Point in Time Recovery).
Troubleshooting Production MySQL server
- General Problems and their resolution,
- Connection problems, and understanding the error log.
- MySQL DBA tools
- SQL Queries for MySQL DBA day to day activities
Performance Tuning/Optimization for large DB’s
- Performance tuning – Index suggestions
- Usage of SmartWorkbench Tool.
- Optimization – Optimizing the Mysql database.
Replication
- MySQL Binlogs, Bin-log format
- Replication Basics
- Master-Master replication
- Semi sync replication, Sync & Async replications
- MySQL Group replication, Person Extra DB cluster
- How to fix MySQL replication issues such as replication broken & replication lagging issues
Monitoring and Security Practices
- Monitoring the availability of MySQL,
- Monitoring different aspects of MySQL.
- Using tools for monitoring.
- Necessary Reporting for a MySQL DBA.
- MySQL Workbench, Percona Toolkit.
- Percona Monitoring and management (PMM)
Advance MySQL concepts
- AWS RDS & Aurora Engine
- MySQL Docker installation
- MySQL deployments using Ansible
- MySQL DevOps tools
Database Basics
- Database Normalization
- ACID Properties
- Isolation Levels
- CAP theorem
- NoSQL vs SQL
Bash Scripting
- Linux commands for DBA
- Bash Scripting for DB monitoring and backup
- Other DBA related basic scripts.
