Replication for Dummies

Patrick Galbraith (Hewlett Packard)
Replication and Scale-Out
Location: Ballroom D

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.

Photo of Patrick Galbraith

Patrick Galbraith

Hewlett Packard

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.

Sponsors
  • Kickfire
  • Zmanda, Inc.
  • Continuent
  • EDS
  • JasperSoft
  • Sun Microsystems
  • Symantec Anti-Virus Software
  • XAware
  • Data Direct Technologies
  • Dolphin Interconnect Solutions
  • Hewlett Packard
  • Infobright, Inc
  • Linagora
  • Microsoft
  • OpSource
  • Oracle
  • Pentaho
  • R1Soft
  • Red Hat
  • Ticketmaster
  • TechRepublic

Contact Us

View a complete list of MySQL contacts.