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: [mariadb-10.0] Please ship support-files/mysqld_multi.server.sh

[Otto Kekäläinen]

Hello!

If this issue is still relevant, and you have a suggestion how to fix
it, please file a Merge Request on Salsa as a proposal. Thanks!

https://wiki.debian.org/Teams/MySQL/patches

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.

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

[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.

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

[Jan Wagner]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512

Package: mariadb-10.0
Severity: wishlist

Dear maintainer(s),

thanks for working hard on the MariaDB packages and doing such a great
job.

The source package contains a support-files/mysqld_multi.server.sh
which can be used as init-script for starting multiple database instance
s.
This file is patched by d/p/mysqld_multi.server_lsb-header.patch (via
#778762) but never made it into the package.
For MySQL the file is provided at /usr/share/mysql/mysqld_multi.server
by the mysql-server-5.5 package.

If this is the location you also would prefer, I can provide a patch
(or PR). Please let me know.

Many thanks, 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--
-BEGIN PGP SIGNATURE-

iQIcBAEBCgAGBQJXwYJGAAoJEAxwVXtaBlE+I+sP/iEtov4Sfqu7fYam7bUpgnhK
LA9L5OBEmaZcCz8eGFcC/W5ermBNspQRutHRyGdxmhPj3Q0J7pO/ZZ7ltzThHan2
At38NQp2tENT/b8CfF3oF8BPt9YAw8Z6g0Ro63VHN+2q43j5pfsOvRlXm0Ebk/E3
9/auwRJRfGDVuS3nbhFjtJfHe/1k7kggijz3S6QcCs1ThFk9B7EI3DvZzcgJo28f
Hqf2ZbahR48LdN/aSM365v7WngtyvfJlgQpssJOsviTreqp2TfSlCpU2MAWREdId
3JuFALVwIs9bDY+v9Sbj2hLsM7CBf3zVEReSUiQpBCMy2WaCDGKTERRfDgP2XaRT
u56P56TgQqrPG3rbf6gVLFKTUb/IS1dmi6BaeRHdkEs7uLHcwAUojCXmdTKsiIvd
LJeAl8Tkn0suqa7a6uRDwvFv/Gsb1kJhPql1C1ytd3PajfOE758VYJGVT4Gm2XPn
3YbntW89wnpwKLGwonxxHeTXzOYDbybio2+f6gqVRBOcGiFLl6xEPpUPceBsNHxj
zyjqtkJy8ub9mpOY2aTd6YBlXJwPWsx5OcVqn1BuYatyUFng3d+/ko/KVcjIv3kq
zWYGKHsunCmc4gMEdbNfolkVwZ5RS0TEzM8R4g+Ge9+8ix+eus8qzkn6PE4rnp18
jkZO5CK8Ccg4EPMthRdL
=WLQ1
-END PGP SIGNATURE-