MySQL RA OCF should use a timeout wrapper instead of sleep commands

[Bogdan Dobrelya]

This comes from original mail thread http://<email address hidden>/msg51625.html :

"If there is one cloned mysql instance not starting, the
whole pacemaker cluster gets stuck and does not emit any log. On the
host of the failed instance, I can see a mysql resource agent process
calling the sleep command. If I kill that process, the pacemaker comes
back alive and RabbitMQ master gets promoted. In fact this long timeout
is blocking every resource from state transition in pacemaker.

This maybe a known problem of pacemaker and there are some discussions
in Linux-HA mailing list [2]. It might not be fixed in the near future.
It seems in generally it's bad to have long timeout in state transition
actions (start/stop/promote/demote). There maybe another way to
implement MySQL-wss resource agent to use a short start timeout and
monitor the wss cluster state using monitor action."

[2] http://lists.linux-ha.org/pipermail/linux-ha/2014-March/047989.html

I believe the start/stop/promote/demote and other commands must be wrapped in timeout as well as we did for MQ RA OCF

Related bug: https://bugs.launchpad.net/fuel/+bug/1432603

[Bartłomiej Piotrowski (bpiotrowski)]

Moving to 8.0 due to SCF.

[Matthew Mosesohn (raytrac3r)]

This is a tech debt bug to refactor MySQL OCF script, not an actual defect

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/287733

[OpenStack Infra (hudson-openstack)]

Change abandoned by Fuel DevOps Robot (<email address hidden>) on branch: master
Review: https://review.openstack.org/287733
Reason: This review is > 4 weeks without comment, and failed Jenkins the last time it was checked. We are abandoning this for now. Feel free to reactivate the review by pressing the restore button and leaving a 'recheck' comment to get fresh test results.

[Bogdan Dobrelya (bogdando)]

The command proc_stop will take care of the orphans, if any left running after a start action has been expired by a Pacemaker lrmd