MariaDB PaaS using systemd multi-instance / socket activation

on YouTube ↗21m

" summary

Demonstrates running independent MariaDB instances on bare metal using systemd multi-instance and socket activation, merged into MariaDB 10.4 with ongoing work for 10.6. Uses Fedora 32, per-user data dirs and my.cnf templates, UID_MIN mapped to port numbers so uid 10003 becomes port 10003, and unix-socket authentication so each Linux user is DB superuser. Adds type=notify cooperation, SendSigKill=no safety, Restart=always, and cgroup limits. Demo launches four instances (Tom/Mary/Fran/one more) and socket activation starts services on first connection, and it works.

AI-written summary · about

" chapters (7)

1. 0:00Start
2. 1:59MariaDB on Shared Hosting?
3. 5:20MariaDB's systemd story
4. 8:22Current Systemd Implementation
5. 17:32MariaDB Socket Activation (serverless)
6. 18:06Systemd against Cloud Requirements
7. 20:31Questions

" related talks

• 28mMariaDB Database per user, on demand (aka systemd multi-instance socket activated)Daniel Black · linux.conf.au 2022
• 34mOf Quadlets and Other DaemonlessAlejandro Acosta · KCD Guadalajara 2025
• 51mMariaDB Scaling - From Single Instance to Multiple ClustersMichal Kuchta · Percona Live 2022
• 38mRunning MySQL & MariaDB Server securely in 2019Colin Charles · OSDC 2019
• 17mState of MariaDBMichael Widenius · Percona Live 2022
• 21mSwitching from MySQL/Percona to MariaDBPramod Mahto · MariaDB OpenWorks 2023
• 50mMySQL/MariaDB Parallel Replication: inventory, use cases and limitationsJean-François Gagné · Percona Live Open Source Database Conference 2017
• 53mMariaDB Server 10.2: The Complete GuideColin Charles · Percona Live Open Source Database Conference 2017