Upgrade mysql roles for new 10.5 multi-instance semantics

Debian bookworm has changed how mariadb-server does multi-instance, support seems better now that it was before, so we could try using the upstream systemd config again.