The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Restore Performance

Is it possible to restore a 32GB dmp file generated by mysqldump in less than 1 week? I am trying to estable a master/slave replicaiton schem with mariadb version 5.5.22. I generated a dmp with mysqldump (noting the log file and log position) and copied it to the slave machine. On the slave restored this file, but the restore took over 1 week to complete. This was using all of the performance tricks I could locate such as turning off foreign key and unique checks and adjusting various buffers.

The slave 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 hours, it seems mariadb would also be able to do this.

Answer

You don't give any details about your data, but take a look at How to Quickly Insert Data Into MariaDB.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.