Replication for Dummies

Patrick Galbraith (Blue Gecko)
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

Blue Gecko

Patrick Galbraith is a senior systems and database administrator at Blue Gecko. He is the author or two recent 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. He has just authored “Developing Web Applications using Perl, Memcached, MySQL, and Apache”. Patrick lives up in the sticks of New Hampshire with his wife Ruth and son Kiran 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.