Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8341

Delayed replication implementation

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • N/A
    • Replication
    • None

    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.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-7145 Port/merge the CHANGE MASTER TO ... MASTER_DELAY option from MySQL 5.6

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Descending order - Click to sort in ascending order
            knielsen Kristian Nielsen added a comment -

            > 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...

            knielsen Kristian Nielsen added a comment - > 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...
            sjmudd Simon Mudd added a comment -

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

            sjmudd Simon Mudd added a comment - Related: http://bugs.mysql.com/80402
            danblack Daniel Black added a comment -

            duplicate of MDEV-7145

            danblack Daniel Black added a comment - duplicate of MDEV-7145

            People

              Unassigned Unassigned
              tanj Guillaume Lefranc
              Votes:
              3 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.