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

Cross-engine partitioning

    XMLWordPrintable

Details

    Description

      Allow different engines in a partitioned table.
      What is mostly needed is allow one to combine InnoDB with S3 tables but other combinations should be possible . InnoDB couldb be a OVERFLOW partition that handles all inserts while the other partitions are only used for read.

      From optimizer point of view, we should be AND the flags from all engines
      that is part of a query. If S3 and InnoDB is in the same query, we would
      loose the clustered key cost optimization, however I think we can survive
      without that.

      To support multiple engines, we probably also need to do MDEV-5271

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-28863 Galera testing of Support multiple engines in partitioning

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-29415 status and variables history via system-versioned tables parttion

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Open
          includes

          Task - A task that needs to be done. MDEV-5271 Support engine-defined attributes per partition

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15471 Assertion `new_clustered == ctx->need_rebuild()' failed in ha_innobase::commit_inplace_alter_table

          • Major - Major loss of function.
          • Stalled

          New Feature - A new feature of the product, which has yet to be developed. MDEV-27180 Fully atomic partitioning DDL operations

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-12483 Foreign keys support for partitioned tables

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22088 S3 partitioning support

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-23798 Add GLOBAL indexes for partitioned tables

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-27545 migrate server attributes applicable to engines to the storage engine(s)

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27618 Atomic DDL is not very atomic on partitioned tables

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          mentioned in

          Page Loading...

          Activity

            People

              holyfoot Alexey Botchkov
              monty Michael Widenius
              Roel Van de Paar Roel Van de Paar
              Votes:
              4 Vote for this issue
              Watchers:
              19 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 25d Original Estimate - 25d
                  25d
                  Remaining:
                  Time Spent - 40d 28m Remaining Estimate - 125d
                  125d
                  Logged:
                  Time Spent - 40d 28m Remaining Estimate - 125d
                  40d 28m

                  Git Integration

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