Do you have a mainframe? (not your desktop PC, but a server/cluster). What are you using it for? Got any pics? Post them here.
I'll start. What you see is my recently procured optiplex farm. They can be obtained very cheap and have pretty good specs. I intend to use them to divide a database by 3, and then have queries run simultaneously on them, as a way of tripling query speed.
Other urls found in this thread:
hercules-390.org
multicians.org
twitter.com
how big is the database and what’s the purpose of the database? is the extra power consumption worth the speed?
>extra power consumption
lmao get a load of this poorfag
wait people care about how much power their toys consume? electricity isnt expensive
Meh, if your dataset can fit in RAM there's no point in adding 3x the failure points, additional network latency, 3x power supplies, 3x the fan noise, etc. It's not about being a poorfag, they could have spent that money on more RAM, a multi-socket board, faster disks, moar cores, etc. Any of which would net far more "query performance" than sharding a database. Thinking 3x computers = "3x the query speed" is just being wasteful and naive. (I'm assuming OPs dataset fits in RAM, because if it didn't he wouldn't be buying *2nd-hand Dell Optiplex* boxen.)
>do you have a mainframe
>here's my optiplex farm
>intend to have them collect dust on the shelves, merely acting as conversation pieces rather than anything practical.
ftfy
>how big is the database and what’s the purpose of the database?
TOP SECRET. But you might have used it actually.
>Is the extra power consumption worth the speed?
The 3 of these (at idle) use a combined total of about 55W. So I don't think it will cost that much per month in electricity. Behind, them (which you can't see) is an AMD Athlon II that I run as a media server. Just that media server alone is using 90W at idle D:
>how big is the database
Its not big, but its not been easy to optimize it either.
heheh
>Behind, them (which you can't see) is an AMD Athlon II
Actually its in that rear pic, on the right. His name is fatteh
>you might have used it actually
yeah ok there bud
>TOP SECRET. But you might have used it actually.
let me guess you run some animu weeb girl porn website
lkml
prove it
>lkml
as in, lkml.org?
mailing lists are bloat
I'd rather not say because I don't want this to look like some shill thread. But I'm pretty sure you've used it as its known around /g
SPILL THE BEANS, NIGGER
I don't have friends so I have to post them on g if I want to talk about them. You're all I have.
PROD:
- Dell PowerEdge T110 ii (Xeon 1230 v1 / 16GB / 2x 250GB SSD / 4 4TB HDD / 2x 120GB SSD (OS) / Mellanox CX3) - Server 2016 Essential
- Dell Precision T1700 (i7 4770 / 8GB / 250GB SSD / 2TB HDD / Mellanox CX3) - Plex
Non-PROD:
- 4x Dell PowerEdge R710 (2x Xeon 5650 / 144GB / 2x 500GB SSD / 6x 3TB SAS HDD / 1x 64GB SSD / 10GIGe) - Server 2016 Datacenter in S2D cluster OR OpenStack, depending on what I'm working on.
1x Dell Optiplex 990 (Xeon 1225 / 8GB / 128GB SSD / 2x 1GB) - Management box for the rest of non-prod.
A few tinkerboards largely for monitoring.
Are those really mainframes tho?
show pics
Technically no, but nothing in this thread thus far has been...
I have yet to see a VAX or AS400 or some such thing.
Not getting one anytime soon but just curious, how much does the average mainframe cost for "domestic" usage?
I'd suggest starting out with an emulator.
Hercules can run a wide variety of IBM operating systems, although finding a copy of a recent OS is tricky: hercules-390.org
If you want to go really old school, you could always try out Multics: multicians.org
Used mainframes are pretty much unavailable.
Usually, you don't own the hardware; you are paying for the "service" of using it. In some cases, it even automatically charges you based on the usage. Once you are done with it, IBM takes it back.
Freenas box for storage. LTSB 2016 for running everything else. NAS and an everything else box is honestly the best way to go desu.