Moving MariaDB database to SSD

Post your questions about Web Server usage and Apache + PHP + MySQL/SQLite web applications.
Post Reply
WarmHeart
Starting out
Posts: 30
Joined: Mon Sep 14, 2015 9:18 pm

Moving MariaDB database to SSD

Post by WarmHeart »

Hi,

I'd like to move my database to my SSD and found this link explaining how: viewtopic.php?t=140924

My question is whether this is a common thing or will I end up breaking stuff in the process? It seems strange that I can now move almost any app to a different volume but Qnap doesn't provide a way to move the databases (or do they?) which seems to me to be the most obvious thing to move.

Thoughts? Has anybody done this? If so, how'd it work out for you?

Thanks in advance.
Last edited by WarmHeart on Mon Mar 21, 2022 8:46 am, edited 1 time in total.
QNAP TVS-471 w/ 4x4TB WD Reds (RAID1) + SSD (1 TB), 2 Storage Pools (8 TB, 1 TB), FW: QTS 4.5 (Latest...)
WarmHeart
Starting out
Posts: 30
Joined: Mon Sep 14, 2015 9:18 pm

Re: Moving MariaDB database to SSD

Post by WarmHeart »

Hi, I posted this about a year ago with no replies, so I'm trying again. My concern is that the post describing how to do this -- viewtopic.php?t=140924 -- has the instruction to:

Code: Select all

 Find "datadir_set=" and change to "datadir_set=1"
But my mysqld.sh file doesn't have this line. Does anyone know if it's still needed?

I'm using MariaDB 5.5.68, Version 1.0.1.235 (2021-10-04)

Any ideas of how to move the DB to my SSD?

Thanks!!
QNAP TVS-471 w/ 4x4TB WD Reds (RAID1) + SSD (1 TB), 2 Storage Pools (8 TB, 1 TB), FW: QTS 4.5 (Latest...)
phuku
First post
Posts: 1
Joined: Wed Apr 20, 2022 10:31 am

Re: Moving MariaDB database to SSD

Post by phuku »

I have the same needs,found no course
Post Reply

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