Advanced MySQL Administration Training in Richmond Hill, Georgia

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