Speedup the import of Mysql Dump to Gcloud SQL

MySQL & MariaDB Other MySQL® Questions
1

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
1 Like
2

Hi Hazon, take a look at mydumper and myloader to parallelize the export/import https://github.com/maxbube/mydumper

Hope that helps

1 Like
3

will try it , thanks so much

1 Like