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

Portable Tablespace

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.13
    • None

    Description

      Being able to flush, and transport tablespace in InnoDB (or XtraDB), would greatly decrease the downtime endured by creating/duplicating/rebuilding slave servers.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-515 innodb bulk insert

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

          Activity

            Ascending order - Click to sort in descending order
            mathnode Richard Bensley created issue -
            mathnode Richard Bensley added a comment - - edited

            initial requirements would probably include:

            [mysqld]
            		 
            innodb_file_per_table = ON
            		 
            innodb_file_format = Barracuda

            MySQL 5.6, extends the FLUSH command with the following syntax:

            FLUSH TABLES tbl_name [, tbl_name] ... FOR EXPORT

            As per:
            http://dev.mysql.com/doc/refman/5.6/en/flush.html

            MySQL 5.6 Transportable Tablespace:
            http://dev.mysql.com/doc/refman/5.6/en/tablespace-copying.html

            Exporting and Importing Tables (XtraDB):
            http://www.percona.com/doc/percona-xtrabackup/xtrabackup_bin/exporting_importing_tables.html

            mathnode Richard Bensley added a comment - - edited initial requirements would probably include: [mysqld] innodb_file_per_table = ON innodb_file_format = Barracuda MySQL 5.6, extends the FLUSH command with the following syntax: FLUSH TABLES tbl_name [, tbl_name] ... FOR EXPORT As per: http://dev.mysql.com/doc/refman/5.6/en/flush.html MySQL 5.6 Transportable Tablespace : http://dev.mysql.com/doc/refman/5.6/en/tablespace-copying.html Exporting and Importing Tables (XtraDB) : http://www.percona.com/doc/percona-xtrabackup/xtrabackup_bin/exporting_importing_tables.html
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            stephane@skysql.com VAROQUI Stephane added a comment - - edited

            Portable tablespace should be available to purge partitioned tables as this is mostly where it make sens to use it.
            Porting http://dev.mysql.com/doc/refman/5.6/en/partitioning-management-exchange.html would be nice

            stephane@skysql.com VAROQUI Stephane added a comment - - edited Portable tablespace should be available to purge partitioned tables as this is mostly where it make sens to use it. Porting http://dev.mysql.com/doc/refman/5.6/en/partitioning-management-exchange.html would be nice
            serg Sergei Golubchik made changes -
            Fix Version/s 10.1.0 [ 12200 ]
            serg Sergei Golubchik made changes -
            Priority Minor [ 4 ] Critical [ 2 ]
            serg Sergei Golubchik made changes -
            Assignee Jan Lindström [ jplindst ]
            serg Sergei Golubchik made changes -
            Labels innodb
            dbart Daniel Bartholomew made changes -
            Priority Critical [ 2 ] Major [ 3 ]
            dbart Daniel Bartholomew made changes -
            Fix Version/s 10.1.1 [ 16100 ]
            Fix Version/s 10.1.0 [ 12200 ]
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 26709 ] MariaDB v2 [ 46528 ]
            jplindst Jan Lindström (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            jplindst Jan Lindström (Inactive) added a comment -

            Tested with 10.0.x server and you can already export table from one server and import it to another.

            jplindst Jan Lindström (Inactive) added a comment - Tested with 10.0.x server and you can already export table from one server and import it to another.
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.0.13 [ 16300 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 46528 ] MariaDB v3 [ 67234 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 67234 ] MariaDB v4 [ 132086 ]

            People

              jplindst Jan Lindström (Inactive)
              mathnode Richard Bensley
              Votes:
              6 Vote for this issue
              Watchers:
              7 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.