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

[Jan Wagner]

Hi,

Am 22.11.20 um 17:22 schrieb Otto Kekäläinen:
> And if you find out there are no code changes needed, maybe submit an
> addition to the README's so the next users have an easier time
> figuring out how to properly run multi-instnances?

sorry, I'm not using this szenario anymore. So I don't have any system
to test.

Sorry, Jan.

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

[Otto Kekäläinen]

Control: tags -1 moreinfo

Hello!

You've both reported about multi-mysqld issues:
- https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=835596
- https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=974910

Could you please research this issue to the root and submit a patch to
https://salsa.debian.org/mariadb-team/mariadb-10.5 when you have
figured out how multi-instances should run?

And if you find out there are no code changes needed, maybe submit an
addition to the README's so the next users have an easier time
figuring out how to properly run multi-instnances?

Thanks!

- Otto


- Otto

Bug#835596: [debian-mysql] 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@.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
tcp0  0 0.0.0.0:33060.0.0.0:*
LISTEN  2117/mysqld
tcp0  0 0.0.0.0:33070.0.0.0:*
LISTEN  2268/mysqld

Cheers, Jan.
-- 
Never write mail to , 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

Bug#835596: [debian-mysql] 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:
> Could you review it? And help test is works as expected?

I'll try, but relatively short on time actually. Is there a deadline you
need to match there?

> Test binaries available via repo
>   # Debian unstable
>   deb http://labs.seravo.fi/~otto/mariadb-repo/ mariadb-10.1-sid-amd64/

I need to spin a unstable system anywhere for testing.

Cheers, Jan.
-- 
Never write mail to , 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--



signature.asc
Description: OpenPGP digital signature

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

[Otto Kekäläinen]

Hello Jan!

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?

Test binaries available via repo
  # Debian unstable
  deb http://labs.seravo.fi/~otto/mariadb-repo/ mariadb-10.1-sid-amd64/

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

[Otto Kekäläinen]

Are you still interested in making a patch to finalize this?

2016-10-01 19:40 GMT+03:00 Otto Kekäläinen :
> Hello!
>
> Sorry for not replying to this earlier. You description seems accurate
> and idea good. It would be great if you can provide a patch or a PR
> and I'lll merge it quickly.