Icepick
-
Posts
6 -
Joined
-
Last visited
Icepick's Achievements
-
There are certain constraints we have that prevent us from using and testing on such services else we'd just move over to cloud computing and be done with it and hence my reason for starting this post on the forum to get as much information, theoretical at least, as I can before we go and acquire the hardware only to discover it's money wasted. As for the DBs that is information I cannot divulge other than we're running it on MySQL. Should we continue with this trail project we also keeping in mind that we can repurpose the PC for other means within our systems so that it's also still being used and not wasted.
-
We haven't decided on a server yet and we'll just build one mean workstation for the trail and then repurpose it when we do get the servers, as for the OS we're running Ubuntu
-
That is not entirely possible as the DB runs at a couple of TBs
-
Agreed, but doing RAID on M.2 drives isn't easy (tongue in cheek), at least the hardware isn't as readily available in ZA. I'm using M.2s as they are the fastest I could find for the cheapest and a similar PCIe ssd with the same size and speeds is about two to three times the price per GB
-
Well granted the information I had at the time your opinion does make perfect sense. We are talking about a database with millions of transactions running, so we need to speed up those transactions as much as we possibly can to fit more transactions and being able to sell more results. Without being able to divulge too much information the batches that run on these servers and DBs are what brings in the money. However this project we have now is just a trail and "scaled" version to see how it works and the budget approved for this test is around ZAR50K (about $4.5K).
-
Based off your vlog of a FAST 12TB HDD, I have another challenge for you. We've been given a project of building a storage array of 4TB capable of RW around 2.5 to 3.5 GB per second, as cheap as possible. So if you could almost double the RW speeds of a spinning disk using a optane SSD what would it be capable of when using it with cheaper SSDs with about 540MB RW and even when trying to use it in a RAID 0.