Difference between revisions of "Install MariaDB Server 10.0"
(Created page with "Install MariaDB Server 10.0. This replaces MySQL 5.6. It will use the current configuration file (my.cnf) and current databases. MariaDB has some enhanced features which do no...") |
|||
| Line 4: | Line 4: | ||
'''Note:''' The MySQL/MariaDB configuration file is located at: /etc/mysql/mysql.conf.d/mysqld.cnf | '''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 | 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) | rm /etc/mysql/my.cnf (this removes the current symbolic link) | ||
| Line 13: | Line 13: | ||
nano /etc/mysql/my.cnf | 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. | |||
Revision as of 14:57, 3 April 2016
Install MariaDB Server 10.0. 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.
