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.
How to upgrade Mariadb ?
- Toxic17
- Ask me anything
- Posts: 6477
- Joined: Tue Jan 25, 2011 11:41 pm
- Location: Planet Earth
- Contact:
Re: How to upgrade Mariadb ?
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
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
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
-
- First post
- Posts: 1
- Joined: Mon Aug 07, 2017 1:10 pm
Re: How to upgrade Mariadb ?
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.
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.
-
- First post
- Posts: 1
- Joined: Thu Oct 03, 2019 6:12 pm
Re: How to upgrade Mariadb ?
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.
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.
- jaysona
- Been there, done that
- Posts: 854
- Joined: Tue Dec 02, 2008 11:26 am
- Location: Somewhere in the Great White North
Re: How to upgrade Mariadb ?
... 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)
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)
- dolbyman
- Guru
- Posts: 35248
- Joined: Sat Feb 12, 2011 2:11 am
- Location: Vancouver BC , Canada
Re: How to upgrade Mariadb ?
also..this is not an article..it's a 3 year old forum discussion
-
- New here
- Posts: 5
- Joined: Thu Oct 01, 2020 4:19 am
Re: How to upgrade Mariadb ?
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?
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?
- dolbyman
- Guru
- Posts: 35248
- Joined: Sat Feb 12, 2011 2:11 am
- Location: Vancouver BC , Canada
Re: How to upgrade Mariadb ?
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
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