We're working on upgrading a mariadb-10.1 server to mariadb-10.6. We run multiple instances of Mariadb on this server, and some run different versions of Mariadb for different reasons. When we attempted to upgrade to mariadb-10.2, we noticed that we can no longer specify mysqld=/path/to/mysqld without generating an error and not starting the instance. We get [ERROR] /opt/mariadb10_2/bin/mysqld: unknown variable 'mysqld=/opt/mariadb10_2/bin/mysqld'. We tested this with 10.2 and 10.6 binaries. When using 10.1 binaries for the [mysqld_multi] group, it accepts the mysqld= argument just fine, and starts each instance with the version defined in mysql= in each option group. The documentation still shows that mysqld= is still a valid configuration, but it does not seem to work from 10.2 to current. Is there a different configuration for this now? We would like to continue using mysqld_multi with different versions of Mariadb.
Using 10.1 binaries for mysqld_multi it works
[mysqld_multi]
mysqld = /opt/mariadb10_1/bin/mysqld_safe
mysqladmin = /opt/mariadb10_1/bin/mysqladmin
user = multi_admin
password = ourpassword
Using 10.2 - 10.6 binaries for mysqld_multi we get errors about unknown variable mysqld
[mysqld_multi]
mysqld = /opt/mariadb10_6/bin/mysqld_safe
mysqladmin = /opt/mariadb10_6/bin/mysqladmin
user = multi_admin
password = ourpassword
[mysqld1]
mysqld = /opt/mariadb10_1/bin/mysqld
datadir = /opt/mysql_data/mariadb10_1
port = 3306
socket = /var/run/mysqld/mariadb_10_1.sock
pid-file = /var/run/mysqld/mariadb_10_1.pid
user = mysql
[mysqld2]
mysqld = /opt/mariadb10_2/bin/mysqld
datadir = /opt/mysql_data/mariadb10_2
port = 3307
socket = /var/run/mysqld/mariadb_10_2.sock
pid-file = /var/run/mysqld/mariadb_10_2.pid
user = mysql
[mysqld6]
mysqld = /opt/mariadb10_6/bin/mysqld
datadir = /opt/mysql_data/mariadb10_6
port = 3308
socket = /var/run/mysqld/mariadb_10_6.sock
pid-file = /var/run/mysqld/mariadb_10_6.pid
user = mysql
--