mysql master replication internet
Posted on 2014-08-02
There are countless documents on the net on replication setups and while I can usually figure things out and learn as I go, this isn't one I want to take on without asking questions and perhaps even steps if possible.
The scenario is as follows;
In this case, I have an overall low volume mysql server with around 20 databases on it with one of those databases about to get pretty busy. Since overall it is low volume, replicating will work just fine for me. Internally, I've always used rsync to keep servers synchronized but in this case, I need replication because I need real time redundancy and, this will be over the internet.
I'll be replicating from a physical to a VPS. I can't think of any reasons why this could not be done between physical and VPS servers but if you know of any, please point it out.
If that is a problem, no big deal, I'll fire up another blade and do physical to physical.
So the question is;
1: Since this is going to be over the internet, I will need this to be secure, plus, should I be using an rsync method or should the mysql servers be communicating together in a standard firewall/firewall setup? Also, should I still use port 3306 between them or something else?
2: The mysql servers which I am using are both 5.5 versions and I have yet to find a decent (simple) Centos walk-through setup.
Please don't simply send me a lot of links, I've found plenty and am here to get answers, not more and more reading ;).