MySQL Replication course from zero to hero



Advertisements   
   

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

Read more course:  Machine Learning for Red Team Hackers

• NODE deletion/addition to 11gr2 RAC.

• Online migration of 11g RAC storage ASM Disk groups To Another SAN/Disk (Fujitsu to Huawei)

MySQL Replication course from zero to hero, Free Tutorials Download

Download MySQL Replication course from zero to hero Free Tutorials Direct Links

Go to Download Tutorials Page Go to HomePage Tutorials

Password : freetuts.download


Advertisements

Related Courses

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.