When using the cloud, I do not have the option of a static LAN ip address to connect components. If /etc/hosts is used to do switching, I have no idea when mysql server would refresh the mapping and reverse mapping is generally messed up when multi-homed.
An alternative tactic would be a VPN/ipsec that could present static LAN ip addresses and then that subsystem could be the control point when actual LAN ip addresses change. The VPC part of AWS does this, but I'm working on another cloud.
Do you have any recommendations for a known good VPN setup for mysql that would stay up, reconnect as needed, etc.?
((Thank you for open sourcing your scripting for mysql replication, cluster, etc.))
Please sign in to leave a comment.