Galera Cluster + LVS fail

[Alexander Varejão]

Hi guys, 

I'm trying of using Galera Cluster with five nodes under LVS load balancer, but when I trie list my nodes with "ipvsadm -L" only one of this has a Weight identified

Something like that

ipvsadm -L

TCP  [XXXXXX]:mysql wlc

  -> [server1]:mysql Route   10000   0          0         

  -> [server2]:mysql Route   0           0          0         

  -> [server3]:mysql Route   0           0          0         

  -> [server4]:mysql Route   0           0          0         

  -> [server5]:mysql Route   0           0          0         

My ldirectord.cf

[...]

virtual6=[XXXX]:3306

    real6=server1:3306 gate 10000

    real6=server2:3306 gate 10000

    real6=server3:3306 gate 10000

    real6=server4:3306 gate 10000

    real6=server5:3306 gate 10000

    scheduler=wlc

    protocol=tcp

    service=mysql

    checktype=external-perl

    checkcommand="/usr/local/sbin/check_mysql_auth.pl"

my check_mysql_auth.pl just is testing connection with 3306 port

How could I solve it ?

Thanks

[Colin Charles]

are you using ipv6?

wlc is the default for lvs (weighted least connection); have you tried lc / rr to see if it makes a difference? you need a deeper config than just the below

> --
> You received this message because you are subscribed to the Google Groups "codership" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to codership-tea...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/codership-team/79ccdbdb-cbdb-42d2-acc6-3ffe81a300e2o%40googlegroups.com.

--
Colin Charles, http://bytebot.net/blog/
twitter: @bytebot | skype: colincharles
"First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

[frater.a...@gmail.com]

Dear

thanks for answering

I use IPv6 and IPv4 connections.
On my config I have

IPv4:

## Galera Cluster :: NAME_HERE:mysql
virtual=[IPv4 HERE]:3306
    real=server1:3306 gate 30652
    real=server2:3306 gate 25600
    real=server3:3306 gate 30650
    real=server4:3306 gate 25599
    real=server5:3306 gate 30650
    scheduler=wlc
    protocol=tcp
    service=mysql
    checktype=negotiate
    login="XXX"
    passwd="XXX"
    database="XXX"
    request="XXX"

My IPv6:

## Galera Cluster :: IPv6 :: NAME_HERE:mysql
virtual6=[IPv6 HERE]:3306
    real6=server1:3306 gate 30652
    real6=server2:3306 gate 25600
    real6=server3:3306 gate 30650
    real6=server4:3306 gate 25599
    real6=server5:3306 gate 30650
    scheduler=wlc
    protocol=tcp
    service=mysql
    checktype=external-perl
    checkcommand="xxxxl"

[Alexander Varejão]

Sorry this problem has been solved. I have a new problem now "Got an error reading communication packets"

I sent an email for the list but I dont had no help yet

You received this message because you are subscribed to a topic in the Google Groups "codership" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/codership-team/4uBaauNK4k0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to codership-tea...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/codership-team/bfad7aed-cbc2-4f11-8e73-970c6207a6fen%40googlegroups.com.