MySQL Database Administration

Buy $149.00

Course curriculum

1. 1- ( Presentation) Introduction of MySQL
1. 2- (Recording and Demo steps )How to Install MySQL on Linux ?
2. Assignment on installation of MySQL on Linux
1. Recording and Demo steps (How to Reset lost root MySQL password ?)
2. Assignment
1. Recording and demo steps How to run Mysql as Mysql OS user
2. Assignment
1. Assignment on How To Allow Remote Access to MySQL ?
2. (Recording and demo steps ) How to enable remote connection to MySQL database ?
1. How to load sample database like sakilla /db_master in MySQL ?
2. Assignment ( How to load sample database in MySQL ? )
3. Recording and demo steps
1. How to Find the location of my.cnf in Mysql Linux server ?
1. Tuning Primer script for tuning
1. mysqltuner.pl- High Performance MySQL Tuning Script
1. How to find my.cnf file in linux for MySQL Server ?
1. Recording and Demo Steps (Backup and restore in Mysql database via mysqldump/mysql command)
2. Assignment Backup & Restore in MYSQL Database server ( mysqldump/mysql utility)
3. Assignment on ( backup all MySQL DB's on Linux , compress and schedule as script )
4. Backup script automated on linux
5. Backup and restore in Mysql via Workbench
1. Recording and demo steps Upgrade MySQL 5.7 to 8.0 on Ubuntu Linux
1. Upgrade Via backup and upgarde
1. Demo steps for Upgrade Checker Utility.
1. MyDumper/myloader
1. Password less authentication using mysql_config_editor
2. (Recording and demo steps )Password less authentication using mysql_config_editor
1. MySQL Backup Tools
1. Recording an demo steps Replication across version ( Replication between 5.7 to 8.0 )
1. mysql workbench recordings and demo steps
1. mysqlslap perf load testing tool
1. Recording and demo steps Bin Log
2. mysqlbinlogpurgetool to Purge/delete MySQL Binary Logs
1. Recording and demo on ( MySQL GTIDs Replication)
2. Assignment on GTID Replication
1. Recording (MySQL Master-Slave Replication )
2. Assignment : Replication master and slave setup
3. master and slave replication setup Configure the slave of 2 existing databases
4. How to check the replication status using shell script in MySQL master replica?
5. Demo and recording steps
6. Monitoring Replication Main Threads using show processlist
7. How to Pause Replication on the Replica?
8. Troubleshooting Replication in Mysql ?
9. Add one More replica database to existing master replica setup ?
1. Recording and demo on ( MASTER MASTER REPLICATION in MySQL )
1. Recording and demo (Sysbench , MySQL Benchmark Performance Tool ?)
2. Assignment Sysbench , MySQL Benchmark Performance Tool ?
1. What are different types of MySQL Server Logs and their Importance ?
1. mysqladmin is an administration program for tasks in MySQL.
1. MySQL user management
2. MySQL percona / percona-toolkit
1. MySQL Upgrade strategies
1. Recording and Demo steps (How to synchronize two databases by using MySQL Workbench)
2. How to Compare two Databases using MySQL Workbench
3. How to migrate database from one mysql server to another MYSQL server (Schema Migration WIZARD)
4. How to migrate database/replicate from one mysql server to another host(MIGRATION WIZARD)
1. Recording and Demo steps (Group replication in MySQL)

About this course

$149.00
57 lessons
6.5 hours of video content

MySQL Database Administration

Course curriculum

1- Introduction of MySQL

2- How to Install MySQL on Linux ?

How to Reset lost root MySQL password ?

How to Run MySQL service as a MySQL OS User on Linux ?

3- How to enable remote connection to MySQL database ?

How to load a sample database ( sakilla ) in MySQL ?

Mysql configuration file my.cnf

Tuning Primer script for tuning

mysqltuner -High Performance MySQL Tuning Script

How to find my.cnf file in Linux for MySQL Server ?

Backup & Restore in MYSQL Database server ( mysqldump/mysql utility)

How to upgrade MySQL 5.7 to 8 on ubuntu

Upgrading one major version via SQL Dump

MySQL Shell Upgrade Checker Utility

mydumper / mydumper

Password less Authentication in Mysql

MySQL Backup Tools

Replication across versions

mysql benchmarking tool

mysqlslap

How to remove the Binary logs in MySQL ?

MySQL GTIDs Replication

How to Configure MySQL Master-Slave Replication ?

MASTER MASTER REPLICATION

Sysbench , MySQL Benchmark Performance Tool ?

What are different types of MySQL Server Logs and their Importance ?

mysqladmin utility for database administration

Mysql user management

MySQL Upgrade strategies

How to synchronize two databases by using MySQL Workbench

How to setup MySQL Group Replication

About this course