How to upgrade Mariadb ?

Post your questions about Web Server usage and Apache + PHP + MySQL/SQLite web applications.
Locked
davidav
First post
Posts: 1
Joined: Thu Jul 27, 2017 9:47 pm

How to upgrade Mariadb ?

Post by davidav »

How can I upgrade the version of Mariadb installed on QNAP? The installed version is 5.5.. and we currently run MySQL 5.7.12 which has a couple of significant features we rely on and which are not available in 5.5.
From reading the Mariadb documentation it appears that I would need to upgrade to the 10.10 series to be compatible with MySQL 5.7.
User avatar
Toxic17
Ask me anything
Posts: 6469
Joined: Tue Jan 25, 2011 11:41 pm
Location: Planet Earth
Contact:

Re: How to upgrade Mariadb ?

Post by Toxic17 »

The MariaDB is built in so upgrading will be hard, and even if it was possible future firmware upgrades would overwrite your version.

Best to request this from QNAP directly in a future firmware update. Initially MariaDB was a QPKG which meant QNAP could have had two versions, ie 5.5.x and 10.1.x but they moved the Package back into the firmware.

https://helpdesk.qnap.com/index.php?/Tickets/Submit
Regards Simon

Qnap Downloads
MyQNap.Org Repository
Submit a ticket • QNAP Helpdesk
QNAP Tutorials, User Manuals, FAQs, Downloads, Wiki
When you ask a question, please include the following


NAS: TS-673A QuTS hero h5.1.2.2534 • TS-121 4.3.3.2420 • APC Back-UPS ES 700G
Network: VM Hub3: 500/50 • UniFi UDM Pro: 3.2.9 • UniFi Network Controller: 8.0.28
USW-Aggregation: 6.6.61 • US-16-150W: 6.6.61 • 2x USW Mini Flex 2.0.0 • UniFi AC Pro 6.6.62 • UniFi U6-LR 6.6.62
UniFi Protect: 2.11.21/8TB Skyhawk AI • 3x G3 Instants: 4.69.55 • UniFi G3 Flex: 4.69.55 • UniFi G5 Flex: 4.69.55
SolarisM
First post
Posts: 1
Joined: Mon Aug 07, 2017 1:10 pm

Re: How to upgrade Mariadb ?

Post by SolarisM »

You can install Container Manager and add in a distribution of MariaDB 10.2.7 or other version as you need. You'll probably need to setup a couple of environmental variables to read a custom my.cnf file but the process is relatively painless.

We used the process to install MariaDB 10.2.7 which is capable of multi-source replication etc. The Container Manager is a standard "docker" install, so there's lots of info out there on working with containers and docker.
Ronnay
First post
Posts: 1
Joined: Thu Oct 03, 2019 6:12 pm

Re: How to upgrade Mariadb ?

Post by Ronnay »

I've tried this all.
However, it didn't work.
When creating a container for the latest MariaDB official distribution, Container Station 2.1.3.1360 returns an error: "Background task error for create mariadb-1: no matching manifest for linux/arm in the manifest list entries"

My TS-231P2 NAS running QTS 4.4.2.1320 has an ARM 32-bit processor and it looks like all available MariaDB 10.x Docker distributions are all 64-bit based.
So in this article you should start with "MariaDB 10.x is only available for 64-bit platforms".

It could have saved me a whole day of searching why things doesn't work on my NAS.
User avatar
jaysona
Been there, done that
Posts: 846
Joined: Tue Dec 02, 2008 11:26 am
Location: Somewhere in the Great White North

Re: How to upgrade Mariadb ?

Post by jaysona »

Ronnay wrote: Wed Jul 01, 2020 11:37 pm ....
It could have saved me a whole day of searching why things doesn't work on my NAS.
... or you could do a little more reading before starting to go down the rabbit hole, the 64-bit Docker thing is fairly well documented on various sites.

The NAS you have is pretty anemic CPU wise and fine for basic things such as file storage, dns, email and basic web services, but not much more than that.
RAID is not a Back-up!

H/W: QNAP TVS-871 (i7-4790. 16GB) (Plex server) / TVS-EC1080 (32Gig ECC) - VM host & seedbox
H/W: Asustor AS6604T (8GB) / Asustor AS7010T (16GB) (media storage)
H/W: TS-219 Pro / TS-509 Pro
O/S: Slackware 14.2 / MS Windows 7-64 (x5)
Router1: Asus RT-AC86U - Asuswrt-Merlin - 386.7_2
Router2: Asus RT-AC68U - Asuswrt-Merlin - 386.7_2
Router3: Linksys WRT1900AC - DD-WRT v3.0-r46816 std
Router4: Asus RT-AC66U - FreshTomato v2021.10.15

Misc: Popcorn Hour A-110/WN-100, Pinnacle Show Center 250HD, Roku SoundBridge Radio (all retired)
Ditched QNAP units: TS-269 Pro / TS-253 Pro (8GB) / TS-509 Pro / TS-569 Pro / TS-853 Pro (8GB)
TS-670 Pro x2 (i7-3770s 16GB) / TS-870 Pro (i7-3770 16GB) / TVS-871 (i7-4790s 16GB)
User avatar
dolbyman
Guru
Posts: 35005
Joined: Sat Feb 12, 2011 2:11 am
Location: Vancouver BC , Canada

Re: How to upgrade Mariadb ?

Post by dolbyman »

also..this is not an article..it's a 3 year old forum discussion
Carl Ejnar
New here
Posts: 5
Joined: Thu Oct 01, 2020 4:19 am

Re: How to upgrade Mariadb ?

Post by Carl Ejnar »

Being a newbie to QNAP, I have what is most probably a simple question - but one I cannot readily find an answer to.
I have acquired a QNAP TS-251D NAS, running QTS 4.5.1.1480 (latest release) with a Intel Celeron J4025 2Ghz processor (x86 64bit). It comes with a MariaDB 5.5 preinstalled; but as I would like to look into WorldPress, I get the impression that I must run MariaDB 10.xx Can anybody tell me if this is possible?
User avatar
dolbyman
Guru
Posts: 35005
Joined: Sat Feb 12, 2011 2:11 am
Location: Vancouver BC , Canada

Re: How to upgrade Mariadb ?

Post by dolbyman »

install a web hosting container or install a VM e.g. Ubuntu..this wqy you should have theblatest and greatest

dont expose the NAS webserver to WAN ..it runs as root by default so if your Wordpress gets compromised, the rest of your NAS could get too
Locked

Return to “Web Server & Applications (Apache + PHP + MySQL / SQLite)”