Difference between revisions of "Install MariaDB Server 10.0"
| Line 1: | Line 1: | ||
'''Install MariaDB Server 10.0 on Ubuntu 16.04.''' | '''Install MariaDB Server 10.0 on Ubuntu 16.04.''' | ||
09APR16 | |||
apt-get install mariadb-server | As of this writing, Ubuntu 16.04 has included MySQL 5.7. The easy replacement of MySQL with Mariadb does not work. Therefore you should start with a basic Ubuntu 16.04 server install with no LAMP. | ||
To manually install LAMP | |||
Become root | |||
sudo su | |||
Install Apache | |||
apt-get install apache2 | |||
Install Mariadb server | |||
apt-get install mariadb-server | |||
Install PHP | |||
apt-get install php libapache2-mod-php php7.0-mysql | |||
Secure Mariadb, create root password et. al. | |||
mysql_secure_installation | |||
'''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 | ||
| Line 26: | Line 48: | ||
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. | 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. | ||
Continue installing 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 | 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 | ||
Revision as of 15:20, 9 April 2016
Install MariaDB Server 10.0 on Ubuntu 16.04.
09APR16
As of this writing, Ubuntu 16.04 has included MySQL 5.7. The easy replacement of MySQL with Mariadb does not work. Therefore you should start with a basic Ubuntu 16.04 server install with no LAMP.
To manually install LAMP
Become root
sudo su
Install Apache
apt-get install apache2
Install Mariadb server
apt-get install mariadb-server
Install PHP
apt-get install php libapache2-mod-php php7.0-mysql
Secure Mariadb, create root password et. al.
mysql_secure_installation
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.
Continue installing 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
