Replication protocol · go-sql-driver/mysql#212

(7 评论) (0 反应) (0 负责人)Go (9,946 star) (1,789 fork)batch import

enhancementhelp wanted

描述

I found a fork that implements the replication protocol.

I'm not sure how complete it is. Unfortunately it works off a version of the MySQL driver that is at least a year out of date. My knowledge of the MySQL wire protocol is lacking. I've noticed the writeCommandPacket is quite a bit different.

I'm interested in this because I need a way to update ElasticSearch in real time. Using the replication protocol is attractive because I can turn on/off the syncing and have it pick up where it left off. The current solutions poll MySQL for data, and are more or less straight copies. Also my target (search optimized) data for ElasticSearch is quite a bit different than my MySQL source table.

Would there be any interest in having this feature?

贡献者指南

技术栈: gomysql
领域: backenddatabase
议题类型: feature
难度: 4
预计时间: over 1 week
活动状态: stale
清晰度: mostly clear
前置要求: Go programmingMySQL replication protocol basics
新手友好度: 15
研究方向: Review the referenced fork at https://github.com/dylanahsmith/go mysql binlog and the MySQL replication protocol documentation at http://dev.mysql.com/doc/internals/en/replication protocol.html. Assess the differences between the fork's approach and the current driver version, particularly the writeCommandPacket function. Consider how to integrate this as a new feature in the existing driver without breaking compatibility. Engage with maintainers to get feedback on the desired scope and acceptance criteria.