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
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.
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 .