News for hackers. Stuff that matters.
Re:The database servers powering Let's Encrypt by ryanworl on Thursday January 21, 2021 @01:35PM (#25862269)
What are they storing on this server that requires 150Tb of storage and millions of IOPS?
Re:The database servers powering Let's Encrypt by dewey on Thursday January 21, 2021 @01:38PM (#25862301)
> What exactly are we doing with these servers? Our CA software, Boulder, uses MySQL-style schemas and queries to manage subscriber accounts and the entire certificate issuance process.
Re:The database servers powering Let's Encrypt by jeffbee on Thursday January 21, 2021 @02:25PM (#25862966)
There's nothing in that sentence that implies they'd need even 100 IOPS, much less 20 million.
Re:The database servers powering Let's Encrypt by gbrown_ on Thursday January 21, 2021 @03:17PM (#25863655)
The post doesn't specify requirements or application level targets for performance. They show a couple of good latency improvements but don't describe the business or technical impact. The closest we get is this.

> If this database isn’t performing well enough, it can cause API errors and timeouts for our subscribers.

What are the SLO's? How was this being met (or not) before vs after the hardware upgrade? There's a lot of additional context that could have been added in this post. It's not a bad post but instead it simply reduces down to this new hardware is faster than our old hardware.

Re:The database servers powering Let's Encrypt by stefan_ on Thursday January 21, 2021 @03:55PM (#25864120)
What exactly needs to be stored once the certificate is created and published in the hash tree? It seems like the kind of data that possibly needn't be stored at all or onto something like Glacier for archival.
Re:The database servers powering Let's Encrypt by Conclusionist on Thursday January 21, 2021 @04:03PM (#25864207)
Going to guess it's for OCSP responses.
Re:The database servers powering Let's Encrypt by siwyd on Thursday January 21, 2021 @04:53PM (#25864912)
FYI, the intermediate CA's signed by their new Root X2 certificate won't have OCSP URLs anymore.

Source: https://letsencrypt.org/2020/09/17/new-root-and-intermediate...

Re:The database servers powering Let's Encrypt by cipherboy on Thursday January 21, 2021 @05:05PM (#25865055)
AFAIK, nobody has suggested removal of OCSP from end-entity certificates. This article you linked (and the comment you wrote) is purely about removal from intermediate CA certificates.

The majority of OCSP traffic will probably be for end-entity certificates; most OCSP validation (in browsers and cryptographic libraries) is end-entity validation, not leaf-and-chain.

Removal of intermediate CA's OCSP is probably not really relevant to their overall OCSP performance numbers (and if it was, it was likely cached already).

Re:The database servers powering Let's Encrypt by tialaramex on Friday January 22, 2021 @01:53AM (#25869147)
There's an argument for not doing OCSP on end-entity certificates if you can approach the lifetime for the certificates that you'd realistically need for OCSP responses anyway.

Suppose you promise to issue OCSP revocations within 48 hours if it's urgent, and your OCSP responses are valid for 48 hours. That means after a problem happens OCSP revocation takes up to 96 hours to be effective.

If you only issue certificates with lifetimes of 96 hours then OCSP didn't add anything valuable - the certificates expire before they can effectively be revoked anyway.

Let's Encrypt is much closer to this idea (90 days) than many issuers were when it started (offering typically 1-3 years) but not quite close enough to argue revocation isn't valuable. However, the automation Let's Encrypt strongly encourages makes shortening lifetimes practical. Many of us have Let's Encrypt certs automated enough that if they renewed every 48 hours instead of every 60 days we'd barely care.

The solution to excessive OCSP traffic and privacy risk is supposed to be OCSP stapling instead, but TLS servers that can't get stapling right are still ridiculously popular so that hasn't gone so well.

Re:The database servers powering Let's Encrypt by stefan_ on Thursday January 21, 2021 @04:27PM (#25864505)
I'm not sure, e.g. Chrome doesn't do OCSP by default, lots of embedded clients like curl won't either. Unless the protocol is terribly broken, that also seems like the kind of use case where 99% of queries just come out of cache and should never hit a database.
Re:The database servers powering Let's Encrypt by tialaramex on Friday January 22, 2021 @01:36AM (#25869045)
Let's Encrypt still has to publish OCSP responses for every non-expired leaf certificate, at least in time that you can always get a new OCSP response before the previous one expires. In practice they have a tighter schedule so that there's a period between "We are not meeting our self-imposed deadline" and "The Internet broke, oops" in which staff can figure out the problem and fix it.

To do this they automatically generate and sign OCSP responses (the vast majority of which will just say the certificate is still good) on a periodic cycle, and then they deliver them in bulk to a CDN. The CDN is who your client (or server if you do OCSP stapling, which you ideally should) talks to when checking OCSP.

To generate those responses they need a way (hey, a database) to get the set of all certificates which have not yet expired and whether those certificates are revoked or not.

Re:The database servers powering Let's Encrypt by abrookewood on Thursday January 21, 2021 @05:28PM (#25865369)
My thoughts exactly ... They are creating and storing text. Only thing I can think is that they don't actually need the storage, but just want the lowest possible latency by having a large number of drives.
Re:The database servers powering Let's Encrypt by ksec on Thursday January 21, 2021 @07:22PM (#25866646)
Well if Latency were an issue or something they like to lower they should have chosen Optane.
Re:The database servers powering Let's Encrypt by ptrwis on Thursday January 21, 2021 @09:44PM (#25867676)
Let's say they maxed out their former storage capacity of 24x3.8[TB]. For these 235millions of websites as they claim it's around 400kB per website.