Replication for Dummies

Replication is one of the most useful features of MySQL. With replication, one can architect an asynchronous, scaled-out, redundant, distributed, and efficient paradigm that provides data to Web or other applications, either within or even across data centers.

Come listen to Patrick Galbraith discuss various replication schemes, their advantages and detriments of each.

He will explain how to set up replication using his recent experience with a multimaster replication set-up he used to build a database architecture for Grazr.com that spans multiple data centers, and cover his experience over the past year about what he has learned about replication:

• Multimaster setup
• Slave setup
• Error recovery
• Monitoring
• Backups
• Hardware, OS requirements
• Apache/Web server needs
• Live demonstration on how to set up a local multimaster, for testing code in a simulated live setup

Also a question and answer session.