Top all-time · #5347
code.openark.org
Personal blog · code.openark.org/blogdataprogramming
code.openark.org is a personal blog at code.openark.org about data and programming. Since 2009, 15 different Hacker News readers have linked it 17 times, most often “SQL pie chart”. The last post was in 2023, but the archive is still widely read.
Too few sampled comments (5) to say how often HN recommends it.?
Why HN links it
HN readers link this blog for MySQL high availability and automated failover, online schema migration, and foreign key trade-offs. Comments point to its orchestrator and gh-ost related posts.
Summarised by Claude from a sample of 5 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Most-linked posts?
- SQL pie chart4 people · 4 mentions · first linked 2009-08-12
- /blog/mysql/mysql-high-availability-tools-followup-the-missing-piece-orchestrator2 people · 2 mentions · first linked 2017-07-06
- The problem with MySQL foreign key constraints in Online Schema Changes (2021)2 people · 2 mentions · first linked 2023-12-21
What Hacker News says?
I think it's relevant that Baron's post mentions a Github incident, and Github has been doing automatic failover of MySQL masters for a while now: https://githubengineering.com/orchestrator-github/ This post is also very relevant to the topic: http://code.openark.org/blog/mysql/mysql-high-availability-t... The post you link is still relevant to this discussion, but we can't ignore that 5 years have passed. It would…
Comment linking /blog/mysql/mysql-high-availability-tools-followup-the-missing-piece-orchestrator
on “PostgreSQL HA cluster failure: a post-mortem”Submitted How not to test that mysqld is alive as a story · 65 points
HN discussionIndeed. It seems there are many such tools available for MySQL: Openark kit [0] for instance, whose author also brought us gh-ost. Unfortunately most tools focus on just MySQL, and none really have an answer when you want to use (and enforce) foreign key constraints. Although it's hard to say, I suspect the users of these tools have "given up" on foreign key constraints. [0] http://code.openark.org/forge/openark-kit…
Comment linking /forge/openark-kit
on “Managing database schema changes without downtime”Submitted The problem with MySQL foreign key constraints in Online Schema Changes (2021) as a story · 46 points
HN discussionAuthor of gh-ost here. Here are my thoughts on migrating to a different RDBMS: http://code.openark.org/blog/mysql/mysql-vs-postgresql-gh-os...
Comment linking /blog/mysql/mysql-vs-postgresql-gh-ost-perspective
on “GitHub's online schema migration for MySQL”Submitted SQL pie chart as a story · 10 points
HN discussionThe author of Orchestrator also goes into questions like that at http://code.openark.org/blog/mysql/mysql-high-availability-t... Tangentially, in that blog post I was impressed by the list of companies running orchestrator. > orchestrator is actively maintained by GitHub. It manages automated failovers at GitHub. It manages automated failovers at Booking.com, one of the largest MySQL setups on this planet. It manage…
Comment linking /blog/mysql/mysql-high-availability-tools-followup-the-missing-piece-orchestrator
on “MySQL infrastructure testing automation at GitHub”Submitted SQL Pie Chart as a story · 5 points
HN discussionThe responder to that issue has also written some blog posts that go into more detail on the subject. * https://code.openark.org/blog/mysql/things-that-dont-work-we... * https://code.openark.org/blog/mysql/the-problem-with-mysql-f...
Comment linking /blog/mysql/the-problem-with-mysql-foreign-key-constraints-in-online-schema-changes
on “Do you really need foreign keys?”Submitted Things that don’t work well with MySQL’s FOREIGN KEY implementation as a story · 3 points
HN discussionSubmitted Pie chart generator in SQL as a story · 3 points
HN discussionSubmitted Observations on the hashicorp/raft library, and notes on RDBMS as a story · 2 points
HN discussionSubmitted How to convince MySQL to use the right index as a story · 2 points
HN discussionSubmitted SQL Pie Chart as a story · 1 points
HN discussionSubmitted Making charts in SQL as a story · 1 points
HN discussionSubmitted Refactoring MySQL replication topologies visually as a story · 1 points
HN discussion
