Replication: Update Open Dental Version

To update Open Dental when using Replication, refer to the steps below.

Before updating, make sure required setup is complete.


When ready to update Open Dental for all locations, follow the steps below:

  1. From your Update Server, kick all users out of Open Dental. Go to Tools, Misc Tools, Shutdown All Workstations. This tool reminds users about the update and closes Open Dental on all workstations.
  2. Ensure all MySQL replication servers are running smoothly.
    1. From the File Explorer, navigate to the MySQL folder. The default location is

      C:\Program Files (x86)\MySQL\MySQL Server 5.5

    2. Locate the MySQL bin folder. (Typically C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin) Double-click into it.
    3. In the address bar, type CMD and hit enter to open CMD.
    4. Run the following command. Replace opendental with the name of the database if different.

      mysql -u root -c opendental

      Note: If the MySQL service has a password add -p to the command.
    5. Run the next command.

      show slave status \G


    6. You will get the following information:

  3. Repeat step two for each server.
    Note:
    • An Empty set is expected on the primary server in a two server one-way setup as only the reporting server will have a replica (slave) running
    • By running the show slave status command on each server it will determine if replication is up and running. Do not continue if any slave status says that the Slave IO or Slave SQL is not running.
  4. From the Update Server, open Open Dental and go to Help, Update. Install the updated version.
  5. Launch Open Dental to upgrade the database.
  6. In Open Dental go to Setup, Advanced Setup, Replication.
    • For Daisy Chain configurations, click Synch in the lower left. This stops and starts the Replicas and will ensure all replication servers receive the database update queries.
    • For One Way configurations, this is generally not necessary, though you could run the stop slave; and start slave; commands to be certain.
  7. Launch Open Dental on all servers in the replication chain and log into a user at least once, to ensure the Replication Service Monitor can monitor the health of the replication chain.
  8. Once complete, users can log back into Open Dental. They will be prompted to update to the new version. Select OK, then log in as normal.