MariaDB installation and configuration—Linux
Installation
|
Ensure to install a supported database server and connector version. |
1.If an earlier unsupported version of MariaDB Server is already installed, stop the MariaDB service: systemctl stop mariadb
2. Visit the MariaDB download page.
3.In Choose a distribution, select your supported Linux distribution.
4.In Choose a MariaDB Server version, select the supported MariaDB Server version.
5.Optional: The download server is preselected in Mirror. You can select another download server.
6.Follow the on-screen steps to add the MariaDB repository and to install the MariaDB Server.
|
Your installation experience may vary according to the supported Linux distribution running on your server. |
7.If you have performed an upgrade, update system tables:
a.systemctl start mariadb
b.mariadb-upgrade -u root -p --force
c.systemctl restart mariadb
Follow the steps below to configure the MariaDB Server.
Configuration
1.Open the my.cnf configuration file in a text editor:
sudo nano /etc/my.cnf
2.Find the following configuration in the [mysqld] section of the my.cnf configuration file and modify the value:
|
If the [mysqld] section or the parameter is not present in the file, add it. |
Parameter |
Description |
|||
|---|---|---|---|---|
max_allowed_packet=33M |
|
|||
innodb_log_file_size=100M innodb_log_files_in_group=2 |
The multiplication of values of these two parameters must be at least 200. The minimum value for innodb_log_files_in_group is 2 and maximum value is 100; the value also must be integer. |
3.Press CTRL + X and type Y to save changes and close the file.
4.Restart the MariaDB server and apply the configuration:
sudo systemctl restart mysql
5.Verify that the MariaDB Server service is running:
sudo systemctl status mariadb
6.Install the MariaDB ODBC Connector.