[debian-mysql] Bug#835596: Bug#835596: Bug#835596: [mariadb-10.0] Please ship support-files/mysqld_multi.server.sh

[Jan Wagner]

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 at .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 at 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 at mariadb:~# systemctl status mariadb at instance1
* mariadb at instance1.service - MariaDB database server
   Loaded: loaded (/lib/systemd/system/mariadb at .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 at mariadb:~# systemctl start mariadb at instance1
root at mariadb:~# systemctl start mariadb at instance2
root at 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 <waja at 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------
-------------- next part --------------
# 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
-------------- next part --------------
# 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 842 bytes
Desc: OpenPGP digital signature
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20170126/ccb59973/attachment.sig>