From ad98dc0e3a87db7dceabe64f0d68164c996067ff Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Tue, 12 Mar 2024 06:19:49 +0300
Subject: New Issue: Track requirements to move uploader to tux02

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

(limited to 'issues')

diff --git a/issues/quality-control/move-uploader-to-tux02.gmi b/issues/quality-control/move-uploader-to-tux02.gmi
new file mode 100644
index 0000000..57000cb
--- /dev/null
+++ b/issues/quality-control/move-uploader-to-tux02.gmi
@@ -0,0 +1,44 @@
+# Move Uploader to tux02
+
+## Tags
+
+* type: migration
+* assigned: fredm
+* priority: high
+* status: open
+* 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:
+
+- [ ] Provide separate port to run the database: I propose 3307
+- [ ] Provide separate data directory for the content
+- [ ] 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
+
+- [ ] Provide unit file for separate MariadDB running on different port
+
+## …
-- 
cgit v1.2.3