Hacker GitHub

← All repos

soundcloud/lhm

View on GitHub ↗ ★ 1,849 Ruby archived

Online MySQL schema migrations

13 mentions on Hacker News by 13 people: 2 stories, 11 comments · first 2011-05-05 · latest 2020-03-26

Mentions per year 13 mentions · busiest year 2012 (3)
20082026
AllStoriesComments NewestTopOldest
  1. …for MySQL. For PostgreSQL or others, the best option is taking a backwards compatible approach. https://github.com/soundcloud/lhm
    comment by matisoffn · 2020-03-26 · in Ask HN: Database migration on production without downtime
  2. …interested in only changing one table, i.e. adding/removing a column or an index, check out LHM: https://github.com/soundcloud/lhm I've used it in the past a lot. You have to make sure to throttle the migration, or else it'll max out your…
    comment by misterbowfinger · 2017-02-02 · in Online migrations at scale
  3. Apparently gh-ost won't work, but there are other tools that work fine on RDS: I've been using https://github.com/soundcloud/lhm On some fairly large tables (30 million + rows) without any problems
    comment by 33degrees · 2016-08-02 · in Gh-ost: GitHub's online schema migration tool for MySQL
  4. https://github.com/soundcloud/lhm Saved my life a few time :)
    comment by maximegarcia · 2016-07-26 · in Why Uber Engineering Switched from Postgres to MySQL
  5. …what database you're using. With MySQL, for example, you can do something like the process in lhm: https://github.com/soundcloud/lhm Zero-downtime deploys aren't super difficult in Rubyland anymore (many have written how they achieve it in…
    comment by holman · 2016-03-01 · in How to Deploy Software
  6. …flawlessly for some of our own tables with several hundred million rows (and no downtime). [1] https://github.com/soundcloud/lhm
    comment by dperfect · 2014-07-11 · in Zero-downtime database migrations
  7. > How would you then ever modify an existing database? You would use techniques like: https://github.com/soundcloud/large-hadron-migrator """ That is until your tables grow to millions of records. At this point, the locking nature of ALTER…
    comment by kanzure · 2013-06-16 · in The lack of proper “alter table” support in SQLite
  8. I've been eyeing Soundcloud's Large Hadron Migrator ( https://github.com/soundcloud/large-hadron-migrator ). I would love to see a Django/South specific implementation.
    comment by akoumjian · 2013-03-05 · in How Balanced Does Database Migrations With Zero Downtime
  9. We use https://github.com/soundcloud/large-hadron-migrator/
    comment by jnewland · 2012-09-14 · in GitHub availability this week
  10. Data migrations are done carefully with the Large Hadron Migrator Ruby gem: https://github.com/soundcloud/large-hadron-migrator . Facebook has a similar tool: https://www.facebook.com/note.php?note_id=430801045932
    comment by technoweenie · 2012-08-29 · in Deploying at GitHub
  11. …switches the two tables. The switching is not yet atomic, as there was a bug with RENAME TABLE. [1] https://github.com/soundcloud/large-hadron-migrator Edit: URL
    comment by lgierth · 2012-02-13 · in Rails migrations with no downtime