Skip to end of metadata
Go to start of metadata

Symptom


When restoring a large number (thousands) of databases using the MySQL Add-on, there is a pause in between each DB restore. As a result, the total restore time is very long, and the process may take days to complete.

Resolution


If the total number of databases to restore is in the thousands, use the "File Restore" function instead of the MySQL Add-On.
See:

Related Articles


Page: Adding a MySQL Instance to a Policy in Data Center Console (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: CDP for Databases (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Adding a MySQL Instance to a Policy (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Browsing MySQL Instance (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Allowing Remote Connections to MySQL Instance (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Editing MySQL Instance (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Enabling and Disabling MySQL Instance (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Testing MySQL Instance Connection (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Deleting MySQL Instance (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: MySQL Restore in Large Deployment (CDP) Labels: mysql
Page: MySQL InnoDB File Per Table Restore (CDP) Labels: mysql
Page: MySQL Test Connection Fails when the Instance is Started with skip-innodb (CDP) Labels: mysql
Page: Solved Issue with Publishing MySQL Password (CDP) Labels: mysql
Page: MySQL Instance with a Non-Default tmp Directory (CDP) Labels: mysql
Page: Adding a MySQL Instance to a Policy on a PVC Container (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Protecting MySQL (CDP) Labels: mysql
Page: Multi-Threaded MySQL Restore (CDP) Labels: mysql
Page: System Requirements - CDP for Databases (CDP) Labels: mysql, sql, exchange
Page: Protecting MySQL MariaDB and Percona Server (CDP) Labels: mysql
Labels:
mysql mysql Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.