[MDEV-29253] Detect incompatible MySQL partition scheme and either convert them or report to user and in error log. Created: 2021-01-06  Updated: 2023-09-28  Resolved: 2023-06-25

Status: Closed
Project: MariaDB Server
Component/s: Partitioning
Fix Version/s: 10.6.15, 10.9.8, 10.10.6, 10.11.5, 11.0.3, 11.1.2, 11.2.1

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

Issue Links:
Blocks
blocks MDEV-32277 Migration from MySQL 5.7 to MariaDB 1... Open
Duplicate
duplicates MDEV-23106 Unable to recognize/import partitione... Closed
PartOf
is part of MDEV-28906 MySQL 8.0 desired compatibility Open

 Description   

Despite advertising itself as "plugin replacement for MySQL" MariaDB uses a different partitioning scheme. In addition, it is unable to detect the incompatible partition scheme when started on a MySQL-generated physical database, and produces column mismatch errors, failures in mysql_upgrade, and InnoDB data dictionary inconsistencies.

It would be very helpful for administrators if they could see a message when these errors happen letting them know that InnoDB has encountered an incompatible and unsupported partition scheme, and recommend starting over with the corrupted tabled dumped logically and then dropped from the source.

We should consider extending mariadb-upgrade to automatically convert MySQL 5.7 InnoDB partitioned tables to MariaDB partitioned tables.

Things to check;

  • Is each InnoDB partition is it's own table space ?
  • Is it possible to convert the partitions to MariaDB type independent InnoDB partition tables
  • Can we create MariaDB .frm and .par files from MySQL .frm file or InnoDB
    dictionary / InnoDB internal partition information.


 Comments   
Comment by Michael Widenius [ 2022-08-05 ]

We need to look at supporting partitioned InnoDB tables from MySQL 5.7

Comment by Michael Widenius [ 2023-06-01 ]

Will be solve as part MDEV-23106

Comment by Michael Widenius [ 2023-06-25 ]

Fixed as part of MDEV-23106. MariaDB upgrade can now handle MySQL partitions!

Pushed to 10.6 tree

Generated at Thu Feb 08 10:07:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.