Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • N/A
    • None
    • None

    Description

      Mydumper needs to support MariaDB's SEQUENCEs for backup and restoration.

      Attachments

        Issue Links

          Activity

            Development is mostly done in https://github.com/linuxJedi/mydumper/tree/mariadb-sequences

            Current issue is with myloader, SEQUENCEs need to be restored before tables. This is not yet expressible in myloader which tries to restore everything in parallel. I have an idea on how to resolve this which I am passing by David Ducos.

            TheLinuxJedi Andrew Hutchings (Inactive) added a comment - Development is mostly done in https://github.com/linuxJedi/mydumper/tree/mariadb-sequences Current issue is with myloader, SEQUENCEs need to be restored before tables. This is not yet expressible in myloader which tries to restore everything in parallel. I have an idea on how to resolve this which I am passing by David Ducos.

            Second issue to contend with, a relative reference to a SEQUENCE in `nextval` turns into an absolute one including the schema name. This means that backup/restore into a different database breaks.

            Discussions ongoing on how to solve these two issues.

            TheLinuxJedi Andrew Hutchings (Inactive) added a comment - - edited Second issue to contend with, a relative reference to a SEQUENCE in `nextval` turns into an absolute one including the schema name. This means that backup/restore into a different database breaks. Discussions ongoing on how to solve these two issues.

            `nextval` issue is solved using a regex filter.

            David wants some retry code in there so tables that fail due to missing sequence are retried after the initial table threads have run.

            TheLinuxJedi Andrew Hutchings (Inactive) added a comment - `nextval` issue is solved using a regex filter. David wants some retry code in there so tables that fail due to missing sequence are retried after the initial table threads have run.

            Some more goundwork has been laid and merged in. The MariaDB detection in mydumper now works correctly and the table detection queries for MariaDB have been changed so that sequences and system version tables can be detected correctly.

            TheLinuxJedi Andrew Hutchings (Inactive) added a comment - Some more goundwork has been laid and merged in. The MariaDB detection in mydumper now works correctly and the table detection queries for MariaDB have been changed so that sequences and system version tables can be detected correctly.

            David has done the final parts of this, it is currently in review.

            TheLinuxJedi Andrew Hutchings (Inactive) added a comment - David has done the final parts of this, it is currently in review.

            This has been merged upstream.

            TheLinuxJedi Andrew Hutchings (Inactive) added a comment - This has been merged upstream.

            People

              TheLinuxJedi Andrew Hutchings (Inactive)
              TheLinuxJedi Andrew Hutchings (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 3h Original Estimate - 3h
                  3h
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 2.75d
                  2.75d