5 ms·
You remind me of some ex coworkers who thought everything could be done on RDBMS systems and then when they had to export large amounts of data topped out at 35
by VirusNewbie 5y ago
You remind me of some ex coworkers who thought everything could be done on RDBMS systems and then when they had to export large amounts of data topped out at 3500 tps.
Meanwhile I'm over here using Scylla and 3 nodes can give me roughly 3.5M TPS for data extraction.
RDBMS are great for certain use cases but they do not scale and if you think they do you don't really know what scale means.
Sure you can cite things like Github using MySql, but i'll also point out they've invested thousands upon thousands of man hours customizing layers on top of MySql to support their sharding which also, oops, had a bug that gave them almost half a day of downtime at one point. This is not a good use of someone's time, GH definitely made the wrong decision. Don't steer other people into making similar mistakes especially given it seems you have a lack of experience on designing systems at scale.
- deleted 5y ago[deleted]
- dreyfan 5y agoExactly where did I suggest using a single mysql instance or bandaiding a fleet of them together? Clickhouse vastly outperforms and outscales Scylla with a fraction of the hardware and cost.
- PeterCorless 5y agoDifferent purposes — OLAP vs. OLTP. Reminder of this thread: https://news.ycombinator.com/item?id=22478407 https://news.ycombinator.com/item?id=22478407
- deleted 5y ago[deleted]
- VirusNewbie 5y agoClickhouse is in no way an RDBMS.
- dreyfan 5y agoR doesn't stand for row-store. The access patterns of Clickhouse are comparable with any RDBMS. The fact that it happens to be a column-store doesn't make it not an RDBMS. It doesn't mean "row-oriented databases designed for OLTP workloads" as it appears you think is the case. Should I have simply said "SQL databases where data is represented in tables with a defined schema" to simplify the discussion and prevent your ignorant diatribe?
- VirusNewbie 5y agoIt stands for "relational", you know that CLickhouse is not a relational database right? Have you used any of these technologies? Cassandra/Scylla have a defined schema. Did you really not know that?