[debian-mysql] mysqld.service

[Norvald H. Ryeng]

On Wed, 05 Mar 2014 22:56:21 +0100, <merc1984 at f-m.fm> wrote:

>
> On Tue, Mar 4, 2014, at 23:33, Norvald H. Ryeng wrote:
>> On Tue, 04 Mar 2014 22:26:44 +0100, <merc1984 at f-m.fm> wrote:
>>
>> > I'm not a member of the list so please reply offline.
>> >
>> > Does anyone have a mysqld.service that actually works in Debian?  No
>> > such thing in Debian as mysql-prepare-db-dir or mysql_safe.
>> >
>> > If so, please forward.
>>
>> This file is used in the packages we (Oracle) deliver in our own Fedora
>> repo:
>> http://bazaar.launchpad.net/~mysql/mysql-server/5.7/view/head:/packaging/rpm-fedora/mysqld.service.
>> I don't think it will work in Debian right out of the box, but it's a
>> good
>> starting point. You may have to tweak the mysql-systemd-start script a
>> bit
>> since Debian packages run mysql_install_db in postinstall, while the
>> Fedora packages do it the first time the service is started.
>>
>> IIUC, in MySQL 5.5 and 5.6 you'll have to use mysqld_safe with systemd,
>> but in 5.7 you can start mysqld directly. I haven't looked into it
>> myself,
>> but I think it's because of the server's choice of exit codes.
>>
>> Since both Debian and Ubuntu have now chosen systemd, I guess it's only  
>> a
>> matter of time before our service file will have to work on those too.
>>
>> Regards,
>>
>> Norvald H. Ryeng
>
>
> Thanks, but there is no such thing in Debian as mysql-systemd-start or
> mysqld_safe in Debian Testing.  And I don't have the ability to research
> and deeply analyze what these do, much less ascertain more subtle
> differences that might occur.  And we are still on MySQL 5.5.

We use the same mysqld.service file for 5.5 and 5.7.

mysql-systemd-start can be found here:  
http://bazaar.launchpad.net/~mysql/mysql-server/5.5/view/head:/packaging/rpm-oel/mysql-systemd-start.  
This file is also the same for 5.5 and 5.7.

mysqld_safe is in package mysql-server-5.5 in testing.

Regards,

Norvald H. Ryeng