summaryrefslogtreecommitdiff
path: root/topics/systems/mariadb
diff options
context:
space:
mode:
authorPjotr Prins2024-02-20 12:42:18 +0100
committerPjotr Prins2024-02-20 12:42:18 +0100
commit3b2433b664bafc1d1db9c90ce5242fbed5c8b1ef (patch)
treecc775e9f31d93b2e9d3bdf01da25dba1313051a1 /topics/systems/mariadb
parentc893445bf946040f774f99544926757415eebb32 (diff)
downloadgn-gemtext-3b2433b664bafc1d1db9c90ce5242fbed5c8b1ef.tar.gz
Started on fallback
Diffstat (limited to 'topics/systems/mariadb')
-rw-r--r--topics/systems/mariadb/mariadb.gmi8
1 files changed, 4 insertions, 4 deletions
diff --git a/topics/systems/mariadb/mariadb.gmi b/topics/systems/mariadb/mariadb.gmi
index 4000482..ae0ab19 100644
--- a/topics/systems/mariadb/mariadb.gmi
+++ b/topics/systems/mariadb/mariadb.gmi
@@ -2,9 +2,9 @@
Here we capture some common actions
-To install Mariadb (as a container) see
+To install Mariadb (as a container) see below and
-=> setting-up-local-development-database.gmi
+=> topics/deploy/installation
# Tags
@@ -39,9 +39,9 @@ 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 to the latest production database using borg recovery
-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.
+The MariaDB instance 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 into MariaDB database directory. Here's how.
Backups are managed using Borg as the ibackup user. First, become the ibackup user.
```