Managing MySQL Replication

Speaker Info (Who am I?)

MySQL at Yahoo!

Outline

Goals

Required Knowledge

Quick Survey

Replication Basics

Replication Basics contd.

Why Replicate

Replication in 3.23.xx

Replication in 4.0.x

Replication Setup

Replication Settings

Replication Settings

Replication Settings

Replication Commands

Replication Commands

Common Problems

Tools

Monitoring

Topologies

Master/Slave Replication

Dual-Master Replication

Replication Ring

Load-Balancing

Future Ideas

For More Info…

Shameless Book Plug

Questions and Answers