Advanced MySQL Administration Training in Bloomington

Enroll in or hire us to teach our Advanced MySQL Administration class in Bloomington, Illinois by calling us @303.377.6176. Like all HSG classes, Advanced MySQL Administration may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Advanced MySQL Administration may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.

Course Description

 
Covers advanced MySQL administration topics: replication, optimization and clustering.
Course Length: 1 Days
Course Tuition: $490 (US)

Prerequisites

Must have a basic understanding of MySQL Administration.

Course Outline

 

MySQL High Availability (HA)
Master/Slave and Master/Master Replication
    Set-up of a Master/Slave replication
    Row Based Replication (RBR)
    Semi-synchronous replication
    Virtual IP
    Read/Write distribution

Overview active/passive fail-over Cluster with DRBD
    The concept of an active/passive Clusters
    DRBD - Poor man's SAN
    Cluster glue (Pacemaker or Heartbeat)
    Attaching Slaves

Synchronous multi-Master Replication with Galera Cluster for MySQL
    Active/active Clustering
    Possible Load Balancer
    Scaling read and write access with Galera Cluster

Overview MySQL Cluster (NDB)
    Active/active Clustering
    Scaling rean- and write access with MySQL Cluster
    MySQL Cluster Replication

MySQL Performance Tuning
General information about Performance
    Performance, what does it mean?
    Performance Influences

System configuration
    Hardware
    Operating System
    MySQL configuration (my.cnf)

Application
    Schema Tuning
    Indexing
    SQL Query Tuning
    Tools: Slow Query Log, MySQL Profile, General Query Log, etc.
    Parallelizing

 

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.