Stack Overflow: The Hardware – 2016 Edition
nickcraver.com
Stack Overflow: The Hardware – 2016 Edition
1–10 of 27 posts
Re: Stack Overflow: The Hardware – 2016 Edition
#2Re: Stack Overflow: The Hardware – 2016 Edition
#3I'd love to hear more about their backups/deployment.
Re: Stack Overflow: The Hardware – 2016 Edition
#4Re: Stack Overflow: The Hardware – 2016 Edition
#5Re: Stack Overflow: The Hardware – 2016 Edition
#6Re: Stack Overflow: The Hardware – 2016 Edition
#7Re: Stack Overflow: The Hardware – 2016 Edition
#8How are the drives used on their SQL server boxes? They have a massive NVMe drive on raid 0 with 20 sata drives in raid 10? Which drives are used for prod data? Do they run backups on the same box?
In the Stack Exchange cluster, the RAID 0 NVMe array contains all databases except for a large log database (which I called Careers.BigStuff, because it seemed like a good idea at the time). This larger log database is much more rarely accessed and is on the 10K HDD RAID10.
We run backups on the primary for several reasons, but they are all sent off-box. We have 2 primary on-site backup servers, then those backups go offsite and to tape. Database backups are every 15 minutes with T-Logs and full backups nightly. We also run copy-only backups in the DR data center nightly as an additional backup measure.
Re: Stack Overflow: The Hardware – 2016 Edition
#9You know someone is a real hardware guy when he calls backup, monitoring and logging non essential. Also a bit confused about the 2960Ss and the choice of Cisco in general. I'd never thought Stack Overflow ran on Network Equipment, what I'd describe as consumer hardware in networking.
Re: Stack Overflow: The Hardware – 2016 Edition
#10This is serious Server HW porn. Thanks for sharing! Would love to know more information about your bandwidth usage, limits, etc. Also, do you have any closer idea as to how much this would cost in "cloud" services in % terms? (I'm doing general research in Bare Metal & Colocation vs Cloud pricing comparison). Thank you!
But a better answer is: that price keeps changing. We now have a lot of AWS and on-prem experience in house to do a great post. We'll be doing a lot of research and proper comparisons as a huge part of that upcoming post: https://trello.com/c/4e6TOnA7/87-on-prem-vs-aws-azure-etc-wh...