Failed Galera resource - unable to increase max_open_files in mysql

Solution Verified - Updated -

Issue

  • Galera bundle fails on a single node, and promote action fails with 'MySQL server failed to start' error.
# pcs status
Cluster name: openstack_cluster
Stack: stack

...
Full list of resources:
...

 Docker container set: galera-bundle [ - ]
   galera-bundle-0      (ocf::heartbeat:galera):        Master core-0
   galera-bundle-1      (ocf::heartbeat:galera):        FAILED Master core-1 (blocked)
   galera-bundle-2      (ocf::heartbeat:galera):        Master core-2

...
Failed Actions:
...

* galera_promote_0 on galera-bundle-1 'unknown error' (1): call=43, status=complete, exitreason='MySQL server failed to start (pid=664) (rc=0), please check your installation',

...

Daemon Status:
  corosync: active/enabled
  pacemaker: active/enabled
  pcsd: active/enabled

Environment

  • RedHat OpenStack Platform 13 (RHOSP13)
  • RedHat OpenStack Platform 16 (RHOSP16)

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content