Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mariadb docs update #2080

Merged
merged 9 commits into from
Nov 25, 2021
Merged

mariadb docs update #2080

Changes from 1 commit
Commits
Show all changes
9 commits
Select commit Hold shift + click to select a range
897646e
mariadb: using --port
grooverdan Nov 16, 2021
b452643
mariadb: added support for .sql.zst in /docker-entrypoint-initdb.d
grooverdan Nov 16, 2021
5ce6c3a
mariadb: add Mariabackup (and restore) mechanism
grooverdan Nov 16, 2021
e83b692
mariadb: add password reset documentation
grooverdan Nov 16, 2021
f5b264a
mariadb: installing plugins
grooverdan Nov 16, 2021
885e1ea
Update mariadb/content.md
grooverdan Nov 18, 2021
eaf4def
Update mariadb/content.md
grooverdan Nov 25, 2021
e801e40
Update mariadb/content.md
grooverdan Nov 25, 2021
b78c943
Update mariadb/content.md
grooverdan Nov 25, 2021
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
mariadb: add Mariabackup (and restore) mechanism 
gosu mysql -> --user mysql suggestion thanks @yosifkit

Closes: #MariaDB/mariadb-docker/issues/390
  • Loading branch information
@grooverdan
grooverdan committed Nov 19, 2021
commit 5ce6c3ac13f5767e20daf1d9fe653ab17d4ef0b3
50 changes: 50 additions & 0 deletions mariadb/content.md
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -190,3 +190,53 @@ For restoring data. You can use the `docker exec` command with the `-i` flag, si
```console
$ docker exec -i some-%%REPO%% sh -c 'exec mysql -uroot -p"$MARIADB_ROOT_PASSWORD"' < /some/path/on/your/host/all-databases.sql
```

## Creating backups with Mariabackup

To perform a backup using Mariabackup, an additional volume for the backup needs to be included when the container is started like this:

```console
$ docker run --name some-%%REPO%% -v /my/own/datadir:/var/lib/mysql -v /my/own/backupdir:/backup -e MARIADB_ROOT_PASSWORD=my-secret-pw -d %%IMAGE%%:latest
```

Mariabackup will run as the `mysql` user in the container, so the permissions on `/backup` will need to ensure that it can be written to by this user:

```console
$ docker exec some-%%REPO%% chown mysql: /backup
```

To perform the backup:

```console
$ docker exec --user mysql some-%%REPO%% mariabackup --backup --target-dir=/backup --user=root --password=my-secret-pw
```

If you wish to take a copy of the `/backup` you can do so without stopping the container or getting an inconsistent backup.

```console
$ docker exec --user mysql some-%%REPO%% tar -cf - /backup | xz > backup.tar.xz
grooverdan marked this conversation as resolved.
Show resolved Hide resolved
```

## Restore backups with Mariabackup

These steps restore the backup made with Mariabackup.

At some point before doing the restore, the backup needs to be prepared. Here `/my/own/backupdir` contains a previous backup. Perform the prepare like this:

```console
$ docker run --user mysql --rm -v /my/own/backupdir:/backup %%IMAGE%%:latest mariabackup --prepare --target-dir=/backup
```

Now that the image is prepared, start the container with both the data and the backup volumes and restore the backup:

```console
$ docker run --user mysql --rm -v /my/own/newdatadir:/var/lib/mysql -v /my/own/backupdir:/backup %%IMAGE%%:latest mariabackup --copy-back --target-dir=/backup
```

With `/my/own/newdatadir` containing the restored backup, start normally as this is an initialized data directory:

```console
$ docker run --name some-%%REPO%% -v /my/own/newdatadir:/var/lib/mysql -d %%IMAGE%%:latest
```

For further information on Mariabackup, see the [Mariabackup Knowledge Base](https://mariadb.com/kb/en/mariabackup-overview/).