Hi everybody and please forgive my english.
I’ve got a 4 server cluster working on a local network environment, everything works like a charm.
Now I’d like to add a new cluster outter the office (WAN). I can only connect the wan cluster to one of the lan cluster (the port listener). So, how could i do that?
Could i add the wan server to the lan cluster adding only two gcomm urls? (wsrep_cluster_address = gcomm://{wan_ip_of_local_cluster},{wan_ip_of_external_server} (I don’t think quorum will deal with this)
Could i create a second my.cnf on local_lan_server configuring a second cluster with only those 2 nodes? (is there anyway to know if both of them are synched?)
Is there any other way?
I would really apreciate some light with this.
Thanks in advance