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

Innodb Binlog to be Stored in Archived Redo Log

    XMLWordPrintable

Details

    Description

      In the current MDEV-34705 binlog_storage_engine=innodb implementation, binary log events are written twice, once to the InnoDB write-ahead log and another time to the page-oriented binary log files. Moving the binary log to be stored in just the innodb_log_archive=ON (MDEV-37949) log would both help improve performance by removing a redundant write, as well as likely other benefits from the reduced complexity of having two separate logs.

      We should implement a setting and tools that will allow the binary log events to be stored only inside the innodb_log_archive=ON files using the InnoDB log record format that was introduced in MDEV-34705. In this mode, the page oriented binary log file format that was introduced in MDEV-34705 would continue to exist, but only in a virtual form, not written to any persistent files.

      Implementing this would also trivially solve MDEV-8813, because the upgraded tooling would necessarily have to be compatible with the current innodb_encrypt_log=ON format (MDEV-36024).

      Attachments

        Issue Links

          is blocked by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-37949 Implement innodb_log_archive

          • Critical - Crashes, loss of data, severe memory leak.
          • Approved
          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-39053 Implement an option for binlog inside innodb_log_archive

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-8813 Allow mysqlbinlog read encrypted binary logs

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-16589 default value for sync_binlog should be the safer value 1 instead of 0

          • Major - Major loss of function.
          • Stalled

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34705 Improving performance of binary logging by removing the need of syncing it

          • Major - Major loss of function.
          • Closed

          Activity

            People

              bnestere Brandon Nesterenko
              bnestere Brandon Nesterenko
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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