Edit this page | Blame

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

(made with skribilo)