Bug #81093 | mysqld_multi not included in mysql-community-server package | ||
---|---|---|---|
Submitted: | 15 Apr 2016 9:57 | Modified: | 5 May 2016 15:39 |
Reporter: | Georgi Iovchev | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Packaging | Severity: | S3 (Non-critical) |
Version: | 5.7.12 | OS: | CentOS (7) |
Assigned to: | CPU Architecture: | Any |
[15 Apr 2016 9:57]
Georgi Iovchev
[19 Apr 2016 16:09]
Valeriy Kravchuk
Looks like a real bug at least with el7 RPMs: [openxs@centos ~]$ rpm -qpl mysql-community-server-5.7.12-1.el7.x86_64.rpm | grep mysqld_multi warning: mysql-community-server-5.7.12-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY /usr/share/man/man1/mysqld_multi.1.gz [openxs@centos ~]$ The mysqld_multi file is NOT there :)
[20 Apr 2016 5:23]
MySQL Verification Team
Hello Georgi, Thank you for the report. Thanks, Umesh
[20 Apr 2016 5:24]
MySQL Verification Team
-- 5.7.12 [root@cluster-repo rpms]# [root@cluster-repo rpms]# ll total 519012 -rw-r--r-- 1 root root 224109360 Mar 29 13:10 mysql-community-server-5.7.12-1.el5.x86_64.rpm -rw-r--r-- 1 root root 149101172 Mar 29 13:10 mysql-community-server-5.7.12-1.el6.x86_64.rpm -rw-r--r-- 1 root root 158252992 Mar 29 13:10 mysql-community-server-5.7.12-1.el7.x86_64.rpm [root@cluster-repo rpms]# rpm -qpl mysql-community-server-5.7.12-1.el5.x86_64.rpm|grep mysqld_multi /usr/bin/mysqld_multi /usr/share/man/man1/mysqld_multi.1.gz [root@cluster-repo rpms]# [root@cluster-repo rpms]# rpm -qpl mysql-community-server-5.7.12-1.el6.x86_64.rpm|grep mysqld_multi /usr/bin/mysqld_multi /usr/share/man/man1/mysqld_multi.1.gz [root@cluster-repo rpms]# [root@cluster-repo rpms]# rpm -qpl mysql-community-server-5.7.12-1.el7.x86_64.rpm|grep mysqld_multi /usr/share/man/man1/mysqld_multi.1.gz [root@cluster-repo rpms]#
[20 Apr 2016 8:43]
Georgi Iovchev
I would suggest additionaly adding mysqld_safe also on systemd servers. It is not included in the el7 server package, but it would be good with combination with mysqld_multi
[21 Apr 2016 15:22]
Terje Røsten
Hi! Thanks for your report! There are several reasons mysqld_multi is removed from packages. It's a perl script and with rpmbuild automatic dep generator, server will get unwanted deps on perl packages. We also want to use native tools, that's why mysqld_safe is gone, We are using systemd as replacement. See: https://dev.mysql.com/doc/refman/5.7/en/server-management-using-systemd.html for help using MySQL under systemd. There are also less need for multi instance mysqld processes as lightweight containers makes it trivial to run several mysqld on the same hosts. For example MySQL in docker is available at: https://hub.docker.com/r/mysql/mysql-server/ Finally, systemd has native support for multi instances. We are looking at adding support for such services in future MySQL server releases.
[5 May 2016 15:39]
Paul DuBois
Posted by developer: Noted in 5.7.13 changelog. On platforms for which systemd support is installed, systemd has the capability of managing multiple MySQL instances. For details, see http://dev.mysql.com/doc/refman/5.7/en/server-management-using-systemd.html. Consequently, mysqld_multi and mysqld_multi.server are not installed because they are unnecessary.