summaryrefslogtreecommitdiff
path: root/issues/gn-uploader/move-uploader-to-tux02.gmi
blob: 20c5b24e0e3941cd6bb8afd720791c891d58b241 (about) (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: 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

## …