TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Ruby-binlog based MySQL replication listener

27 点作者 dpaluy超过 12 年前

3 条评论

jenseng超过 12 年前
This looks promising. The MySQL -&#62; Postgres replication possibilities are particularly interesting for people looking to switch over a huge database with (almost) zero downtime.<p>At Instructure we essentially did this last year when we made the switch. We loaded in the initial dataset using pygmy (<a href="https://github.com/instructure/pygmy" rel="nofollow">https://github.com/instructure/pygmy</a> ... basically a wrapper around COPY and friends) and then used a kodama-like script to keep it in sync until we pulled the trigger. We haven't open sourced the replicator yet, as it's a shameful hack ... we were doing statement-based replication, which makes query translation super brittle (yay regexes!) if you do much beyond basic ORM stuff, due to differences between the two dbs.<p>No matter how you go about it, there are lots of little gotchas like updating your sequences, converting tinyints to booleans, etc. Should be interesting to see where this project goes, since MySQL -&#62; Postgres is the current trend.
评论 #4859543 未加载
noplay超过 12 年前
A similar work in progress project for Python: <a href="https://github.com/noplay/python-mysql-replication" rel="nofollow">https://github.com/noplay/python-mysql-replication</a><p>It's fun to see we are working on similar project in the same time.
评论 #4860312 未加载
sonier超过 12 年前
This is great, would love to use it to keep MySQL and hive in sync. I will play around with this soon, thanks for the great gem!