MySQL Forge

Resources for the MySQL Community

Category: Software Preview

ReplicationFeatures/DelayedReplication

Contents 1 TIME-DELAYED REPLICATION (MySQL Replication Team Feature Preview) 1.1 Provides: 1.2 User interface: 1.3 Affects: 1.4 References: 1.5 Downloads: 1.6 Kudos:

[edit] TIME-DELAYED REPLICATION (MySQL Replication Team Feature Preview)

[edit] Provides:

• Execution of replication events on slave is to be N seconds behind master

[edit] User interface:

  CHANGE MASTER TO MASTER_DELAY= N

  N is a non-negative less than INTMAX number of seconds to wait 
  by the slave.

  A value outside of this range is rejected with an error.
  Controlling of a delayed setup is via Show Slave Status'
  Seconds_behind_master.

[edit] Affects:

• A new line in relay-log.info

[edit] References:

• Kay Röpke Blog
• Bug#28760 Simulating a replication lag
• WL#344: Time-delayed Replication

[edit] Downloads:

• Linux binary: http://downloads.mysql.com/forge/replication_features_preview/mysql-6.0.5-alpha-delayed_repl-linux-i686.tar.gz
• Source code: http://downloads.mysql.com/forge/replication_features_preview/mysql-6.0.5-alpha-delayed_repl.tar.gz

[edit] Kudos:

• Kay Röpke whose original patch is elaborated on for MySQL 6.0 by Sven, MySQL Replication Team