From 86bbf0615190e6c427ec38d00be81be7e64bb7f9 Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Wed, 3 Jul 2024 10:39:48 -0500
Subject: gn-uploader: Move uploader to Tux02: Close as fixed.

---
 issues/gn-uploader/move-uploader-to-tux02.gmi | 48 +++++++++++++++++++++++++++
 1 file changed, 48 insertions(+)
 create mode 100644 issues/gn-uploader/move-uploader-to-tux02.gmi

(limited to 'issues/gn-uploader/move-uploader-to-tux02.gmi')

diff --git a/issues/gn-uploader/move-uploader-to-tux02.gmi b/issues/gn-uploader/move-uploader-to-tux02.gmi
new file mode 100644
index 0000000..20c5b24
--- /dev/null
+++ b/issues/gn-uploader/move-uploader-to-tux02.gmi
@@ -0,0 +1,48 @@
+# Move Uploader to tux02
+
+## Tags
+
+* type: migration
+* assigned: fredm
+* priority: high
+* status: closed, completed, fixed
+* keywords: gn-uploader, guix, container, deploy
+
+## Databases
+
+### MariaDB
+
+To avoid corrupting the data on CI/CD, we need to run a separate database server.
+This implies separate configurations, and separate startup.
+
+Some of the things to do to enable this, then, are:
+
+* [x] Provide separate configs and run db server on separate port
+  - Configs put in /etc/mysql3307
+  - Selected port 3307
+  - datadir in /var/lib/mysql3307 -> /export5
+* [x] Provide separate data directory for the content
+  - extract backup
+* [x] Maybe suffix the files with the port number, e.g.
+  ```
+    datadir       = /var/lib/mysql3307
+    socket        = /var/run/mysqld/mysqld3307.sock
+    ︙
+  ```
+
+### SQLite
+
+- [ ] Provide separate path for the SQLite database file
+- [ ] Run migrations on SQLite database file
+- [ ] Create admin user
+- [ ] Make existing data public by default
+
+## Build Script
+
+- [x] Provide separate host directories that are writeable from the container(s)
+
+## Systemd
+
+- [x] Provide unit file for separate MariadDB running on different port
+
+## …
-- 
cgit v1.2.3