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

(7 comments) (0 reactions) (0 assignees)Go (9,946 stars) (1,789 forks)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
Issue 種別: 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.