A mysql resource fails to start with "Failed - Timeout Error" when the configuration has an alternate user besides mysql specified in a RHEL 6 High Availability cluster

Solution Unverified - Updated -

Issue

  • How can I configure a different user than mysql with my clustered mysql resource?
  • When I start a mysql resource with an alternate user specified in the config, it fails to start:
Jan 16 13:18:45 rhel6-node1 rgmanager[29229]: [mysql] Checking Existence Of File /var/run/cluster/mysql/mysql:MySQL_Control.pid [mysql:MySQL_Control] > Failed
Jan 16 13:18:45 rhel6-node1 rgmanager[29251]: [mysql] Monitoring Service mysql:MySQL_Control > Service Is Not Running
Jan 16 13:18:45 rhel6-node1 rgmanager[29273]: [mysql] Starting Service mysql:MySQL_Control
Jan 16 13:19:15 rhel6-node1 rgmanager[29486]: [mysql] Starting Service mysql:MySQL_Control > Failed - Timeout Error

Environment

  • Red Hat Enterprise Linux (RHEL) 6 with the High Availability Add On
  • rgmanager
  • One or more mysql resources in /etc/cluster/cluster.conf
    • The config_file specified in that mysql resource has a user other than mysql specified

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.