GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Problem with HAproxy PXC

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem with HAproxy PXC

    So I have a question about haproxy and PXC.

    I have my cluster up and running with no issues. Now when I try to get haproxy to monitor the cluster I get the following error:

    HTTP/1.1 503 Service Unavailable
    Content-Type: text/plain
    Connection: close
    Content-Length: 44

    Percona XtraDB Cluster Node is not synced.
    Connection closed by foreign host.

    I see that haproxy is connecting to each of my nodes and mysqlchk is running but it keeps returning the above error.

    When I run clustercheck on the server I get this:

    HTTP/1.1 200 OK
    Content-Type: text/plain
    Connection: close
    Content-Length: 40

    Percona XtraDB Cluster Node is synced.

    I followed this http://www.percona.com/doc/percona-x...t_sandbox.html to setup my HAproxy.

    Any ideas as to whats going on?

  • #2
    Ok, found the issue. My install of PXC is not standard so I just needed to add the full path to mysql in the checkcluster script. Now HAproxy and PXC are working just fine.

    Comment

    Working...
    X