Advanced MySQL DBA Online Training

1.Open Source Introduction

  • Overview & History of MySQL
  • The Main Features of MySQL
  • Basics of Linux Commands

2.MySQL Installation

  • Linux OS Installation
  • Installing MySQL Server on Linux
  • How to start, stop and restart the server
  • How to check the MySQL status and Configuration file
  • System Databases, System Tables & Dictionary Views
  • MySQL Architecture

3.Storage Engines with Simple Examples

  • The InnoDB Storage Engine    
  • The MyISAM Storage Engine
  • The MEMORY Storage Engine
  • The CSV Storage Engine    
  • The ARCHIVE Storage Engine
  • The BLACKHOLE Storage Engine
  • The MERGE Storage Engine    
  • The FEDERATED Storage Engine    
  • MySQL Server Installion On Windows
  • Workbench Installation

4.Tablespace Management

  • Create Tablespace
  • Alter Tablespace
  • Drop Tablespace

5.MySQL User management.

  • Creating Users & User Table
  • Renaming Users
  • Changing Passwords
  • Granting Privileges
  • Create SSL Users
  • Dropping Users

6.MySQL Server logs

  • Error Log
  • General Log
  • Slow Log
  • Binary Log
  • Relay Log
  • Audit Log

7. Database Backup Methods

  • Using mysqldump for Backups
  • Dumping Data in SQL Format.
  • Backups
  • Restore
  • Binary log Recovery
  • Purge binary log
  • mysqlpump

8.Percona Server

  • Percona Overview
  • Percona Server Installation
  • Percona XtraBackup Installation
  • Configuration of XtraBackup
  • Taking Full Backup
  • Taking Incremental Backups
  • Restoring / Recovering Full Backups and Incremental
  • Partial Backups
  • Enable Audit Logs
  • XtraBackup Installation on MySQL Server

09. Performance Tuning - Partitioning

  • Overview of Partitioning in MySQL
  • Partitioning Types
  • RANGE Partitioning
  • LIST Partitioning
  • HASH Partitioning
  • KEY Partitioning
  • Obtaining partitioned information
  • Modifying and removing partitions

10. Managing Multiple instances

  • Installing MySQL Server from Generic Binaries
  • Setting Up Multiple Data Directories
  • Running Multiple MySQL Instances on Linux
  • Managing Multiple MySQL Servers

12. Scaling and High Availability

  • Types of Replication
  • Master-Slave Configuration
  • Master-Master Configuration
  • Adding Slave to Master – Master Setup (Chain Replication)
  • Multi Master Replication
  • GTID Replication
  • Replication Troubleshooting

13. Performance Tuning

13.1 Configuring InnoDB

·    The InnoDB Buffer Pool

·    Managing InnoDB Data and Redo Log Files.

o    Change the location of the ibdata file

o    Adding 2 ibdata files

o    Change the position of log files

  •  Increase the redo log files with 4 or 6
  •  Memory allocation for Innodb
  • Turnoff Innodb

13.2 About Locking & Issues

    • Locking Methods
    • Table Locks
    • Deadlock

 13.3 Optimization & Indexing

    • About Constraints
    • Types of Indexes
    • Explain Plan Querying
    • Indexing Strategies for High Performance
    • Index Maintenance
    • Analyze table &Optimize table

14. Monitoring Tools Overview

    • Percona (PMM)
    • Idera Monitoring
    • DBeaver

15. AWS Cloud

    • What is Amazon RDS
    • Configure MySQL Amazon RDS (PAAS)
    • Setting up with Workbench

16. Upgrading RDS MySQL

  • MySQL Server 5.7 to MySQL Server 8

17. Migration

    • Onprem to AWS RDS MySQL Server
No Comment
Add Comment
comment url