Install MariaDB Server 10.0

From ZoneMinder Wiki
Revision as of 15:08, 3 April 2016 by Bbunge (talk | contribs)
Jump to navigationJump to search

Install MariaDB Server 10.0 on Ubuntu 16.04.

This replaces MySQL 5.6. It will use the current configuration file (my.cnf) and current databases. MariaDB has some enhanced features which do not exist in MySQL and thus migration back to MySQL might not always work. 

apt-get install mariadb-server     (MySQL will be removed)

Note: The MySQL/MariaDB configuration file is located at: /etc/mysql/mysql.conf.d/mysqld.cnf To better manage the MariaDB server I recommend you move the config file and replace the default my.cnf symbolic link (this also works for MySQL 5.6). 

rm /etc/mysql/my.cnf  (this removes the current symbolic link)

cp /etc/mysql/mysql.conf.d/mysqld.cnf /etc/mysql/my.cnf

To change Mariadb settings: 

nano /etc/mysql/my.cnf

Ctrl+o Enter to save

CTRL+x to exit

A tool that you may want to install is mysqltuner. This is handy to see what database paramaters need to be adjusted as your ZM system builds up events. 

apt-get install mysqltuner

Once installed, run mysqltuner from a command prompt as root (sudo). Edit the configuration file and make the recommended changes. Stop zoneminder, restart the database server then start zoneminder.

Back to 16.04/1.29.0 setup: https://wiki.zoneminder.com/Ubuntu_Server_16.04_64-bit_with_Zoneminder_1.29.0_the_easy_way

Retrieved from "http://wiki.staging.zoneminder.com/index.php?title=Install_MariaDB_Server_10.0&oldid=7576"