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:
None 
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
Description:
mysqld_multi script is not included in mysql-community-server rpm

Tested on centos 7.2 x64, using mysql community repo

How to repeat:
just install mysql-community-server and try to run mysqld_multi
[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.