|
|
| (4 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| '''Install MariaDB Server 10.0 on Ubuntu 16.04.''' | | '''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.
| | See this: https://wiki.zoneminder.com/Ubuntu_Server_16.04_64-bit_with_Zoneminder_1.30.0_the_easy_way#Optional_Upgrade_to_MariaDB_Server_10.0._before_installing_Zoneminder |
| | |
| 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
| |
Latest revision as of 14:24, 1 October 2016
