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
Know my way around
Posts: 238
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.2.1630 build 20210406
NAS (backup): TS-1635AX FW: 4.5.2.1630 build 20210406
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] 4 x 18TB Exos, 1 x 14TB WD Red (currently switching due to worse performance of the WD Reds)
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.2.1594 build 20210302
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”