MySQL Replication course from zero to hero | MySQL DBA
What you'll learn
- MySQL Database Replication
- MySQL Database Administration
- MySQL Master slave Replication
- MySQL High availability
Requirements
- MySQL DBA basic understanding is required
Description
What you will learn in this course.
Some Great Skil requires for MySQL Database administration
Introduction to Replication and Different type of topologies.
Master-Slave
Master and Multi slave
Master-Master Replication
How to add filters in Replication, ignore tables, or database.
Configure replication (mysqldump,extrabackup,xbstream,Mydumper,clone plugin).
How to install Percona Xtrabackup
How to take backup using Extrabackup
How to take a full backup,
how to take incremental backup.
how to restore the full backup and apply incremental backup.
Difference btw GTID/traditional log position-based replication.
Configure Semi-syn replication.
Configuring the Slave-delay.
Type of binary log formats.
row base
statement base
mix mode
Failure scenarios of Mysql, how to sync replication.
How to use pt-slave-restart.
How to solve errors, errant GTID on the slave.
Checking what is the error.
Duplicate user error, Duplicate key error.
How to skip those errors
How to find if there is Errant GTID.
how to identify the errant GTID.
How you can read the Binary Logs.
How to check Replication consistency.
How to use pt-table-checksum and pt-table-sync.
Install Percona Monitoring and Management
How to configure Multi Thread Slave.
Checking if Workers are Replicating fine.
What is the limitation of MTS?
Creating views for easy monitoring of the MTS.
Configure Orchestrator for Failover.
NOTE: Below Lectures are Pending Please wait for it I am working on them coming soon :)
How to do graceful failover with Orachestaror.
How to solve errant GTID with Orchestrator.
Configure ProxySQL for the load balancer.
How to split read and write using ProxySQL.
Testing the Node failure and load balancing with ProxySQL.
Who this course is for:
- MySQL Database Administrator
Instructor
- 4.3 Instructor Rating
- 167 Reviews
- 1,251 Students
- 2 Courses
Over 4-year experience of Administration in Oracle, and MySQL databases using various tools and technologies. Keen on learning new database technologies having very good analytical skills. Working knowledge of Red Hat Linux, UNIX, Solaris, and Windows Server 2012 is a valuable addition to my knowledge desk.
KNOWLEDGE & SKILLS
MySQL:
• MySQL 5+, 8+ Administration, MySQL Workbench, MySQL Enterprise Monitor, SQLyog
• MySQL Installation using yum repo, RPM packages, and generic binary tarball.
• MySQL user, space management.
• MySQL Point In Time Recovery (PITR) from binary logs in case of failure.
• Planning and configuration plus automation of MySQL backup using mysqldump, mysqlpump, and shell AdminAPI and backup configuration for the InnoDB cluster.
• Configuration backup for MySQL binary log and log rotation.
• Installation and Administration of Mysql InnoDB CLuster on Production and Docker for testing.
• Configuration of MySQL Router for InnoDB cluster and providing HA solution using keeplived for MySQL router.
• MySQL NDB Cluster Installation, Administration.
• Percona XtraDB cluster implementation with Proxysql load balancer.
• MySQL Asynchronous/Semi-synchronous replication.
• Migration from Traditional replication to GTID-based replication.
• Trouble shooting MySQL replication error and performance issues.
ORACLE:
• Oracle Database Server 10g/11g/12c.
• Oracle RAC, Data guard.
• Oracle Golden Gate (Oracle to Oracle, Oracle to MySQL and MySQL to Oracle)
• Oracle Enterprise Manager Grid Control, Toad, SQL developer.
• Oracle OEM
• Oracle 11G MAA multiple active data guard setup primary RAC to secondary standby RAC and a single instance
• NODE deletion/addition to 11gr2 RAC.
• Online migration of 11g RAC storage ASM Disk groups To Another SAN/Disk (Fujitsu to Huawei)