How to upgrade Mariadb ?

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

How to upgrade Mariadb ?

Post by davidav » Thu Jul 27, 2017 9:59 pm

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: 5418
Joined: Tue Jan 25, 2011 11:41 pm
Location: Planet Earth
Contact:

Re: How to upgrade Mariadb ?

Post by Toxic17 » Thu Jul 27, 2017 10:18 pm

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

QTS 4.x User Guidex

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


NAS: TS-473-32GB QM2-2P QXG-10G1T 4.4.2.1354 • TVS-463-16GB 4.4.2.1354 QM2-2S10G1TB • TS-459 Pro 2GB 4.2.6 • TS-121 4.3.3.1161 • APC Back-UPS ES 700G •
QPKG's: Plex 1.19.3 • Apache73 v2443.74070 • QSonarr 3.0.3.809 • QNBZGet 21.0 • phpMyAdmin 5.0.2 • Qmono 6.80.105 • McAfee 3.1.0 -6010 • HBS 3.0.200424 • LEgo v3.6.0
Network: VM Hub 3.0 <500/35> • UniFi USG Pro 4 • UniFi USW-16-150W • UniFi USW-8-60W • UniFi CloudKey Gen2+ • UniFi G3-Flex • UAP AC Pro • UAP AC Lite • SLM2008 • Dell 7050 MFF •

SolarisM
First post
Posts: 1
Joined: Mon Aug 07, 2017 1:10 pm

Re: How to upgrade Mariadb ?

Post by SolarisM » Mon Aug 07, 2017 1:56 pm

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 » Wed Jul 01, 2020 11:37 pm

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
Know my way around
Posts: 193
Joined: Tue Dec 02, 2008 11:26 am

Re: How to upgrade Mariadb ?

Post by jaysona » Thu Jul 02, 2020 12:45 am

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.
H/W: TS-219 Pro / TS-269 Pro / TS-253 Pro (8Gig)
H/W: TS-509 Pro x2 / TS-569 Pro / TS-670 Pro (i7-3770S 16Gig) x2 / TS-853 Pro (8Gig)
O/S: Slackware 14.2 / MS Windows 7-64 (x5)
Router1: Asus RT-AC86U - Asuswrt-Merlin - 384.18
Router2: Asus RT-AC68U - DD-WRT v3.0-r39960M kongac
Router3: Linksys WRT1900AC - DD-WRT v3.0-r43028 std
Router4: Asus RT-AC66U - FreshTomato v2020.3
Misc: Popcorn Hour A-110/WN-100, Pinnacle Show Center 250HD, Roku SoundBridge Radio (all retired)

dolbyman
Guru
Posts: 19095
Joined: Sat Feb 12, 2011 2:11 am
Location: Vancouver BC , Canada

Re: How to upgrade Mariadb ?

Post by dolbyman » Thu Jul 02, 2020 1:43 am

also..this is not an article..it's a 3 year old forum discussion

Post Reply

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