Multiple instances of MySQL/mariadb on a single box (OpenRC)

[jannis]

Hi, my Gentoo server lately suffered some crashes of mariadb under load (spikes in number of queries/sec just before the crash). That instance is used for multiple services (mailbox management and mapping for Postfix/Courier, several web services (nextcloud, wordpress, ...), ...).
To find the application causing MySQL to crash, I would like to set up several instances of the database server and separate the services until there's only one service left using the MySQL server crashing.

There are some hints in the Gentoo docs, init scripts (OpenRC) and configuration files but I couldn't find a definitive guide on how to run several, separated instances of MySQLd/mariadb on one machine?

Can anyone please point me to the correct docs or briefly describe the steps neccessary? Thanks!

[Blind_Sniper]

https://dev.mysql.com/doc/refman/5.7/en/multiple-unix-servers.html