HNHacker News
TopNewBestAskShowJobs

bzillins

40 karma · joined October 7, 2017

submissionscomments
bzillins··on Flighty Airports
Flighty was recommended to me by a flight attendant and I also have been notified hours ahead of the airlines by it.
bzillins··on Why Using Cassandra as a metadata database for an object store is a bad choice
NetApp StorageGRID uses Cassandra according to their docs. "Three copies of object metadata are automatically maintained at each site to provide redundancy and protect object metadata from loss. The copies are load balanced across all Storage Nodes at each site."
bzillins··on To All the Jobs I Had Before
This was required reading for an engineering management course and is one of the few texts that I find myself thinking back on many years later. I strongly second this recommendation.
bzillins··on The Dream of New York's Forgotten Elevated Subway
The NYC blizzard of 1888 had a large impact on the city's decision to build subways which started construction in 1900.

https://www.nycsubway.org/wiki/The_Blizzard_of_1888;_the_Imp...

bzillins··on Ice cold archive storage
The title seems like a reference to the 2003 Outkast song Hey Ya! https://www.youtube.com/watch?v=PWgvGjAhvIw

Alright alright alright!

bzillins··on Tips for your first tech conference
I completely agree that breakfast at conferences has been a fantastic opportunity to meet fellow attendees. Conversation is quite easy to strike up by asking which talks the table is planning to attend.
bzillins··on DRAM Prices in ‘Freefall’
The newer winterfell nodes [1] have made their way to ebay at sub 100$ and do not have the exotic power requirements of the earlier dual sled windmill nodes. You can easily power them off of a converted server power supply via diy [2] or commercial [3] means. Windmill nodes have more space on the pcie riser and quieter fans going for them as well.

1) https://www.ebay.com/itm/Quanta-Winterfell-Barebone-Node-2x-... 2) http://colintd.blogspot.com/2016/10/hacking-hp-common-slot-p... 3) https://www.parallelminer.com/product/breakout-board-adapter...

bzillins··on Ask HN: Which 3D Printer for Product Design Prototyping in 2019?
I have been very happy with my Folgertech Prusa

https://folgertech.com

bzillins··on Scalable incremental data aggregation on Postgres and Citus
In a follow up blog post https://blog.cloudflare.com/http-analytics-for-6m-requests-p... Cloudflare released the following image https://blog.cloudflare.com/content/images/2018/03/Old-syste... with 'single instance PostgreSQL database (a.k.a. RollupDB), accepted aggregates from Zoneagg consumers and wrote them into temporary tables per partition per minute' as the description for the single Postgres instance depicted. The aggregation system described in the Citus blog distributes the aggregation work over multiple Postgres instances.
bzillins··on Ubiq: A Scalable and Fault-Tolerant Log Processing Infrastructure (2016)
Published in 2016
bzillins··on Designing a Userspace Disk I/O Scheduler for Modern Datastores (2016)
Using a tool like diskplorer (mentioned in article 1) to gather the concurrency and IOPS relations at various read sizes (mentioned in article 2) seems like it a good datapoint for use in tuning a database filesystem. https://github.com/avikivity/diskplorer
bzillins··on Busting myths about BigQuery
As long as you turn a PG table into a BQ dataset with enough partitions (BQ tables) such that queries do not touch a disproportionate amount of unnecessary data, you utilize date partitioning, and you can deal with a minimum 1.5 second query time the service is truly amazing. My only frustrations are that the majority of streaming service degradations are never noted on the Status dashboard and that you can get really odd error states like headers stating that you should be getting json while the body contains a html error message.
bzillins··on Citus Cloud 2, Postgres, and Scaling Without Compromise
If the rebalancer leverages an update from PostgreSQL 10 does that mean new Citus formations are now PG10 based?
bzillins··on Scaling the GitLab database
Looking through the public Grafana dashboards I noticed that the database backups page is not showing any data points (http://monitor.gitlab.net/dashboard/db/backups). Is this meant to a public page?