As per the title, I'm just setting up a new install of Ubuntu 18.04 and have come to install Zoneminder.
I have the choice of MariaDB or MySQL, but don;t know which to go for.
Are there any pro's / cons to Zoneminder as to which one I go for?
Cheers, Scott.
Ubuntu 18.04: MySQL or MariaDB for Zoneminder
-
- Posts: 43
- Joined: Sat Oct 26, 2013 2:58 pm
-
- Posts: 494
- Joined: Sun Jun 29, 2014 1:12 pm
- Location: Melbourne, AU
Re: Ubuntu 18.04: MySQL or MariaDB for Zoneminder
Don't think it makes much of a difference at the moment, I think most head towards MariaDB, but that could be more a philosophy choice that features.
Production Zoneminder 1.37.x (Living dangerously)
Random Selection of Cameras (Dahua and Hikvision)
Random Selection of Cameras (Dahua and Hikvision)
Re: Ubuntu 18.04: MySQL or MariaDB for Zoneminder
Mariadb seems to work better for me. Had to replace a 17 camera server a while back and went with Bionic and Mariadb. System seems to use less memory than with MySQL.
-
- Posts: 4
- Joined: Wed Jan 16, 2019 9:49 pm
Re: Ubuntu 18.04: MySQL or MariaDB for Zoneminder
Echo the above. Migrated a server from mySQL 5.7 to MariaDB 10.1 and on to 10.3.12 on Ubuntu 18.04 and load dropped from ~1.5 to ~0.7 same camera analysing similar scenes
-
- Posts: 2
- Joined: Wed Nov 07, 2018 4:46 am
Re: Ubuntu 18.04: MySQL or MariaDB for Zoneminder
@hunnymonster have you some tips howto migrate from mysql to mariadb?
-
- Posts: 4
- Joined: Wed Jan 16, 2019 9:49 pm
Re: Ubuntu 18.04: MySQL or MariaDB for Zoneminder
Not really - I simply installed the Ubuntu-bundled MariaDB (10.1 train) which took care of the MySQL - MariaDB change, then added the MariaDB PPA for the 10.3 train and upgraded.
Take a backup before you start, I'm not taking the blame if your installation breaks![Mr. Green :mrgreen:](./images/smilies/icon_mrgreen.gif)
Take a backup before you start, I'm not taking the blame if your installation breaks
![Mr. Green :mrgreen:](./images/smilies/icon_mrgreen.gif)
-
- Posts: 3
- Joined: Thu Apr 13, 2017 9:17 am
Re: Ubuntu 18.04: MySQL or MariaDB for Zoneminder
Is it also possible to use InfluxDB instead of MySQL or MariaDB while using ZM???