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:
Also a question and answer session.
Patrick Galbraith is a principal engineer at HP in the Advanced Technology Group. He is the author or two books: “Developing Web Applications with Apache, MySQL, memcached, and Perl” (Wiley) “Expert PHP and MySQL” (Wiley) In his “spare time”, he also maintains DBD::mysql, DBD::drizzle, FederatedX storage engine and the Memcached Functions for MySQL as well as tinkering with various other OpenSource and OpenStack projects. Patrick lives up in the sticks of New Hampshire with his wife Ruth and son Kiran, daughter Sara, lots of trees and rocks, as well as his Kubota tractor.
View a complete list of MySQL contacts.