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"
like postfix not close thats connections - this is probbaly when I use
proxy:mysql/etc/postfix/maps.... ?
Of course, if I restart postfix, the problem will not occur
maybe I must tunning some timeouts/cache on postfix ?
Wietse
--
