68°F

Aaron Parecki

  • Articles
  • Notes
  • Photos

#databases

  • Kyle Mahan https://kylewm.com

    Antipatterns antipattern

    Portland, Oregon
    #indieweb #databases #drama #wiki
    Sun, Sep 21, 2014 12:22am -07:00 (liked on Sun, Oct 9, 2016 2:07pm -07:00)
  • Mysql slave server-id selection (www.semicomplete.com)
    Two slaves with the same server id will replicate successfully, but when they reach the end of the master's binary log, something freaks out and forces them to disconnect. This causes both slaves to reconnect, sync (no data needed), and have the connection die off quickly again. The result of this is rapid connection/disconnection by both slaves driving the load to 1+ on both slaves, and to around .3 on the master even in a completely idle system. This is bad. Therefore, server id collisions are bad.
    #databases #mysql #replication
    Sat, May 25, 2013 5:38pm -07:00
  • Joins are fast (stackoverflow.com)
    Joins are fast. Joins should be considered standard practice with a properly normalized database schema. Don't fear the join. It's true that join performance degrades non-linearly as the size of the data set increases. Therefore, it doesn't scale as nicely as single table queries, but it still does scale. It's also true that a bird flies faster without any wings, but only straight down.
    #databases #JOIN #mysql #scaling
    Sun, Jun 19, 2011 6:32pm -07:00
  • MySQL Slave Lag (Delay) Explained And 7 Ways To Battle It (beerpla.net)
    #databases #mysql #scaling #servers
    Sun, May 15, 2011 11:48am -07:00
  • MySQL :: MySQL 5.0 Reference Manual :: 7.4.4 How MySQL Uses Indexes (dev.mysql.com)
    #databases #indexes #mysql #performance
    Sat, May 29, 2010 10:55am -07:00
  • The Apache Cassandra Project (cassandra.apache.org)
    #apache #cassandra #cloud #data #databases #linux #programming #web
    Wed, Apr 14, 2010 9:52am -07:00
next

Hi, I'm Aaron Parecki, Senior Security Architect at Okta, and co-founder of IndieWebCamp. I maintain oauth.net, write and consult about OAuth, and participate in the OAuth Working Group at the IETF. I also help people learn about video production and livestreaming and dabble in product design.

I've been tracking my location since 2008 and I wrote 100 songs in 100 days. I've spoken at conferences around the world about owning your data, OAuth, quantified self, and explained why R is a vowel. Read more.

  • Security Architect at Okta
  • IndieWebCamp Founder
  • OAuth WG Member

  • 🎥 YouTube Tutorials and Reviews
  • 🏠 We're building a triplex!
  • ⭐️ Life Stack
  • ⚙️ Home Automation
  • All
  • Articles
  • Bookmarks
  • Notes
  • Photos
  • Replies
  • Reviews
  • Trips
  • Videos
  • Contact
© 1999-2023 by Aaron Parecki. Powered by p3k. This site supports Webmention.
Except where otherwise noted, text content on this site is licensed under a Creative Commons Attribution 3.0 License.
IndieWebCamp Microformats Webmention W3C HTML5 Creative Commons
WeChat ID
aaronpk_tv