Fuel for OpenStack

mysql cluster down

Asked by Ahmad Ben Maallem

hi,
my cluster mysql is all down, i try restart it with the follawing command 'crm resource restart clone_p_mysql' and i tray also reboot my 3 controller node on the same time and i can't resolve the problem.
so i would like how to restart my galera cluster manually.
i use mirantis/fuel 6.0.
thanks.

Question information

Language:
English Edit question
Status:
Expired
For:
Fuel for OpenStack Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Fabrizio Soppelsa (fsoppelsa) said : 		#1

Greetings Ahmad,
you can try to stop the resource and then start it in debug mode, to see why Galera can't ressurect.

`pcs disable clone_p_mysql`
`pcs debug-start clone_p_mysql`

Also, did you notice something unusual in /var/log/mysql/error.log?

Best regards,
Fabrizio
Mirantis Fuel Team

Revision history for this message
Ahmad Ben Maallem (ahmad-benmaallem) said : 		#2

hi Fabrizio,

sorry for the delay of my feedback, commands 'pcs' did not solve my problem and now I'm trying to test some scenarios maitenances and I met some errors when adding another controller.
fuel log:
....
(/Stage[main]/Openstack::Controller/Openstack::Network::Create_network[net04_ext]/Neutron_subnet[net04_ext__subnet]/cidr) change from 192.168.0.0/21 to 192.168.6.0/21 failed: Property cidr does not support being updated
....

Revision history for this message
Fabrizio Soppelsa (fsoppelsa) said : 		#3

Hello Ahmad,
the provided command was intended to make some troubleshooting. I don't understand where's the problem, without further info. Can you attach the pacemaker logs?

Best regards,
Fabrizio
Mirantis Fuel Team

Revision history for this message
Launchpad Janitor (janitor) said : 		#4

This question was expired because it remained in the 'Needs information' state without activity for the last 15 days.