How To Set Up A Load-Balanced MySQL Cluster

ya right. check it and let me know that happen.

 

I will Checked tomorrow because i have to install new NIC card,
I try first with 3 sub interface in one NIC and i see the result!
Thank you my friend!
See you soon.

 

I configured with this settings,
But when i try to connect remote in virtual public IP, increasing the innactive connections in piranha but i can't connect to mysql server.
Maybe i must use iptables or something else?
pffffff

 

Hi Ridd1ck

I think your setup is almost done.

Can you do this check for me.

Run tcpdump -i eth0 'tcp port 3306'
on both node and then try to access mysql from your virtual public ip, and check if your is redirected to one of the node or not.

 

08:13:06.163134 IP 10.0.0.254.59234 > 10.0.0.166.mysql: Flags , seq 2296104459, win 14600, options [mss 1460,sackOK,TS val 71185552 ecr 0,nop,wscale 7], length 0
08:13:06.163158 IP 10.0.0.166.mysql > 10.0.0.254.59234: Flags [S.], seq 473718714, ack 2296104460, win 14480, options [mss 1460,sackOK,TS val 56414835 ecr 71185552,nop,wscale 7], length 0
08:13:06.163261 IP 10.0.0.254.59234 > 10.0.0.166.mysql: Flags [.], ack 1, win 115, options [nop,nop,TS val 71185552 ecr 56414835], length 0
08:13:06.163287 IP 10.0.0.254.59234 > 10.0.0.166.mysql: Flags [F.], seq 1, ack 1, win 115, options [nop,nop,TS val 71185552 ecr 56414835], length 0
08:13:06.163369 IP 10.0.0.166.mysql > 10.0.0.254.59234: Flags [.], ack 2, win 114, options [nop,nop,TS val 56414836 ecr 71185552], length 0
08:13:06.163564 IP 10.0.0.166.mysql > 10.0.0.254.59234: Flags [P.], seq 1:109, ack 2, win 114, options [nop,nop,TS val 56414836 ecr 71185552], length 108
08:13:06.163584 IP 10.0.0.166.mysql > 10.0.0.254.59234: Flags [F.], seq 109, ack 2, win 114, options [nop,nop,TS val 56414836 ecr 71185552], length 0
08:13:06.163870 IP 10.0.0.254.59234 > 10.0.0.166.mysql: Flags [R], seq 2296104461, win 0, length 0
08:13:06.163891 IP 10.0.0.254.59234 > 10.0.0.166.mysql: Flags [R], seq 2296104461, win 0, length 0
^C
75 packets captured
87 packets received by filter
11 packets dropped by kernel

 

This output is from node 2 ?

 

Yes Is from node2 eth0 interface,
So the packets reach the nodes with load balancer's virtual ip adress,
But the connection not established,
In the nodes, i need to configure the default gateway be the load balancer private virtual ip addres?
thank you my friend for feedback!
really thank you.

 

great, just let me know who it works..

 

My Friend! All Working Perfect!
The only one i had to do
is to change the default route on nodes machines to load balancer's private virtual ip address .