gn-uploader: Move uploader to Tux02: Close as fixed.

1 files changed, 48 insertions, 0 deletions

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
+
+## …