See Advanced Topics.
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.11 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.
Existing Open Dental users may upgrade from MySQL to MariaDB if they choose, but it is not a requirement. See Upgrading from MySQL to MariaDB 10.5.11 below for details.
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.
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.
Existing Open Dental users can run the following tool to upgrade from MySQL to MariaDB 10.5.11: ODDbmsUpgradeTool
MariaDB should be installed on the server. To ensure MariaDB is installed:
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.
There are two ways to Stop or Start the MySQL service:
In Services, find the MySQL and click Start or Stop.
Run CMD as administrator.
To access the data in your MySQL database, use the table viewer in User Query.