Mysteries of the Binary Log
The purpose of the binary log is to record changes done to tables in the database. The binary log can then be used for replication, as well as for point-in-time recovery and in some limited cases also for auditing. If there are problems with replication, understanding the structure and how the server records changes to the binary log is necessary to resolve the problem.
There are many details about the binary log that have remained a mystery to most users. For example, what are the basic formats of the binary log and what are the pros and cons of each? If trouble arises, how can I find what went wrong in the binary log? How long should I keep a binary log? How does binary logging and backup work together? We answer all of these questions and more. Throughout the session, we will present the vital information you need to successfully employ the binary log. Some of the features discussed in this session include the following.
- The structure of the binary log
- Debugging using the binary log
- How to perform point-in-time recovery
- The role of the binary log in replication
- Examining the binary log with mysqlbinlog
- Using the binary log with backup
People planning to attend this session also want to see:
Chuck Bell
Oracle
Dr. Charles A. Bell conducts research in emerging technologies and agile development techniques. He works for Sun Microsystems as a senior software engineer on the backup and replication team. He is currently one of the principle developers of the backup system. His contributions to the backup system include the new logging mechanism, the default drivers, and numerous minor enhancements. Working exclusively on the Windows platform, he is also the resident Windows expert for the team.
Lars Thalmann
Oracle
Dr. Lars Thalmann is the technical lead of replication and backup technology at MySQL. He has designed many of the features, and is leading the development of replication, online backup, character sets and XML. Dr. Thalmann has worked with clustering technology for many years and is one of the developers of NDB Cluster, the storage engine used in MySQL Cluster.
Mats Kindahl
Oracle
Mats Kindahl is senior software engineer in the MySQL replication team. He is the main architect and implementor of MySQL’s row-based replication, but has also developed the unit testing framework used by MySQL.
In the time before starting at MySQL, he has worked with research in formal methods, automated program analysis, distributed systems, and as implementor of C/C++ compilers.
Comments on this page are now closed.
Sponsorship Opportunities
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com
Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus
Media Partner Opportunities
Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com
Press and Media
For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com
O'Reilly MySQL Conference Newsletter
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).
Contact Us
View a complete list of O'Reilly MySQL Conference contacts.
O'Reilly Home | Privacy Policy | Contact Us | Sitemap | conf-webmaster@oreilly.com
© 2010, O'Reilly Media, Inc. | (707) 827-7000 / (800) 998-9938
O’Reilly and the O'Reilly logo are trademarks of O'Reilly Media, Inc. All other trademarks are property of their respective owners.
Comments
@C the slides are up now, see above (or this) link
Great presentation. Can you please let me know when you post your slides?