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

S3 partitioning support

    XMLWordPrintable

Details

    Description

      Currently state:

      • One can create a partitioned S3 table with multiple partitions
      • One can add a new table to a partitioned table with "alter table archive exchange partition"

      One can't however add new partitions with ALTER TABLE ADD PARTITION

      This tasks it ensure that most partition commands that doesn't change data should work with the S3 engine.

      The current suggested implementation is focused to get all ALTER PARTITION commands to work, with the exception of:
      REBUILD PARTITION
      TRUNCATE PARTITION
      REORGANIZE PARTITION

      As part of this task, partitioned S3 tables are also properly replicated and can be discovered by remote servers that shares the same S3 instance.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-17841 S3 Storage engine

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-22162 Make partitions more flexible to use

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-22168 Supporting multiple engines with table partitioning

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

          Task - A task that needs to be done. MDEV-22642 Add partitions support for packed Aria Tables

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-19963 Add MERGE support for S3 (and Aria)

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

          Activity

            People

              monty Michael Widenius
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.