Can RAS PI3 handle?

[erhanzeynel]

Hi all,

Now I'm working on a sales automation system that will be about 1000 nodes and there will be 400 SQL queries per minute
aprox 200 of them desktop computers runing windows rest of them smartphones runing android.

nearly all of querys less then 1kB

can a raspberry pi 3 B can handle that workload?

edit: typo

[drgeoff]

Where is the database stored? RPis are not immune from causing corruption to their file systems if power is interrupted before a software shutdown has completed.

[asandford]

Hi all,

Now I'm working a sales outomation system that will be about 1000 nodes and there will be 400 SQL queries per minute
aprox 200 of them desktop computers runing windows rest of them smartphones runing android.

nearly all of querys less then 1kB

can a raspberry pi 3 B can handle that workload?

Too little information.
If you need to ask what info you need to supply, you haven't thought it through.

[erhanzeynel]

Where is the database stored? RPis are not immune from causing corruption to their file systems if power is interrupted before a software shutdown has completed.

Pi will be powered by ups also there will be extra battery pack as disaster plan
I prefer keep db in sdcard also it can be usb Hdd or another sdcard by usb reader so I'm open to any sugestions.

Hi all,

Now I'm working a sales outomation system that will be about 1000 nodes and there will be 400 SQL queries per minute
aprox 200 of them desktop computers runing windows rest of them smartphones runing android.

nearly all of querys less then 1kB

can a raspberry pi 3 B can handle that workload?

Too little information.
If you need to ask what info you need to supply, you haven't thought it through.

As drgeoff mentoined RasPi will work as db server.
What kind of any other information you need for help? Just ask

[asavah]

As drgeoff mentoined RasPi will work as db server.
What kind of any other information you need for help? Just ask

I wouldn't risk using rpi as a production grade database server. Period.

For that kind of workload you need a couple of proper servers with raid, lots of ram and HA/clustering.

[erhanzeynel]

Finally I get my pi and now installing raspbian.

I want to test workload by making sql queries over and over but afraid from relase it's soul (magic smoke)

is there chance as fry it by workload?

[davidcoton]

Finally I get my pi and now installing raspbian.

I want to test workload by making sql queries over and over but afraid from relase it's soul (magic smoke)

is there chance as fry it by workload?

Highly unlikely. Worst case is you crash the software and damage the filesystem, so make a backup of the fully configured system before load testing.
Very worst case is that damaged filesystem means permanently damaged SDCard.

As others have hinted, an SDCard is not suitable for a production grade database. Use a USB HDD or SSD as a minimum.
Then again, there is a reason why you need to create this system rather than just download/buy it -- it's the same reason why commercial server systems cost far more than a Pi. It's not just the UPS, you need to think through the whole scheme of networking, data throughput, data management, backups, system restoration, availability, maintainability, and probably half a dozen other things I haven't thought of. Some will be OK, others may reveal showstoppers. The Pi is just not designed for this sort of application.

I hope you are not putting yourself at commercial risk with this system, either in your own enterprise or (worse) a customer's.

[erhanzeynel]

Finally I get my pi and now installing raspbian.

I want to test workload by making sql queries over and over but afraid from relase it's soul (magic smoke)

is there chance as fry it by workload?

Highly unlikely. Worst case is you crash the software and damage the filesystem, so make a backup of the fully configured system before load testing.
Very worst case is that damaged filesystem means permanently damaged SDCard.

As others have hinted, an SDCard is not suitable for a production grade database. Use a USB HDD or SSD as a minimum.
Then again, there is a reason why you need to create this system rather than just download/buy it -- it's the same reason why commercial server systems cost far more than a Pi. It's not just the UPS, you need to think through the whole scheme of networking, data throughput, data management, backups, system restoration, availability, maintainability, and probably half a dozen other things I haven't thought of. Some will be OK, others may reveal showstoppers. The Pi is just not designed for this sort of application.

I hope you are not putting yourself at commercial risk with this system, either in your own enterprise or (worse) a customer's.

There is only one system avilable in my country about our job and it's price is not reasonable.
No need to worry about the costumers data.
Because I will use pi for only alpha tests just for me and few other in this time.
Also server will work as a order exchange server, all valueable data will be on local database of costumers. It's just for sending orders from costumer pc to costumer android devices.

Your advices about db media noted and underlined, thank you.

I know someone who using pi as a cryptocurrency mining pool server (not a miner) about 1 year. I guess this workload more then my.

And another way I will just try, if get some problem or when I get enough costumer my pi will work on another role

Thank you all for helps.

[Tdi-Me]

I have heard of people setting up a pi as a miner for different crypto currencies, I just wonder if they ever actually find anything.
I would also agree with previous comments about using a micro sd car, that will be a giant choking point. You will want to either use a ssd or external hard drive with its own power supply.
I am not really sure how well it will work, but maybe if you can do a bit of clustering ( no idea myself how it would be set up ) maybe using a few rpi's would work.

[mahjongg]

I have heard of people setting up a pi as a miner for different crypto currencies, I just wonder if they ever actually find anything.
I would also agree with previous comments about using a micro sd car, that will be a giant choking point. You will want to either use a ssd or external hard drive with its own power supply.
I am not really sure how well it will work, but maybe if you can do a bit of clustering ( no idea myself how it would be set up ) maybe using a few rpi's would work.

people are not using a PI to mine bitcoins, that would be crazy!
what they use a PI for is to control an FPGA farm that does the actual mining.
They wouldn't do it if it were not profitable.

[erhanzeynel]

I have heard of people setting up a pi as a miner for different crypto currencies, I just wonder if they ever actually find anything.
I would also agree with previous comments about using a micro sd car, that will be a giant choking point. You will want to either use a ssd or external hard drive with its own power supply.
I am not really sure how well it will work, but maybe if you can do a bit of clustering ( no idea myself how it would be set up ) maybe using a few rpi's would work.

There is some tutorials about sql and php hosting by pi on the internet.
Also I told a pool server on pi in my last post,

Pool server means aprox 12k sql querys /sec per one node an there was over 100 nodes at least.
So 1200000 query/second will work.
I will test when I set my db server up. And results will be published on this topic.