throwdbaaway

11 ms·

91.
by throwdbaaway 3y ago
What do you think about evolving the stored procedures into a stateless GRPC service that fronts the database? For the price of 1 (or 2) additional network hop, you get much better devx, while keeping most of the benefits provided by stored
92.
by throwdbaaway 3y ago
Nice benchmark script. With EXPLAIN (ANALYZE, BUFFERS), I see that * normalized/join version needs to read 5600 pages * normalized/join version with an additional UNIQUE INDEX .. INCLUDE (type) needs to read 4500 pages * denormali
93.
by throwdbaaway 3y ago
Don't share atomics among threads. For example, envoy proxy mostly doesn't share atomics among threads, and can scale nicely on arm64 without requiring the atomic extensions.
94.
by throwdbaaway 3y ago
> We're coming up on 10000 resources in our main Terraform repository and while there is definitely some friction, it's overall much better than having to hit the cloud API's to gather each of those states which would prob
95.
by throwdbaaway 3y ago
Heh, my old laptop has a git clone of this from September 1st 2016.
96.
by throwdbaaway 4y ago
I don't really know him, but from what I can tell, https://github.com/wjordan is at least equivalent to 2.0 people.
97.
by throwdbaaway 4y ago
https://github.com/hashicorp/consul/pull/12080 - this should be the Consul issue that brought down Roblox
98.
by throwdbaaway 4y ago
Good info. After reading this, I bought an Orange Pi 5 with 8GB of RAM, and now it is up and running with Ubuntu 22.04. The spec seems to be similar to a c6g.xlarge.
99.
by throwdbaaway 4y ago
You are talking about things like the "All Nodes Go Down Without a Proper Shutdown Procedure" example in https://galeracluster.com/library/documentation/crash-recove... right? To handle this case, some t
100.
by throwdbaaway 4y ago
I just learnt about "ip route change ROUTE quickack 1" from https://news.ycombinator.com/item?id=10662061 , so we don't even need to patch the kernel. This makes 2b a really attractive option.
101.
by throwdbaaway 4y ago
> And that pattern is the one that is used by GOs http libraries I don't think that is correct. In https://news.ycombinator.com/item?id=34213383 , I notice that Go's HTTP/2 library would write the HEADERS f
102.
by throwdbaaway 4y ago
Found the root cause from https://github.com/grpc/grpc-go/commit/383b1143 (original issue: https://github.com/grpc/grpc-go/issues/75 ): // Note that ServeHTTP us
103.
by throwdbaaway 4y ago
> not to mention nearly 50% of every packet was literally packet headers I was just looking at a similar issue with grpc-go, where it would somehow send a HEADERS frame, a DATA frame, and a terminal HEADERS frame in 3 different packets.
104.
by throwdbaaway 4y ago
I got matched with my old account with a score of only 0.45
105.
by throwdbaaway 4y ago
I have seen the "data service" design pattern that tries to work around this, by having a CRUD microservice to front a database, providing hundreds of APIs to read/write the data for 50 other microservices. If one of these CR
106.
by throwdbaaway 4y ago
That's a very smart solution indeed. I wonder if it is also possible to throw more memory at the problem? Managing instances with locally attached disks on the cloud is a bit of a pain, as you don't have the capability to stop&#x2
107.
by throwdbaaway 4y ago
Ah, I didn't know that the draft model has existed for Fantasy EPL. That's great!
108.
by throwdbaaway 4y ago
Fantasy Football, where millions of players compete in one league, and every top team has a Mohamed Salah, is just too boring. It was boring then, it is boring now. I much prefer the US fantasy sports format with a draft and only a dozen of
109.
by throwdbaaway 4y ago
Misconfiguration at GFE control plane?
110.
by throwdbaaway 4y ago
Speaking of Oracle, their so-called "match insights" ( https://www.premierleague.com/news/2210969 ) is the crappiest addition to EPL. It gives the impression that either Oracle doesn't understand football,
111.
by throwdbaaway 4y ago
Your example is the clearest indication in the whole discussion that Uber has a distributed monolith.
112.
by throwdbaaway 4y ago
> 1. The cache tried to fill the metadata with version. > 2. In the first round, the cache first filled the old metadata. > 3. Next, a write transaction updated both the metadata table and the version table atomically. > 4. In t
113.
by throwdbaaway 4y ago
Bigger than the human population queries per second. 1 request from human would likely create multiple queries internally.
114.
by throwdbaaway 4y ago
Exactly. The race condition problem from the example below still exists even without any caching, and perhaps still exists even without any replica. > Imagine that after shuffling Alice’s primary message store from region 2 to region 1,
115.
by throwdbaaway 4y ago
> these steps would rarely be same between companies or even between different teams in the same company. And the quality can differ a lot too. I used to think that k8s is not necessary, since our team has mastered both stateless and sta
116.
by throwdbaaway 4y ago
Indeed, I think the one (fictional) case is the main reason why we got so many perpetually unprofitable tech unicorn.
117.
by throwdbaaway 4y ago
https://knowledgebase.nomachine.com/AR02P00969 - and NoMachine seems to have decent support for Wayland.
118.
by throwdbaaway 4y ago
Once you have that constraint, it means you will either have the same network latency when writing to SQLite (if it is fronted by some lightweight proxy), or have a lot more frequent failover of SQLite (if it is running embedded within the
119.
by throwdbaaway 4y ago
So, what do you think of terraform? It's puzzling to me that we, as software developers, spend so much efforts trying to automate such one off deletion tasks, and the automation would inevitably go wrong and result in data loss.
120.
by throwdbaaway 4y ago
> Because the GDM data is immutable and thus can tolerate staleness, the query was also updated to read from replicas as well as Vitess primaries. Any data that is fronted by the memcached caching tier can tolerate staleness right? There

More ›