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