Try to connect to Galera mysql.

Comments

4 comments

  • Avatar
    Ashraf Sharif

    Hi George,

    What is the status of Galera cluster as reported by ClusterControl? If ACTIVE, try to check whether mysql is running on each of the DB node:

    $ ps -ef | grep mysql

    It seems like your application was trying to connect to local MySQL using socket, but it does not exist. Please do check that the socket file exists under /var/run/mysqld/ but you need to make sure mysql service is running fine beforehand:

    $ ls -la /var/run/mysqld/mysqld.sock

    Are you co-locating your application with the DB node? If not, make sure the application has been configured correctly to connect to the corresponding DB node.

     

    Regards,

    Ashraf

     

    0
    Comment actions Permalink
  • Avatar
    George Manthos

    Hi,

    I just find something else,

    I have installed phpmyadmin in all 3 nodes plus Garbd, when one node is down I can not login to phpmyadmin to other two nodes.

     

    Thanks

    George 

     

    0
    Comment actions Permalink
  • Avatar
    George Manthos

    Hi,

    I just find something else,

    I have installed phpmyadmin in all 3 nodes plus Garbd, when one node is down I can not login to phpmyadmin to other two nodes.

     

    Thanks

    George 

     

    0
    Comment actions Permalink
  • Avatar
    Ashraf Sharif

    Hi,

    Did you capture any error reported by phpmyadmin/mysql client during the single node down time? What is the status of your Galera cluster as reported by ClusterControl on that time? Have you GRANT correct user host for phpmyadmin?

    SSH to the database host and connect via mysql client:

    $ mysql -uroot -p<root password> -hlocalhost

    Then, run following query to verify you have setup GRANT correctly:

    show grants for <phpmyadmin user>@<phpmyadmin host IP>;

     

    Let us know the outcome.

    Regards,

    Ashraf

     

     

     

     

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk