Managing MySQL Replication

About Me

MySQL at Yahoo!

Talk Goals

Outline

Required Knowledge

Quick Survey

Replication is

Replication is NOT

Why Replication?

Replication Basics

Replication Basics contd.

Replication in 3.23.xx

Replication in 4.0

Replication Setup

Snapshot Options

Snapshot Options Contd.

Snapshot Future

Replication Settings

Replication Settings

Replication Settings

Replication Commands

Replication Commands

Break!

Common Problems

Troubleshooting

Slave Status

Performance Problems

Tools

Monitoring

Monitoring

Topologies

Master/Slave Replication

Dual-Master Replication

Replication Ring

Relay

Load-Balancing Reads

Health Checks

Connection Algorithms

Dedicated vs. Shared

Good Practices

What’s MySQL Missing

More Missing Stuff

Even More Missing Stuff

For More Info…

Questions and Answers