We are pleased to announce the release of Stash v2024.12.18 , packed with new features. You can check out the full changelog HERE . In this post, we’ll highlight the changes done in this release.
New Features
Introducing the multiDumpArgs Parameter for MySQL Backups
We are excited to introduce the multiDumpArgs parameter, which is available for all MySQL versions during the backup process.
The multiDumpArgs parameter can be specified under the spec.task.params section in the BackupConfiguration. It allows you to provide arguments for multiple dump commands, which will be executed sequentially.
Why Use multiDumpArgs?
The multiDumpArgs has been introduced for MySQL backup scenarios where you need to separate different types of data within a single dump file. For example, you can dump only database schemas without including table data, and in a separate operation, dump only the table data for specific databases. Using multiDumpArgs, these operations can be executed separately but stored in a single dump file, ensuring they are restored in the correct sequence.
You can specify dump arguments for mutiple mysqldump commands by separating each with $args using the multiDumpArgs parameter. Here is an example:
Format:
task:
params:
- name: multiDumpArgs
value: >-
$args= <arguments for the first dump command>
$args= <arguments for the second dump command>
$args= <arguments for the third dump command>
Example:
task:
params:
- name: args
value: --set-gtid-purged=OFF
- name: multiDumpArgs
value: >-
$args=--no-tablespaces --no-data --skip-triggers --skip-opt --single-transaction --create-options --disable-keys --extended-insert --set-charset --quick --databases playground
$args=--no-tablespaces --no-create-info --skip-triggers --skip-opt --single-transaction --create-options --disable-keys --extended-insert --set-charset --quick --ignore-table=playground.equipment --databases playground
$args=--no-tablespaces --no-data --no-create-info --skip-opt --single-transaction --create-options --disable-keys --extended-insert --set-charset --quick --databases playground
Templating for Exec Hook Command
We’ve added support for Go template in exec type as well. Previously it was only limited to httpPost hook. Here is an example of configuring template in exec hook:
apiVersion: stash.appscode.com/v1beta1
kind: BackupConfiguration
metadata:
name: mysql-backup
namespace: demo
spec:
hooks:
postBackup:
executionPolicy: Always
exec:
command:
- curl
- -X
- POST
- -H
- 'Content-type: application/json'
- -d
- '{"text":"ENV Backup status for {{ .Namespace }}/{{ .Target.Name }} Phase: {{ if eq .Status.Phase `Succeeded`}}Succeeded{{ else }}Failed. Reason: {{ .Status.Error }}{{ end}}."}'
- https://hooks.slack.com
containerName: mysql
schedule: "*/5 * * * *"
task:
name: mysql-backup-8.0.21
params:
- name: args
value: --set-gtid-purged=OFF --single-transaction --all-databases
repository:
name: gcs-repo
target:
ref:
apiVersion: appcatalog.appscode.com/v1alpha1
kind: AppBinding
name: mysql
retentionPolicy:
name: keep-last-5
keepLast: 5
prune: true
What Next?
Please try the latest release and give us your valuable feedback.
- If you want to install Stash in a clean cluster, please follow the installation instruction from HERE .
- If you want to upgrade Stash from a previous version, please follow the upgrade instruction from HERE .
Support
To speak with us, please leave a message on our website .
To receive product announcements, follow us on X .
If you have found a bug with Stash or want to request new features, please file an issue .