drupalwxt/helm-drupal

Backup script will capture the DB cache and will create huge backup files as a result

bernardmaltais opened this issue · 3 comments

Hello guys,

I am looking at a way to feed an ignore tables list to the backup job to prevent exporting useless tables like cache. At the moment I don't see a way to do this in the chart short of not enabling backup and creating my own cronjob outside the helm chart... but we are using the chart because everything needed is available in there... so it would defeat the purpose.

Is this something you had on the roadmap? How do you handle not backing caches in the DB for your own deployment?

I might propose an idea. How about adding an optional value to the backup section where we could capture extra drush -y sql-dump options? That way we could specify which tables to ignore with:

# Add option extra options to the drush -y sql-dump command
extra_options: --skip-tables-list=cache,cache_*

If you are interested I could submit a PR with the proposed changes to support the feature?

Bernard

sylus commented

Looks like we only added this in D7 so should add it to D9 as well :D

4f3ac6e

I see it in D7, you are right ;-) OK, no need for my PR then. I will let you add this simple fix ;-) Once it is added I will start using that instead of the ugly kubectl patch I had to implement ;-)

sylus commented

This should do it thanks so much :D

259ea8a