base
By:
base

HAProxy on galera cluster, server_id is always 0

January 19, 2017 212 views
MySQL Ubuntu 16.04

Hi,

I have just followed the following tutorial setting up a galera cluster. it seesmt obe working fine: https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mysql-5-6-on-ubuntu-16-04

I also followed this tutorial since I want a load balancer in front of it: https://www.digitalocean.com/community/tutorials/how-to-use-haproxy-to-set-up-mysql-load-balancing--3

now, when executing the following to check if it works I always get server_id 0 returned.

mysql -h 127.0.0.1 -u haproxy_root -p -e "show variables like 'server_id'"

my config looks like this

global
    log 127.0.0.1 local0 notice
    user haproxy
    group haproxy

defaults
    log global
    retries 2
    timeout connect 3000
    timeout server 5000
    timeout client 5000
listen mysql-cluster
    bind 127.0.0.1:3306
    mode tcp
    option mysql-check user haproxy_check
    balance roundrobin
    server galera-001 10.129.30.47:3306 check
    server galera-002 10.129.30.48:3306 check

When running this

mysql -h 127.0.0.1 -u haproxy_root -p -e "SHOW DATABASES"

it returns 3 tables:
+--------------------+
| Database |
+--------------------+
| informationschema |
| mysql |
| performance
schema |
+--------------------+

I don't know how to fix this. anybody here has an idea?

regards,
Ronnie

Be the first one to answer this question.