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.
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.
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 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.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
For media-related inquiries, contact Maureen Jennings at email@example.com
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).
View a complete list of O'Reilly MySQL Conference contacts.