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