MariaDB

See Advanced Topics.

Information from Open Dental HQ

On Wednesday, July 14th, Open Dental released a new trial installer package. The new trial installer package contains the MariaDB application in place of the MySQL application. There is no reason to worry. We will be slowly transitioning our users from using MySQL version 5.5 to having them use MariaDB version 10.5 and this is the first step: all new Open Dental users will use MariaDB. Many new customers will not realize that we are transitioning from MySQL to MariaDB, because for them, there is no transition.

We will have a new upgrade tool in a few weeks for customers that want to upgrade their MySQL version to MariaDB version 10.5, but it is not a requirement that customers upgrade from MySQL to MariaDB at this time. The Open Dental application will work with either MySQL or MariaDB, so you can anticipate that Open Dental will remain compatible with MySQL versions 5.5, 5.6, and 5.7 in addition to all versions of MariaDB.

The MariaDB application was created by the original developers of MySQL, so you can think of MariaDB as an extension of the MySQL application. When MySQL version 5.6 was under development, the company was bought out by Oracle, and Oracle took over the development of MySQL starting at version 5.6. The original MySQL developers had concerns at that time that Oracle might slowly try to kill MySQL since MySQL was in direct competition with Oracle. As a result, the original MySQL developers created a new company called MariaDB, and they took a copy of the MySQL source code for versions 5.5 and 5.6. The MariaDB company then continued developing the MySQL application (but under the new name MariaDB). The MariaDB company has a philosophy that is closely aligned with that of Open Dental, in that software should remain open source as much as possible, and it is unknown if Oracle will continue to allow MySQL to be completely open source into the future. MariaDB currently has the following versions: 5.5, 5.6, 10.0, 10.1, 10.2, 10.3, 10.4, 10.5, and 10.6. Open Dental will be using MariaDB version 10.5 for the time being since that version was released as stable about one year ago.

General Overview

The Open Dental database runs on MariaDB 10.5 which is a very robust and reliable database. See www.mariadb.com

The MariaDB was created by the founders of MySQL. MariaDB and MySQL are closely related, some windows in Open Dental will continue to use MySQL as the terminology.

How to Determine if MariaDB is Installed

MariaDB should be installed on the server. To ensure MariaDB is installed:

  1. On the server, go to Services. See if the MySQL service is listed. Right-click and select properties. The Path to Executable should include a MariaDB folder.
  2. On the server, go to Add or Remove programs. See if an existing installation of MariaDB is listed.

How to Determine if MySQL is Running

The MariaDB server will run as a service (named MySQL) on one computer. To easily determine if MySQL is running, open Services and look for MySQL.

How to Determine your current MariaDB Version

  1. On the server, open Services.
  2. Navigate to the MySQL service, then right-click to view properties.
  3. In the Path to Executable, find the path to mysqld.exe. (Typically, C:\Program Files\MariaDB 10.5\bin\mysqld.exe)
  4. Open that path, then right-click on mysqld.exe and select properties.
  5. In the details tab, note the version.

How to Start/Stop the MySQL Service from Windows CMD

There are two ways to Stop or Start the MySQL service:

In Services, find the MySQL and click Start or Stop.

or,

Run CMD as administrator.

To access the data in your MySQL database, use the table viewer in User Query.