[Openstack] Mirantis 7.0 Health Checks on MySQL, Galera failing

Raja T Nair rtnair at gmail.com
Fri Jul 14 08:10:53 UTC 2017


Hello John,

Thanks for the reply.
crm resource status clone_p_mysql says that mysql is running in all nodes.
Going through the link shared. Will get back for more help if in need.

Thanks again,
Raja.

On 13 July 2017 at 20:26, John Petrini <jpetrini at coredial.com> wrote:

> Hi Raja,
>
> From one of your controllers can you run the following?
>
> crm resource status clone_p_mysqld
>
> This should tell you if mysql is up and running on all nodes - some sample
> output of a healthy cluster:
>
> resource clone_p_mysqld is running on: node-3.coredial.local
> resource clone_p_mysqld is running on: node-5.coredial.local
> resource clone_p_mysqld is running on: node-8.coredial.local
>
> If it is running everywhere but you're still getting the failed health
> checks you may want to dig a bit deeper and check the health of the galera
> cluster. Here's some documentation on how to do so:
> http://galeracluster.com/documentation-webpages/monitoringthecluster.html
>
> If it's not running on all nodes you can attempt to start it by running
> crm resource start clone_p_mysqld
>
> ___
>
> John Petrini
> On Thu, Jul 13, 2017 at 4:12 AM, Raja T Nair <rtnair at gmail.com> wrote:
>
>> Hello All,
>>
>> My Fuel version is 7.0, with 3 controllers and 11 computes.
>>
>> This cluster has been running for a while now and recently, due to an
>> Internet connectivity issue, a time sync issue was noted.
>> Even after fixing this and time being in sync now(after a rolling reboot
>> of all controller nodes,) the health check is reporting mysql, galera
>> related issues as shown in the screenshots below.
>>
>> Can somebody please guide me on how to start debugging and fixing these
>> issues? Still a beginner with Openstack :)
>>
>> ps: We saw all compute nodes' nova-compute and one controller's
>> nova-conductor service going down after the NTP change.
>> Except for these services being restarted, no other action has been done
>> on the cluster.
>>
>>
>>
>>>>
>> Thanks in Advance,
>> Raja.
>>
>> --
>> :^)
>>
>> _______________________________________________
>> Mailing list: http://lists.openstack.org/cgi
>> -bin/mailman/listinfo/openstack
>> Post to     : openstack at lists.openstack.org
>> Unsubscribe : http://lists.openstack.org/cgi
>> -bin/mailman/listinfo/openstack
>>
>>
>


-- 
:^)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20170714/520b1c2d/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot from 2017-07-13 13-25-38.png
Type: image/png
Size: 59781 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20170714/520b1c2d/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot from 2017-07-13 13-25-55.png
Type: image/png
Size: 64050 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20170714/520b1c2d/attachment-0001.png>


More information about the Openstack mailing list