Restore Performance
Is it possible to restore a 32GB dmp file generated by mysqldump in less than 1 week? I generated a dmp with mysqldump, copied it to the salve machine to set up replication and it took over 1 week to complete the restore. This was using all of the performance tricks I could locate such as turning off foreign key and unique checks.
The database being restored is running on a linux (CENTOS) VM with 8GB memory and 4 3.3GHz processors available. The mariadb version is 5.5.52. There are no other processes running on this VM other than the database.
This seems like an unacceptably slow restoration process. I have restored larger databases (non-mariadb) within a few hours, it seems mariadb would also be able to accomplish this.
Answer
You don't give any details about your data, but take a look at How to Quickly Insert Data Into MariaDB.