We have a web application hosted on a dedicated server at Datacenter A. I am in the process of setting up a disaster recovery protocol and am considering the following.
My current plan is to purchase another dedicated server (or vps) at Datacenter B. This server will host a slave copy of the database located at Datacenter A. This will be my first time configuring replication and am curious about the following:
- Will there be a performance drop for the server hosted in Datacenter A due to network latency during the replication with server in Datacenter B?
- Database on server in Datacenter A is currently only accessible to applications running on the server (or via ssh tunnel). In order to configure replication with server hosted in Datacenter B, will I need to open port 3306 or can the replication take place via ssh?