MariaDB Database Per User, on Demand - AKA Systemd Multi-Instance Socket Activated

Explore a 28-minute conference talk from linux.conf.au that delves into creating on-demand, per-user MariaDB databases using systemd multi-instance socket activation. Learn how to achieve noisy neighbor isolation, security separation, per-user resource constraints, and zero resource consumption when idle, all without relying on cloud services or containers. Discover the small configuration changes and MariaDB server code modifications required to implement this solution. Gain insights into various usage scenarios and see how these configurations are slight variations of the default MariaDB packaging. If time permits, examine the code and understand how to apply similar techniques to other services. This presentation, licensed under CC BY-NC-SA 4.0, offers valuable knowledge for Linux enthusiasts and database administrators looking to optimize resource management and enhance security in multi-user environments.