mysqlpump-mysql5.7 official table level concurrency logical Backup tool

Mysqlpump, official Parallel logical backup tool

mysqlpump features include:

• Parallel processing of databases, and of objects within databases, to speed up the dump process

• Better control over which databases and database objects (tables, stored programs, user accounts) to dump

• Dumping of user accounts as Account-management statements ( CREATE USER , GRANT ) rather than as inserts into the mysql system data Base

• Capability of creating compressed output

• Progress indicator (the values are estimates)

• For dump file reloading, faster secondary index creation for InnoDB tables by adding indexes after rows is inserted

Mysqlpump is added in MySQL 5.7.8. It uses recent MySQL features and thus assumes use with a server at least as recent as mysqlpump itself.

MysqlpumpRequires at least theSELECTPrivilege for dumped tables,SHOW VIEWFor dumped views,TRIGGERFor dumped triggers, andLOCK TABLESIf the--single-transactionoption is not used. TheSELECTPrivilege on themysqlSystem database is required to dump user definitions. Certain options might require other privileges as noted in the option descriptions.

This article from "Ops said: from rookie to veteran" blog, please be sure to keep this source http://liuqunying.blog.51cto.com/3984207/1835732

mysqlpump-mysql5.7 official table level concurrency logical Backup tool