lando / mariadb

The Official MariaDB Lando Plugin
https://docs.lando.dev/mariadb
GNU General Public License v3.0
0 stars 6 forks source link

Fast backup #37

Open hkirsman opened 6 months ago

hkirsman commented 6 months ago

I'm working on this custom tooling that can do backup super quick. In sql size I have about 1.8 GB file and it takes about 4 minutes to import file with lando db-import.

With the new way, it takes 9.3 seconds... but it needs to restart database container and I don't know how. Only way to restart it atm is restarting Lando which make the total database restoration 9.3+21=30.3 seconds.

This is PR I'm working on https://github.com/wunderio/lando-drupal/pull/45 (It's PR in our custom Composer package do ship .lando.base.yml file together with some scripts. ) But as you can see from the PR, it's quite straight-forward setup.

  1. Is there way to restart db? In the PR I did try something but I don't know how to start it again?
  2. Could you implement this into Lando? This seems be be one big advantage of DDEV atm over Lando.