[DLingard89]

Hi all, sorry if this is in the wrong place...

I currently use a RPi to run MYSQL pointing to a Mac holding the shared siles over smb to centralise my database - which works great now I have just got hold of a ls-qvl buffalo 12TB NAS drive, which has MySQL support.

My question is do you think I will get the same performance if I store the data on the NAS, AND let it run the SQL DB?


Library updates are handled at the Mac end..


tech specs;



System


CPU Type

Marvell 88F6282 ARM



CPU Speed

1.6GHz



Performance

Read: 80+MB/s (Direct Gigabit Network Connection)



RAM

DDR3 256MB



Internal Hard Drives


Number of Bays

4



Total Capacity

Enclosure, 2TB, 4TB, 6TB, 8TB, 12TB, 16TB



Supported HDD Capacities

1TB, 2TB, 3TB, 4TB (sold separately)



Drive Interface

SATA 1, 1.5Gb/s



Supported RAID Levels

JBOD, 0, 1, 5, 10



LAN Interface


Standard Compliance

IEEE802.3ab/IEEE802.3u/IEEE802.3 Standard



Data Transfer Rates

10/100/1000 Mbps



Connector Type

RJ-45



Number of Ports

1




USB Interface


Standard Compliance

USB 2.0



Connector Type

USB-Type A



Number of Ports

2 (1 x Front, 1 x Rear)



Data Transfer Rates

Max: 480 Mb/s



-

Max 12Mbps (Full Speed Mode)



Protocol Support


Network Protocol

TCP/IP, Apple Talk



File Sharing

SMB/CIFS, AFP, FTP



Management

HTTP



Time Synchronization

NTP



Other


Dimensions

149 x 233 x 154mm



Weight

5.5Kg



Power Consumption (Max.)

Average 43W



Operating Environment

0-35°C, 20-80% (non-condensing)



Client OS

Windows 8 (32/64bit), Windows® 7 (32/64bit), Windows® Vista™ (32/64bit), Windows® XP, Windows Server® 2008 R2 (64bit), 2008 (32/64bit), 2003 R2 (32bit), 2003 (32bit), Mac OS® 10.4 or later



Power Supply

External AC 100-240V, 50/60Hz

[CaptainPsycho]

Depends strongly on your MySWL configuration. In case of the limited ram you have to tweek it a bit. Have a look at your ram consumption on the pi first.

[DLingard89]

its sitting at 155mb of 438 at the mo, so looks like it should be good to go to me, assuming the 256 in the nas is mostly free to use

[katsup]

I tried mysql on my Qnap (TS-412) once, but got frustrated at how long my main system would take to view the library. I say just test and see what happens, you can always revert.

[CaptainPsycho]

its sitting at 155mb of 438 at the mo, so looks like it should be good to go to me, assuming the 256 in the nas is mostly free to use

No it's not going to be fine.

You'll need some memory left for caching the disk accesses.

Try to tune your my.cnf to use less ram and look if the performance is still ok. I'd aim for about 50mb usage.