Lars Vogdt wrote:

On Fri, 28 Feb 2020 09:03:44 +0100 Per Jessen <per@opensuse.org> wrote:

...

# 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 ;-)

Fair enough :-) I couldn't see anything in the firewall, I must be going blind.

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.

Okay, I thought it might be done via DNS - I see 'galera.infra' is cname'd to 'galera1', with a low ttl.

So please either use mysql.infra.opensuse.org port 3307 or (if you want to avoid DNS roundtrips), use 192.168.47.4:3307

mysql.infra.opensuse.org is good for me. When granting access, I need to grant to both anna and elsa?

Just have a look at the graphic at: https://jeffatechsteps.blog/blog/linux-setting-up-a-mariadb-galera-cluster/ to get the idea.

Thanks Lars :-) -- Per Jessen, Zürich (6.4°C) Member, openSUSE Heroes -- To unsubscribe, e-mail: heroes+unsubscribe@opensuse.org To contact the owner, e-mail: heroes+owner@opensuse.org