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: ...
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. But 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. ...
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: ...