[MDEV-4299] Portable Tablespace Created: 2013-03-19  Updated: 2014-08-13  Resolved: 2014-08-13

Status: Closed
Project: MariaDB Server
Component/s: None
Fix Version/s: 10.0.13

Type: Task Priority: Major
Reporter: Richard Bensley Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 6
Labels: innodb

Issue Links:
Relates
relates to MDEV-515 innodb bulk insert Closed

 Description   

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

 Comments   
Comment by Richard Bensley [ 2013-03-19 ]

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

Comment by VAROQUI Stephane [ 2013-03-19 ]

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

Comment by Jan Lindström (Inactive) [ 2014-08-13 ]

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

Generated at Thu Feb 08 06:55:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.