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

            Descending order - Click to sort in ascending order
            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.
            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
            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

            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.