MySQL Replication: Walk-through of the new 5.1 and 6.0 features
Contents |
← Back to MySQL University main page
[edit] MySQL Replication: Walk-through of the new 5.1 and 6.0 features
- Date: May 28, 2009
- Presenter: Lars Thalmann
- Host: Paul DuBois
- Abstract: In this talk, the developers behind MySQL Replication walk through some of the new Replication features of MySQL 5.1 and MySQL 6.0, such as:
- Row-based Replication (5.1) is used for MySQL Cluster replication and also provides a safer way to replicate non-deterministic statements.
- Row-based support for mysqlbinlog client (5.1) is used to analyze the row-based binlog entries.
- Row-based point-in-time recovery (5.1) is used to restore a server to a particular time point regardless of binlogging format.
- Heartbeating (6.0) is used to manage that the master and slave connection is always up.
- Semi-synchronous Replication (6.0) is used to ensure that any update of the master is on the slave before transaction is acknowleged to the user.
- Replication Server Filtering (6.0) ensures that the user can more easily replicate in a circle.
- Relay log synchronization (6.0) ensures that the slave is restartable without clearing the relay log in case of crashes.
- Presentation: NewReplicationFeatures.pdf
- Session recording: (stream) (download).
- Chat transcript: (view).