[MDEV-8341] Delayed replication implementation Created: 2015-06-19  Updated: 2016-10-31  Resolved: 2016-03-03

Status: Closed
Project: MariaDB Server
Component/s: Replication
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Guillaume Lefranc Assignee: Unassigned
Resolution: Duplicate Votes: 3
Labels: None

Issue Links:
Relates
relates to MDEV-7145 Port/merge the CHANGE MASTER TO ... M... Closed

 Description   

MySQL 5.6 implements delayed replication:
https://dev.mysql.com/doc/refman/5.6/en/replication-delayed.html

I am wondering if it's something easy to implement in MariaDB, and if it could work out with parallel replication.

 Comments   
Comment by Daniel Black [ 2016-02-29 ]

duplicate of MDEV-7145

Comment by Simon Mudd [ 2016-02-29 ]

Related: http://bugs.mysql.com/80402

Comment by Kristian Nielsen [ 2016-10-31 ]

> Related: http://bugs.mysql.com/80402

That bug is about supporting delays with fractional seconds.

The problem is that in the binlog format, we only know the event time on the
master with integral second precision. So while we could wait for fractional
seconds on the slave, it would be somewhat misleading since the actual delay
is rounded on the master already.

I do agree with the idea to warn about the rounding. However, I think this
is a deeper issue in MySQL/MariaDB. For example, it is also possible to
CHANGE MASTER TO master_port=3306.7. Or to insert a fractional value in an
integer column. In neither case is a warning given, according to my tests...

Generated at Thu Feb 08 07:26:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.