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

Detect incompatible MySQL partition scheme and either convert them or report to user and in error log.

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Stalled (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: N/A
    • Component/s: Partitioning
    • Labels:
      None

      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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              monty Michael Widenius
              Reporter:
              juan.vera Juan
              Votes:
              0 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.