On Fri, 28 Feb 2020 09:03:44 +0100 Per Jessen
# tcpdump -n -i eth0 host 192.168.47.76
Is there anything in the mysql/galera setup that prevents it talking to forum.o.o ?
Yes: the firewall on the cluster nodes. Why? By intention ;-) Please do NOT use a single node out of a cluster. Just use the proxy in front of the cluster, which will automatically switch, if a node is unreachable/down. For historic reasons (the original databases where on another network), we currently also don't use the standard port... So please either use mysql.infra.opensuse.org port 3307 or (if you want to avoid DNS roundtrips), use 192.168.47.4:3307 Note: if your application supports read-only/load-balanced database access, you can help load-balancing by using 192.168.47.4:3308 in addition. Note: while Galera allows to have all nodes writing to the database (and replications happens between them), they still recommend to use mainly one galera node for writes and the other ones for read. This makes sure everything is consistent (not trapping in a replication error) while it allows load-balancing. That's why the firewall on the nodes only allow the (redundant) proxy server to talk to them. Just have a look at the graphic at: https://jeffatechsteps.blog/blog/linux-setting-up-a-mariadb-galera-cluster/ to get the idea. Regards, Lars -- To unsubscribe, e-mail: heroes+unsubscribe@opensuse.org To contact the owner, e-mail: heroes+owner@opensuse.org