Running Mysql from M.2

Questions about SNMP, Power, System, Logs, disk, & RAID.
Post Reply
stephensaid
New here
Posts: 2
Joined: Fri Apr 09, 2021 1:34 am

Running Mysql from M.2

Post by stephensaid » Fri Apr 09, 2021 1:43 am

Hi guys,
First post here although own 3 Qnaps.

I'm planning to install another at a client but wish to use MySql as backend for a custom point of sale system which we shall move to this qnap. Thinking of buying tvs-473e. Feel free to suggest alternatives. This is a small business... I think this device is already overkill for him.

Does it make sense to install/run MySql DB from an M.2 to maximise speed?

Since we'll also be having a raid 6 setup, I'd love the DB to be backuped to the storage volume on this raid.

Could someone advice how to go about setting such a setup if viable?

Thanks
Stephen

holger_kuehn
Easy as a breeze
Posts: 264
Joined: Sun Oct 20, 2013 11:45 pm
Location: Premnitz, Germany

Re: Running Mysql from M.2

Post by holger_kuehn » Fri Apr 09, 2021 4:28 am

You'll need two M.2 disks here (as RAID1). When Installing these as the first storage pool it becomes the system disc and holds all apps by default. So the MySQL (or more precise MariaDB) is stored there as well.

You can plan jobs to export the data to the RAID6, I'd have trouble calling it a backup, as it's not external on seperate media.
NAS (production): TS-1635AX FW: 4.5.3.1652 build 20210428
NAS (backup): TS-1635AX FW: 4.5.3.1652 build 20210428
QTS (SSD): [RAID-1] 2 x 2TB Samsung Evo 860 M.2-Sata
Data (QTier): [RAID-6] 4 x 500GB Samsung Evo 860 Sata
Data (HDD): [RAID-6] 5 x 18TB Exos
RAM: 8 GB (QNAP shipped)
UPS: CyberPower CP900EPFCLCD
BACKUP: 10x4TB WD Red using a USB 3.0 Dock

NAS: TS-873U-RP FW: 4.5.3.1652 build 20210428
Data (SSD): [RAID-10] 4 x 1TB Samsung Evo 860 Sata
RAM: 8 GB (QNAP shipped)
UPS: CyberPower PR2200ELCDRT2U
BACKUP: 4TB Synology DS214 FW: DSM 6.2.3.25426 Update 2

stephensaid
New here
Posts: 2
Joined: Fri Apr 09, 2021 1:34 am

Re: Running Mysql from M.2

Post by stephensaid » Sat Apr 10, 2021 12:22 am

Ic. You're right about the backup thing.
We'll back it up to some other computer for the time being but the idea is to setup yet another offsite qnap where we will replicate everything.

Thanks

Post Reply

Return to “System & Disk Volume Management”