I am currently running a 5 node XtraDB cluster in AWS US-EAST while spreading nodes across availability zones. One of the nodes is setup as a traditional master and it replicates to AWS US-WEST as part of or DR plan. This setup is working fine, however we would like to have this server be a full member of the cluster, rather than just a slave. Replication is running over an SSH tunnel connection EAST to WEST.
What would you recommend as the best practice for setting up a cluster node in a different region? Would you use SSL, or some other method? This node will not receive reads or writes unless we completely lost everything on the east coast. For it to function properly, I am assuming it will need gcomm:// configured so that it can talk to all nodes in the east, however doing this with SSH tunnels isn’t practical. Any advice would be greatly appreciated.