[MDEV-22088] S3 partitioning support Created: 2020-03-31  Updated: 2023-11-27  Resolved: 2020-04-20

Status: Closed
Project: MariaDB Server
Component/s: Partitioning, Storage Engine - S3
Affects Version/s: 10.5
Fix Version/s: 10.5.3

Type: Bug Priority: Major
Reporter: Michael Widenius Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-17841 S3 Storage engine Closed
relates to MDEV-22162 Make partitions more flexible to use Open
relates to MDEV-22168 Supporting multiple engines with tabl... Stalled
relates to MDEV-22642 Add partitions support for packed Ari... Open
relates to MDEV-19963 Add MERGE support for S3 (and Aria) Closed

 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.



 Comments   
Comment by Michael Widenius [ 2020-04-20 ]

Review discussions and requested changes.
More testing.
Pushed into 10.5

Generated at Thu Feb 08 09:12:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.