diff options
| author | Pjotr Prins | 2023-11-12 09:12:02 +0100 |
|---|---|---|
| committer | Pjotr Prins | 2023-11-12 09:12:02 +0100 |
| commit | fdc57d7e7373414305172728966b8485e0a7b45c (patch) | |
| tree | 97d07582b61aae5438ed18470b376cdf9d59c8cd /topics/systems/mariadb/mariadb.gmi | |
| parent | bb484f102b739898eae8d7a25f06d35fbc4d0ee5 (diff) | |
| download | gn-gemtext-fdc57d7e7373414305172728966b8485e0a7b45c.tar.gz | |
Running mariadb in a container with the large DB
Diffstat (limited to 'topics/systems/mariadb/mariadb.gmi')
| -rw-r--r-- | topics/systems/mariadb/mariadb.gmi | 12 |
1 files changed, 9 insertions, 3 deletions
diff --git a/topics/systems/mariadb/mariadb.gmi b/topics/systems/mariadb/mariadb.gmi index 56661b6..4000482 100644 --- a/topics/systems/mariadb/mariadb.gmi +++ b/topics/systems/mariadb/mariadb.gmi @@ -2,12 +2,16 @@ Here we capture some common actions -## Tags +To install Mariadb (as a container) see + +=> setting-up-local-development-database.gmi + +# Tags * type: info, documentation * keywords: mariadb, systems -## Check the transaction logs +# Check the transaction logs Start the client and: @@ -35,7 +39,7 @@ To get a log with some stuff filtered out try mysql -p -u webqtlout db_webqtl -e "SHOW BINLOG EVENTS IN 'gn0-binary-log.000014';" -r -s |grep -v -e "Access\|GTID\|INSERT_ID\|COMMIT\|Temp\|lastlogin\|LITERA\|flush\|ROLLBACK" ``` -## Update MariaDB on penguin2 to the latest production database +# Update MariaDB on penguin2 to the latest production database The MariaDB instance running on penguin2 needs to be periodically updated to the latest version of the database running on production. We do this by restoring backups of the production database stored on penguin2 into the penguin2 MariaDB database directory. Here's how. @@ -55,3 +59,5 @@ Stop the running mariadb-guix.service. Restore the latest backup archive and ove => https://www.borgbackup.org/ Borg => https://borgbackup.readthedocs.io/en/stable/ Borg documentation + +# |