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 +++++++++++++++++++++++ issues/quality-control/move-uploader-to-tux02.gmi | 48 ----------------------- 2 files changed, 48 insertions(+), 48 deletions(-) create mode 100644 issues/gn-uploader/move-uploader-to-tux02.gmi delete mode 100644 issues/quality-control/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 + +## … diff --git a/issues/quality-control/move-uploader-to-tux02.gmi b/issues/quality-control/move-uploader-to-tux02.gmi deleted file mode 100644 index 4459433..0000000 --- a/issues/quality-control/move-uploader-to-tux02.gmi +++ /dev/null @@ -1,48 +0,0 @@ -# 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: - -- [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