A safe MySQL upgrade that wasn't so safe

(blog.elis.cc)

28 points | by el1s7 5 hours ago

2 comments

  • Insimwytim 1 hour ago
    That's kinda fun (not in a fun way).

    Since the update is done semi-automatically by the means of AWS RDS, does AWS takes any responsibility for that? Unless this use case is warned against in migration notes, I would think they ought to.

  • krautburglar 1 hour ago
    Mixing binlog formats across replicas sounds like user error to me.
    • rf15 1 hour ago
      Or the use of AUTO_INCREMENT, a feature which is already a footgun if implemented badly (as it clearly was)
      • b112 37 minutes ago
        Agreed, and SQL is as important to fully understand, as when, for example, writing C. An inept usage of it, can lead to complete and total disaster.

        You wouldn't want a junior to write (unreviewed) an internet connected daemon. Or to try to meet a complex RFC spec. Yet SQL? Why not?!

        I think one of the greatest disservices people have done, is to abstract away SQL in frameworks. It certainly lets juniors more safely work with databases, but it really has reduced the general SQL knowledge out there. I see many senior programmers, with almost no exposure. Never touched it.