Can you set up a Gelara Cluster across VPS where only port 22, 80 and 443 are open

[Grosen Friis]

Hi,

I have a production setup with 3 nodes, not hosted at the same provider but at 3 different VPS's in 3 different countries. Most of them only allow traffic through port 22, 80 and 443

I have tried to set up a Gelara Cluster anyway using autossh connections via port 22 combined with iptables.

Each node in the cluster can send nc commands through ports 3306, 4444, 4567 and 4568 via former mentioned autossh connections combined with iptables.

But despite much usage of traditional search engines and ChatGPT I have not succeded - yet.

I can start the Cluster on node 1, but when I start MariaDB on node 2 it cannot connect to node-1 due to timeouts/connection errors.

I was wondering if others have ever had success setting up a Gelara Cluster in a similar environment ? Or perhaps this is a setup that is not possible at all ?

Thx.

Grosen

[Sergio Charrua]

Hi!

how much data is on node 1 that the sync process needs to copy to node 2? I have found that if you have tens gigabytes of data to be synced, starting a new node will timeout, and in some cases I had to modify mariadb.service setting for a higher timeout value.

Atenciosamente / Kind Regards / Cordialement / Un saludo,

Sérgio 

--
You received this message because you are subscribed to the Google Groups "codership" group.
To unsubscribe from this group and stop receiving emails from it, send an email to codership-tea...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/codership-team/872e7db3-6c23-4066-b5d5-228f06da83d4n%40googlegroups.com.