go-sql-driver/mysql

Replication protocol

Open

#212 opened on Feb 6, 2014

View on GitHub
 (7 comments) (0 reactions) (0 assignees)Go (9,946 stars) (1,789 forks)batch import
enhancementhelp wanted

Description

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?

Contributor guide

Tech stack
gomysql
Domain
backenddatabase
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
4
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
over 1 week
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
mostly clear
Prerequisites
Go programmingMySQL replication protocol basics
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
15
Research direction
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.