MariaDB Database per user, on demand (aka systemd multi-instance socket activated)
summary
Demonstrates a reproducible setup that runs one MariaDB server per Linux user using systemd templates and a few MariaDB code tweaks so instances are socket-activated per-user instances. Conflicting settings move to per-home my.cnf created from a template, TCP port derives from the Unix UID plus 3000 as UID+3000 port mapping, root auth uses Unix socket ownership, ProtectHome is relaxed, and optional max_idle_execution auto-shutdown (10.8 branch) lets sockets start servers on demand and shut them down after idle.
AI-written summary · about
chapters (4)
related talks
21mMariaDB PaaS using systemd multi-instance / socket activation
19mCreating Vagrant development machines for MariaDB
25mHow to shard MariaDB like a Pro
17mMariaDB Buildbot, the journey of a reinvention
34mOf Quadlets and Other Daemonless
20mMigrating MariaDB Cluster to ARM
37mDelivery and Debugging MariaDB Docker Official Images
24mMariaDB post-release quality assurance in Debian and Ubuntu