natan: > W dniu 24.01.2023 o?12:05, Wietse Venema pisze: > > natan: > >> Hi > >> For test i runnig gallera claster + haproxy > >> > >> haproxy: > >> ..... > >> listen galera-test > >> bind 10.10.10.10:3307 > >> balance leastconn > >> mode tcp > >> option tcplog > >> option tcpka > >> option httpchk > >> > >> server sql1 10.10.10.11:3306 check port 9200 inter 12000 rise 2 fall 2 > >> server sql2 10.10.10.12:3306 check port 9200 inter 12000 rise 2 fall 2 > >> server sql3 10.10.10.13:3306 check port 9200 inter 12000 rise 2 fall 2 > >> server sql4 10.10.10.14:3306 check port 9200 inter 12000 rise 2 fall 2 > >> > >> works fine (galera+haproxy+keepalive) > >> > >> but ... > >> I had a problem once like scenario: > > And that problem is now solved with the load balancer? > No > Old (exists) process cann connect to mysql - newer connections didn't > have this problem and in logs i get many: > warning: proxy:mysql:/etc/postfix/mysql_sender_login_maps.cf lookup > error for "u...@domain.lt"
You have proxy:mysql lookup errors AFTER ADDING a load balancer for the myaql server? Wietse Wietse