MariaDB Server is one of the most popular open-source relational databases. It’s made by the original developers of MySQL and guaranteed to stay open source.
Supported MariaDB Versions
Collaborator supports MariaDB versions 10.6.x, 10.11.x and 11.4.x
Note: MariaDB database is supported in Collaborator Team and Collaborator Enterprise. For a complete list of differences between Collaborator editions, please see the comparison page.
Required components
| • | MariaDB - database server. |
| • | MariaDB java client connector/J - database driver for Java platforms. Supported driver versions are 3.4.x - 3.5.x |
Optional components
| • | HEIDISQL - Is a powerful, free (gpl) software only available for Windows, that is part of the category Development software with subcategory Database and has been created by Heidisql. |
For downloads and documentation for all platforms, see the MariaDB database documentation web site.
Install and Configure Database
First, install the Database Server component. Once you have installed the server, the last screen will give you the option to Configure the MariaDB Server. If you select this, it will open a new wizard for configuration. Two parts in the configuration that are especially important: Port Number and Root Password. You will need to know both while getting your database setup and while configuring Collaborator to work with your database. For information on configuring your database server, go to the MariaDB Documentation
In MariaDB, InnoDB is the default and generally preferred storage engine for its transactional capabilities, row-level locking, and ACID compliance, while MyISAM is an older, non-transactional engine better suited for read-heavy, non-critical applications. Maria database tables, see https://phoenixnap.com/kb/myisam-vs-innodb.
Collaborator does not support the non-default values of the auto_increment_increment and auto_increment_offset MariaDB system variables.
For Collaborator, you have to create a separate database, since the MariaDB Server install will not create a database for you. This is a manual step that you need to do.
You can create a database using the MariaDB Command Line Client, or using HEIDISQL. The instructions given in this documentation use the functionality in the current GUI client, HEIDISQL.
The steps below for creating a database were written using HEIDISQL 12.8.0.6908 and are subject to change. As always, the most reliable source for database creation steps is MariaDB HeidiSQL Documentation
| 1. | Launch HEIDISQL. |
| 2. | Click on New to create a new session if you haven't configured one already. |
| 3. | Enter the Hostname / IP (e.g., localhost or 127.0.0.1). |
| 4. | Enter the Username (default: root). |
| 5. | Enter the Password (if set). |
| 6. | Choose the Port (default: 3306). |
| 7. | Click Open to connect. |
| 8. | In the left-side panel, right-click on the server name or an existing database. |
| 9. | Select Create new -->Database. |
| 10. | Enter a database name (e.g., mydatabase). |
| 11. | Choose the Collation (e.g., utf8mb4_general_ci for full UTF-8 support). |
| 12. | Click OK to create the database. |
We recommend that you create a user specifically for your Collaborator database rather than using the super-user, root.
All of these changes go into effect immediately. You do not have to restart the MariaDB server for changes to take effect.
Note:For installing collaborator with mariadb use mysql wizard. (Refer MySQL installation steps here installing)