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

Portable Tablespace

        Details

        • Type: Task
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Fix Version/s: 10.0.13
        • Component/s: None
        • Labels:

          Description

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

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

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

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Open

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  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

                  Show
                  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
                  Hide
                  Permalink
                  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

                  Show
                  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
                  Hide
                  Permalink
                  jplindst Jan Lindström added a comment -

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

                  Show
                  jplindst Jan Lindström added a comment - Tested with 10.0.x server and you can already export table from one server and import it to another.

                    People

                    • Assignee:
                      jplindst Jan Lindström
                      Reporter:
                      mathnode Richard Bensley
                    • Votes:
                      6 Vote for this issue
                      Watchers:
                      7 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved:

                        Time Tracking

                        Estimated:
                        Original Estimate - 1 week
                        1w
                        Remaining:
                        Time Spent - 2 hours Remaining Estimate - 4 days, 6 hours
                        4d 6h
                        Logged:
                        Time Spent - 2 hours Remaining Estimate - 4 days, 6 hours
                        2h