[systemd-devel] mysqld about back to use mysqld_safe in Fedora

[Reindl Harald]

Am 28.06.2012 02:21, schrieb Tom Lane:
> Lennart Poettering <lennart at poettering.net> writes:
>> On Wed, 27.06.12 14:50, Honza Horak (hhorak at redhat.com) wrote:
>>> One of the issue is (in)ability to imitate the original behavior of
>>> mysqld_safe, which restarts the main process only if it crashes and
>>> the pid file isn't properly cleaned up.
> 
>> I am pretty sure "on-abort" is actually what you really want here, no?
>> The PID file checking sounds like a hack to achieve the same?
> 
> every production installation of mysql in the world
> runs underneath mysqld_safe, and has done for the last ten years or
> more

yes because maintainers like you are not proceeding
it took way too long after F15 GA untl your mysqld package was
useable in most environments beside LAMP because you irgnoed
systemd the whole development cycle and the following months

as example my self-maintained package is running
since F5 as native service without mysqld_safe
on many production machines where all sort of other
sevices are HEAVILY depending on mysqld without a single problem

sorry to say but your work on the mysql-package is not a reference
not the state it was released for F15 GA as also bulding updates
of outdated versions 2 weeks after the next is released

http://koji.fedoraproject.org/koji/buildinfo?buildID=324317
Version	5.5.24
Mon, 11 Jun 2012 22:38:11 UTC

Apr 13 22:02:14 Updated: mysql-server-5.5.23-4.fc16.20120413.rh.x86_64
May 08 12:58:37 Updated: mysql-server-5.5.24-2.fc16.20120508.rh.x86_64
May 31 11:50:48 Updated: mysql-server-5.5.25-2.fc16.20120531.rh.x86_64
_______________________

[root at srv-rhsoft:~]$ cat /usr/lib/systemd/system/mysqld.service
[Unit]
Description=MySQL Database
Before=postfix.service dovecot.service dbmail-imapd.service dbmail-lmtpd.service dbmail-pop3d.service
dbmail-postfix-policyd.service

[Service]
Type=simple
PIDFile=/var/run/mysqld/mysqld.pid
ExecStartPre=/usr/libexec/mysqld-prepare-db-dir
ExecStart=/usr/libexec/mysqld --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid
--socket=/var/lib/mysql/mysql.sock --open-files-limit=30000 --basedir=/usr --user=mysql
ExecStartPost=/usr/libexec/mysqld-wait-ready $MAINPID
ExecStop=/bin/kill -15 $MAINPID
Restart=always
RestartSec=1
TimeoutSec=300
LimitNOFILE=30000
LimitMEMLOCK=infinity
OOMScoreAdjust=-1000
SysVStartPriority=64

[Install]
WantedBy=multi-user.target

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 262 bytes
Desc: OpenPGP digital signature
URL: <http://lists.freedesktop.org/archives/systemd-devel/attachments/20120628/bc6b63ad/attachment.pgp>