Effective MySQL
Replication Techniques in Depth
About the Authors
Ronald Bradford has worked in the relational database industry for over 20 years. His professional background began in 1989 with Ingres and Oracle RDBMS. His expertise includes a vast experience with database architecture, performance tuning, and management of large enterprise systems. Ronald has, for the past 13 years, worked primarily with MySQL, the worlds most popular open source database. His previous employment has included Oracle Corporation (19961999) as an Oracle Consultant and MySQL, Inc. (20062008) as a senior MySQL Consultant.
His contributions to the MySQL community have included recognition as the all-time top individual MySQL blog contributor at Planet MySQL (2010), an Oracle ACE Director (2010), and MySQL Community Member of the Year (2009).
Ronald combines his extensive consulting expertise with a passion to share the knowledge and benefits of using MySQL. He is the author of four books on MySQL, and his many public speaking engagements have included presentations at conferences in over 25 countries. The Effective MySQL series of books and presentations aim to provide practical education for DBAs, developers, and architects in MySQL performance, scalability, and business continuity.
Chris Schneider is a long-time open source advocate and MySQL evangelist, administrator, and architect. Over the past decade Chris has devoted his professional career to open source technologies, with his primary focus being MySQL at scale. His previous employment has included GoDaddy, Facebook, and Ning.com, along with his own MySQL consulting company.
He has designed, implemented, and maintained small to large MySQL installations while training and mentoring teams of DBAs. This includes building architecture from the ground up and improving on those that are currently in place while emphasizing scalability, performance, and ease of use.
Chris has also shared his experiences and knowledge through the many speaking engagements he does, such as Oracle Open World, MySQL Connect, Percona Live, and the former OReilly MySQL Conference. Chris is also the technical editor of the second book in the Effective MySQL series, Effective MySQL: Backup and Recovery.
About the Technical Editors
Nelson Calero has been working with Oracle technology since 1996, and with MySQL since 2005, specializing in architecture, administration, and performance for very large databases (VLDBs) and highly available (HA) environments. His previous experience included being a teacher and researcher in the Computer Science Institute (InCo) of the Engineering University (UdelaR) in Uruguay. Nelson now focuses on providing industry consulting to both the private and public sectors throughout Latin America, from Argentina to Mexico.
In the past few years, Nelson has become a frequent speaker at user community events in the Americas, including Oracle Open World Latin America and Collaborate. Currently he is an independent consultant, an Oracle University instructor, and president of the Oracle User Group of Uruguay (UYOUG).
Giuseppe Maxia works as QA Director with Continuent, Inc. He is an active member of the MySQL community and long-time open source enthusiast. During the past decades he has worked in various IT related fields, with focus on databases, object oriented programming, and system administration. He is fluent in Italian, English, Perl, Python, SQL, Lua, C, and Bash, and a good speaker of C, French, Spanish, and Java. He works in cyberspace with a virtual team and a blog (http://datacharmer.blogspot.com). Giuseppe has twice been the recipient of the MySQL Community Award (2006 and 2011) and recognized as an Oracle ACE Director (2012).
Sheeri K. Cabral has a masters degree in computer science specializing in databases from Brandeis University and a background in systems administration. Unstoppable as a volunteer and activist since age 14, Cabral founded and organizes the Boston, Massachusetts, MySQL User Group and is the creator and co-host of OurSQLCast: The MySQL Database Community Podcast, available on iTunes. She was the first MySQL Oracle ACE Director, and is the founder (and current treasurer) of Technocation, Inc., a not-for-profit organization providing resources and educational grants for IT professionals. She wrote the MySQL Administrators Bible (Wiley and Sons, 2009) and has been a technical editor for high-profile OReilly books such as High Performance MySQL, 2nd Edition (2012) and C. J. Dates SQL and Relational Theory (2009).
Hans Forbrich has been working with computers since the early 1970s, in particular with entity-relationship and relational databases, starting in 1979 using an engine on IBM mainframes called GERM (General Entity Relationship Model). Since that time, Hans has been a DBA, an operations architect for a number of organizations, and an Oracle University instructor but always heavily involved in high availability and recoverability.
As a fellow ACE Director, Hans is pleased and honored to have been a technical reviewer for this book. This topic is an important area of MySQL, and Ronalds expertise and experience in this area shine through.
Darren Cassar is a senior MySQL Database Administrator at Lithium Technologies. He holds a computer and communications engineering degree from the University of Malta and started his career doing systems administration in Malta, later moving on to database administration in Malta, London, New York, and San Francisco. Darren is the author of Securich, an open source security plugin for MySQL, a subject that he has presented at several conferences in both the United States and Europe.
Effective MySQL
Replication Techniques in Depth
Ronald Bradford
Chris Schneider
New York Chicago San Francisco
Lisbon London Madrid Mexico City
Milan New Delhi San Juan
Seoul Singapore Sydney Toronto
Effective MySQL: Replication Techniques in Depth
Copyright 2013 by The McGraw-Hill Companies. All rights reserved. Except as permitted under the United States Copyright Act of 1976, no part of this publication may be reproduced or distributed in any form or by any means, or stored in a database or retrieval system, without the prior written permission of the publisher.
ISBN: 978-0-07-179187-8
MHID: 0-07-179187-6
The material in this eBook also appears in the print version of this title: ISBN: 978-0-07-179186-1,
MHID: 0-07-179186-8.
McGraw-Hill eBooks are available at special quantity discounts to use as premiums and sales promotions, or for use in corporate training programs. To contact a representative please e-mail us at .
All trademarks are trademarks of their respective owners. Rather than put a trademark symbol after every occurrence of a trademarked name, we use names in an editorial fashion only, and to the benefit of the trademark owner, with no intention of infringement of the trademark. Where such designations appear in this book, they have been printed with initial caps.