pwmtr

7 ms·

1.
by pwmtr 3mo ago
The author of the blog post here. In hindsight, the kernel bug seems obvious, but the process of tracking it down was quite interesting. I especially enjoyed the statistical analysis part, which isn't something you normally get to do w
2.
Latitude.sh is being acquired by Megaport(latitude.sh)
1 points by pwmtr 10mo ago|0 comments
3.
by pwmtr 11mo ago
We’ve been seeing the same trend. Lots of teams moving to Hetzner for the price/performance, but then realizing they have to rebuild all the Postgres ops pieces (backups, failover, monitoring, etc.). We ended up building a managed Post
4.
Microsoft Contributes DocumentDB, a MongoDB Alternative, to Linux Foundation(linuxfoundation.org)
7 points by pwmtr 1y ago|2 comments
5.
by pwmtr 1y ago
If you are looking for Postgres on Hetzner, you may want to check out Ubicloud. We host in various bare metal providers, including Hetzner. (I am the lead engineer building Ubicloud PostgreSQL, so if you have questions I can answer them)
6.
by pwmtr 1y ago
Yes, that is correct. That said, in our tests we only saw 2x improvements in CH benchmarks. However, we found out that it was due to an architectural issue in our VM I/O path and how we virtualize the storage. Based on our estimations
7.
by pwmtr 1y ago
Really appreciated the authors persistence on keeping to use PostgreSQL. There are many specialized solutions out there, but at the end they usually lack PostgreSQL's verstatility and battle testedness.
8.
by pwmtr 1y ago
I read something similar on Yuval Harari's Homo Sapiens, where he suggests wheat domesticated humans not the other way around. An excerpt can be found here [1]. Whole essay is great but I especially liked this part: > The word “dome
9.
by pwmtr 2y ago
At the time of our investigation, we found few articles supporting that power caps could potentially cause hardware degradation, though I don't have the exact sources at hand. I see the child comment shared one example, and after some
10.
by pwmtr 2y ago
The root cause was a problem with the motherboard, though the exact issue remains unknown to us. I suspect that a component on the motherboard may have been vulnerable to power limitations or fluctuations and that the newer-generation mothe
11.
by pwmtr 2y ago
Author of the blog post here. Yeah, this is generally a good practice. The silver lining is that our suffering helped uncover the underlying issue faster. :) This isn’t part of the blog post, but we also considered getting the servers and k
12.
by pwmtr 2y ago
Definitely interesting material. I realized, especially in last few years, there is an increased interest on moving away from propriety clouds/PaaS to K8s or even to bare metal, primarily driven by high prices and also interest of havi
13.
by pwmtr 2y ago
Our runners are running on our own infrastructure. We get bare metal instances from providers like Hetzner or Leaseweb and virtualize them. Your runners run on the ephemeral VMs on those bare metal instances. Is being on AWS a requirement f
14.
by pwmtr 2y ago
They have a Ruby control plane; https://www.crunchydata.com/blog/crunchy-bridges-ruby-backen...
15.
by pwmtr 2y ago
I cannot comment on Let's Encrypt's reliability. Maybe I had just too many bad experiences from DigiCert outages and I'm bit pessimistic. However, their status page does not give much confidence https://letsencrypt
16.
by pwmtr 2y ago
There is a "Connection Pooling" box at the first diagram. Though, the article does not talk about all boxes. It would simply be very long wall of text if we had mention all components. Instead we picked some of the more interestin
17.
by pwmtr 2y ago
* Sorry for the confusion, our customers do not necessarily want to deploy database in a container. It is just we encountered lots of folks who wants to do that and asked us about how to handle HA and backups. Though, I don't think it
18.
by pwmtr 2y ago
At k8s, isolation is at the container level, thus properly isolating (for security purposes) system calls is quite difficult. This wouldn't be a concern if you are running Postgres for yourself. Also for us, one reason was operational
19.
by pwmtr 2y ago
Sure you can, but Let's Encrypt, just like DigiCert, is a 3rd party provider and they don't guarantee that you would get a signed certificate in few minutes. If they have an outage, it could take hours to get a certificate and you
20.
by pwmtr 2y ago
It is managed maintenance window, which basically means letting user to pick a time window such as Saturday 8PM-9PM and as a service provider you ensure that non critical maintenances happen at that time window.
21.
by pwmtr 2y ago
At another thread in this page, I wrote more about this, but in summary; we also like k8s-based managed Postgres solutions. They are quite useful if you are running Postgres for yourself. In managed Postgres services offered by hyperscalers
22.
by pwmtr 2y ago
You are not wrong. There are benefits for sharing certificate authority per customer. We actually considered using one authority per organization. However in our case, there is no organization entity in our data model. There is projects, wh
23.
by pwmtr 2y ago
Definitely agreed. It is great feature and a building block for many complex features such as multiple primaries, zero down time migrations etc. I'm also quite happy to see with each PG version, it becomes more stable/easy to use.
24.
by pwmtr 2y ago
Do you mean writing something similar for MySQL or building a MySQL service at Ubicloud? For the first one, the answer would be no, because I don't have any expertise on MySQL. I only used it years ago on my hobby projects. I'm no
25.
by pwmtr 2y ago
I started as software developer and I'm still a software developer. Though I always worked on either core database development or building managed database services, by coincidence at the beginning and by choice later on. I was also fo
26.
by pwmtr 2y ago
You can still restore to a given minute even without one minute WAL boundaries (most of the time). Consider the case where you have a very low write activity and you would be able to fill up one WAL file (16MB) in 1 hour. That WAL file won&
27.
by pwmtr 2y ago
Yes, we use physical replication for HA. There are many reasons that cloud providers don't want to support logical replication; - It requires giving superuser access to user. Many cloud providers don't want to give that level of p
28.
by pwmtr 2y ago
Yes. :) We quite like k8s-based managed Postgres solutions. In fact, we convinced Patroni's author to come work with us in a previous gig at Microsoft. We find that a good number of companies successfully use k8s to manage Postgres for
29.
by pwmtr 2y ago
We want to ensure that the users are able to restore to any minute in the past. Then, as @pintxo, @bjornsing, and @Doxin asked below; Why not let users pick a time and then replay the closest backup? Why create empty backups? This is a vali
30.
by pwmtr 2y ago
At Ubicloud, we have ARM64 runners. They are compatible with Github Runners. It is just one line change in your workflow file. It is also 6x more cost effective than Github Runners (btw. our x64 runners are 10x more cost effective) More inf

More ›