W dniu 24.01.2023 o 13:03, Wietse Venema pisze:
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?
From the beginning of such a solution
machine1 machine2 machine3,4,5,6
[postfix]----------[-haproxy--galera]---sqlX
I'm thinking about it but it doesn't make sense:
1)postfix+haproxy local
In haproxy local (in this same machine where is postfix)
- server EXTERNAL 10.10.10.1:3306 check port 9200 inter 12000 rise 2 fall 2
- server local 127.0.0.1:3307 check backup
Wietse
Wietse
--
