Hi Otto, Am 23.01.17 um 14:46 schrieb Otto Kekäläinen: > I've implemented systemd in Debian in > https://anonscm.debian.org/git/pkg-mysql/mariadb-10.1.git/commit/?id=9ff0a57dcbce86031d654dd85edd5bfe8c795dfa > based on the scripts shipped by upstream. > > It also contains a mariadb@.service intended for the multi mysqld use case. > Read more at: https://mariadb.com/kb/en/mariadb/systemd/ > > > Could you review it? And help test is works as expected?
the first thing I ran into was to use the wrong file location. root@mariadb:~# ls -la /etc/mysql/mariadb.conf.d/myinstance1.cnf -rw-r--r-- 1 root root 564 Jan 26 14:13 /etc/mysql/mariadb.conf.d/myinstance1.cnf root@mariadb:~# systemctl status mariadb@instance1 * mariadb@instance1.service - MariaDB database server Loaded: loaded (/lib/systemd/system/mariadb@.service; enabled; vendor preset: enabled) Active: inactive (dead) Condition: start condition failed at Thu 2017-01-26 14:27:44 UTC; 2min 2s ago `- ConditionPathExists=/etc/mysql/conf.d/myinstance1.cnf was not met This wasn't obvious in the first place. After placing myinstance1.cnf and myinstance2.cnf into /etc/mysql/conf.d/ it seems to work fine so far. root@mariadb:~# systemctl start mariadb@instance1 root@mariadb:~# systemctl start mariadb@instance2 root@mariadb:~# netstat -tapn| grep mysql tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 2117/mysqld tcp 0 0 0.0.0.0:3307 0.0.0.0:* LISTEN 2268/mysqld Cheers, Jan. -- Never write mail to <w...@spamfalle.info>, you have been warned! -----BEGIN GEEK CODE BLOCK----- Version: 3.12 GIT d-- s+: a C+++ UL++++ P+ L+++ E--- W+++ N+++ o++ K++ w--- O M+ V- PS PE Y++ PGP++ t-- 5 X R tv- b+ DI D+ G++ e++ h---- r+++ y++++ ------END GEEK CODE BLOCK------
# this is read by the standalone daemon and embedded servers [server] [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld_instance1.pid socket = /var/run/mysqld/mysqld_instance1.sock port = 3306 basedir = /usr datadir = /var/lib/mysql/instance1 tmpdir = /tmp log_error = /var/log/mysql/mysql_instance1-error.log skip-external-locking bind-address = 0.0.0.0
# this is read by the standalone daemon and embedded servers [server] [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld_instance2.pid socket = /var/run/mysqld/mysqld_instance2.sock port = 3307 basedir = /usr datadir = /var/lib/mysql/instance2 tmpdir = /tmp log_error = /var/log/mysql/mysql_instance2-error.log skip-external-locking bind-address = 0.0.0.0
signature.asc
Description: OpenPGP digital signature