Replication Best Practices

When using Replication, allowing internet access to your database must not be done without following these best practices to help protect your network against intrusion, viruses, and malicious code attacks.

  1. Install an anti-virus software on all replication servers and all other devices on your network. The C:/Mysql/Data directory on replication servers should not be included in real time scans. It should be included separately in a periodic (daily) scheduled scan during non-operating hours because it will interfere with operations by locking the mysql tables.
  2. Do not open the MySQL port (default is port 3306) on your routers and do not allow incoming traffic for that port. You can open this port as a Firewall exception rule on your servers but NOT on your routers. In simple terms, this means do not open the database to the entire internet, even if you think you are verifying the source IP address: that is not sufficient as IP addresses can be spoofed.
  3. Use a VPN (Virtual Private Network). Data is encrypted across the internet over a VPN and thus verifies the identity client (machine or router) before decrypting. There is a very little risk in sharing data between computers on the same virtual network.
  4. Use strong passwords for VPN and all other network devices.
  5. Create a strong password for your MySQL user's root password.
  6. Replication servers should be dedicated to replication only. Uninstall or disable Internet browsers.
  7. When using replication with intermittent internet connections (e.g., mobile units) avoid making changes that result in deleted records. This includes merging patients, consolidating insurance plans, deleting insurance plans, deleting patients, deleting fee schedules, etc. These actions should be performed when all mobile units are connected to the replication server and from a single, non-mobile database. This reduces the chances of replication failure. Open Dental is a robust software that tries to elegantly handle as many of these situations as possible. If replication failure occurs, follow your replication failure procedures to restore your replication environment. Please inform Open Dental of your issues so that a permanent fix can be made to the program.
  8. You will need to keep your A to Z Folder synchronized. See Folder Replication
  9. Install the OpenDentalReplicationService on each Replica.