Hi, I have got a big problem with my database system in working with balance
MySQL 1: 172.16.0.47 | Master 1 / Slave 2
MySQL 2: 172.16.0.49 | Master 2 / Slave 1
=>Master vs Master replicate
So, I need to balance request to 2 this servers, I installed ipvsadm on MySQL 1 and config on this
Code:
-A -t 172.16.0.48:3306 -s wlc
-a -t 172.16.0.48:3306 -r 172.16.0.47:3306 -g -w 1
-a -t 172.16.0.48:3306 -r 172.16.0.49:3306 -g -w 1
I create new NIC with IP 172.16.0.48 too. All firewall turned off.
But when telnet 172.16.0.48 3306, it does not work
How can I config to balance between requests like as: If have 2 request to
_1 will go to MySQL 1
_1 will go to MySQL 2
Thanks