summaryrefslogtreecommitdiff
path: root/issues/quality-control/move-uploader-to-tux02.gmi
blob: 4459433e5ce2a73026ba9686c3088f6b228ff24b (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
# 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

## …