`internal_error` in Google Cloud HTTP(S) Load Balancing logs

I’d set up a Google App Engine service which was working fine, but I routed traffic to it via an HTTP loadbalancer. Which was working great in acceptance but not so much in production. It just threw a 404: Not Found at me. Nothing else. I checked the service logs, but traffic didn’t seem to arrive at the GEA service. So what now? I enabled the load balancer logs which delivered this gem: ...

December 11, 2021 · 2 min · Rutger de Knijf

Limit your BigQuery costs with Terraform

Let’s say you are a happy BigQuery user, and you spend about 100 euro a month on it. This may be fine for your (small) business but an expensive query is quick to make. What is expensive? Because really, it’s hard to create one that costs more than 30 euro. But what if someone accidentally deploys something that fires off a 1 euro query every second? That means a 2.6 million (!) BQ bill. If you don’t notice for a few days you’ll find yourself begging Google for a refund of hundreds of thousands of euros. ...

October 6, 2021 · 2 min · Rutger de Knijf

PostgreSQL benchmark over Cloud Proxy in GKE: socket vs port

In my bubble it’s always been common knowledge that a database connection over a Unix socket is faster than that same connection over a TCP connection. But does this boat still float when using the Google recommended way to access Cloud SQL from GKE: with Google Cloud Proxy as a sidecar in a pod? Since Cloud Proxy moves data over a TCP tunnel, speed should be identical. So to save everyone a little time, I did some very minimal benchmarking: ...

July 13, 2019 · 3 min · Rutger de Knijf