Not the answer you need?
Register and ask your own question!

Speedup the import of Mysql Dump to Gcloud SQL

HazonHazon Current User Role Novice

Hello,

Maybe you would be able to help with the following,

We would like to import a mysql dump file and it takes quite some time, the migration to SQL at Gcloud from an external Mysql involves a downtime that we are trying to minimise. 
I have optimised the dump file to have it imported faster.
I can see that the import process uses only one CPU core.
Can we multithread the import process some how?
Can we import twice to the same DB (one import before the actual move to SQL DB and an incremental dump file import during the migration to SQL DB)?
Can you offer technics to speedup the import process?
Can you offer DB configurations that might speedup the import process?

Thank you


Answers

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.