maria-discuss team mailing list archive

[Tom Dangler <tom.dangler@xxxxxxxxxxxxxxxxxxx>]

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

-- 

Tom Dangler

IT Architect and Systems Manager

T  214.778.3158 |  M  214.493.0386  |  F  888.811.1566

 tom.dangler@xxxxxxxxxxxxxxxxxxx



Oakwood Software Insurance Solutions

6201 W Plano Parkway  |  Suite 225   |  Plano, TX 75093

Facebook <https://www.facebook.com/OakwoodSoftware>  |  LinkedIn
<https://www.linkedin.com/company/oakwoodsoftware>  |  Twitter
<https://twitter.com/TheRealOakwood>  |  oakwoodsoftware.com
<http://www.oakwoodsoftware.com/>



An Amwins Company