Install MariaDB Server 10.0 - Revision history

Bbunge at 19:24, 1 October 2016

2016-10-01T19:24:15Z

← Older revision		Revision as of 15:24, 1 October 2016
Line 1:		Line 1:
	'''Install MariaDB Server 10.0 on Ubuntu 16.04.'''		'''Install MariaDB Server 10.0 on Ubuntu 16.04.'''

	~~21APR16 This has not been tested with teh final release of Ubuntu 16.04~~		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

	~~As of~~ this ~~writing, Ubuntu 16.04 has included MySQL 5.7. The easy replacement of MySQL with Mariadb does work.~~

	~~However you can manually install LAMP with Mariadb.~~

	~~To manually install LAMP start with a Ubuntu 16.04 Basic Server install.~~

	~~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/mariadb.conf.d/50-server.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~~
	https://wiki.zoneminder.com/Ubuntu_Server_16.04_64-bit_with_Zoneminder_1.29.0_the_easy_way#~~Install_Zoneminder~~

Bbunge at 19:48, 21 April 2016

2016-04-21T19:48:06Z

← Older revision		Revision as of 15:48, 21 April 2016
Line 1:		Line 1:
	'''Install MariaDB Server 10.0 on Ubuntu 16.04.'''		'''Install MariaDB Server 10.0 on Ubuntu 16.04.'''

	~~09APR16~~		21APR16 This has not been tested with teh final release of Ubuntu 16.04

	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~~.		As of this writing, Ubuntu 16.04 has included MySQL 5.7. The easy replacement of MySQL with Mariadb does work.

	To manually install LAMP		However you can manually install LAMP with Mariadb.

			To manually install LAMP start with a Ubuntu 16.04 Basic Server install.

	Become root		Become root

Bbunge at 20:15, 9 April 2016

2016-04-09T20:15:38Z

← Older revision		Revision as of 16:15, 9 April 2016
Line 49:		Line 49:

	Continue installing 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		https://wiki.zoneminder.com/Ubuntu_Server_16.04_64-bit_with_Zoneminder_1.29.0_the_easy_way#Install_Zoneminder

Bbunge at 20:09, 9 April 2016

2016-04-09T20:09:00Z

← Older revision		Revision as of 16:09, 9 April 2016
Line 32:		Line 32:
	rm /etc/mysql/my.cnf (this removes the current symbolic link)		rm /etc/mysql/my.cnf (this removes the current symbolic link)

	cp /etc/mysql/~~mysql~~.conf.d/~~mysqld~~.cnf /etc/mysql/my.cnf		cp /etc/mysql/mariadb.conf.d/50-server.cnf /etc/mysql/my.cnf

	To change Mariadb settings:		To change Mariadb settings:

Bbunge at 19:20, 9 April 2016

2016-04-09T19:20:43Z

@@ Line 1: / Line 1: @@
 '''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.
+APR16
-  apt-get install mariadb-server     (MySQL will be removed)
+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.
 '''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.
 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

Bbunge at 20:08, 3 April 2016

2016-04-03T20:08:47Z

← Older revision		Revision as of 16:08, 3 April 2016
Line 1:		Line 1:
	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.		'''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)		apt-get install mariadb-server (MySQL will be removed)

Bbunge at 19:58, 3 April 2016

2016-04-03T19:58:39Z

← Older revision		Revision as of 15:58, 3 April 2016
Line 23:		Line 23:

	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.

			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

Bbunge at 19:57, 3 April 2016

2016-04-03T19:57:24Z

← Older revision		Revision as of 15:57, 3 April 2016
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.

Bbunge: 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..."

2016-04-03T19:49:58Z

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..."

New page

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:

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