bddicken

7 ms·

1. 61.▲
   by bddicken 2y ago

   Yeah I think the visuals really add to this one, especially given the time element of explaining latencies.
2. 62.▲
   by bddicken 2y ago

   Interesting! Any errors you can report? Should work in safari but maybe you have something custom going on, or an older version?
3. 63.▲
   by bddicken 2y ago

   Thank you!
4. 64.▲
   by bddicken 2y ago

   For PlanetScale Metal, we use semi-sync replication. The primary need to get an ack from at least one replica before committing.
5. 65.▲
   by bddicken 2y ago

   Thank you! The visuals definitely add something special to this post specifically since time is a big element in explaining latencies.
6. 66.▲
   by bddicken 2y ago

   Technically any drive has a finite IOPS capacity. We have found that no matter how hard we tried, we could not get MySQL to exhaust the max IOPS of the underlying hardware. You hit CPU limits long before hitting IOPS limits. Thus "infi
7. 67.▲
   by bddicken 2y ago

   Whoah, thanks for sharing the paper.
8. 68.▲
   by bddicken 2y ago

   Bartosz Ciechanowski is incredible at this type of stuff. Sam Rose has some great interactive blogs too. Both have had big hits here on HN.
9. 69.▲
   by bddicken 2y ago

   Interesting. Running any chrome extensions that might be messing with things? Alternatively, if you can share any errors you're getting in the console lmk.
10. 70.▲
    by bddicken 2y ago

    Ohhh interesting! Obviously not ideal, but I guess just an extension issue?
11. 71.▲
    by bddicken 2y ago

    That database architects blog is a great read.
12. 72.▲
    by bddicken 2y ago

    Thank you for the info! Do you have any good references on this for those who want to learn more?
13. 73.▲
    by bddicken 2y ago

    It would be incredibly cool if this were used in high school curricula.
14. 74.▲
    by bddicken 2y ago

    For this particular one I used d3.js, but honestly this isn't really the type of thing it's designed for. I've also used GSAP for this type of thing on this article I wrote about database sharding. https://planetsc
15. 75.▲
    by bddicken 2y ago

    You are welcome!
16. 76.▲
    by bddicken 2y ago

    > Your "1 in a million" comment on durability is certainly too pessimistic once you consider the briefness of the downtime before a new server comes in and re-replicates everything, right? Absolutely. Our actual durability is f
17. 77.▲
    by bddicken 2y ago

    The nerdbaiting will now provide generational benefit!
18. 78.▲
    by bddicken 2y ago

    I heavily, heavily abused d3.js to build these.
19. 79.▲
    by bddicken 2y ago

    I respect it. In my very biased opinion, it's worth enabling for this article.
20. 80.▲
    by bddicken 2y ago

    Thank you! I started this back in October, but of course have worked on plenty of other things in the meantime. But this was easily 200+ hours of work spread out over that time. If this helps as context, the git diff for merging this into o
21. 81.▲
    by bddicken 2y ago

    The visuals add a lot to this article. A big theme throughout is latency, and the visual help the reader see why tape is slower than an hdd, which is slower than an ssd, etc. Also, its just plain fun! I'm curious, what do you do on the
22. 82.▲
    by bddicken 2y ago

    Author of the blog here. I had a great time writing this. By far the most complex article I've ever put together, with literally thousands of lines of js to build out these interactive visuals. I hope everyone enjoys.
23. 83.▲
    An Interactive Guide to Database Sharding(planetscale.com)

    1 points by bddicken 2y ago|0 comments
24. 84.▲
    Hard Drive Graveyard(benjdd.com)

    7 points by bddicken 2y ago|0 comments
25. 85.▲
    by bddicken 2y ago

    OP here - thank you! I'd actually like to more in the future with your data sets. It's so cool that you publish this.
26. 86.▲
    by bddicken 2y ago

    I'd like to do another vis that includes failed drives. Please, keep helping me brainstorm.
27. 87.▲
    by bddicken 2y ago

    Great suggestion.
28. 88.▲
    by bddicken 2y ago

    Yeah, when drives fall off the bottom that represents decommissioning.
29. 89.▲
    by bddicken 2y ago

    Thats good feedback. It definitely gets crowded, and sluggish due to the number of dom nodes. I didn't spend much time optimizing performance.
30. 90.▲
    by bddicken 2y ago

    [OP] Interesting! I just tested it on Android/FF and it works. Could be a version-specific thing. Could also be just taking awhile to load (it has to download a 32MB json file).