open up a WIP! I'd love to see it.

Cool, will try it.

very happy to stretch Maxwell out a bit. postgres has long been on my wishlist too.

Oh, nice, then it totally makes sense to do something with Vitess.

Obviously all the schema-storage-fu is all different.

It is actually really nice in VStream: they send you the schema within the stream before an event that uses that schema. Like, before getting a change event for a table X, you get a full schema for that table with all the data you need. So, at least for the stuff I've been doing, I have not encountered any need to to go MySQL for any schema-related stuff.

How does vitess do positions?

Pretty cool as well: they send you VTGID events with each transaction, which is a complex data structure that describes stream position across all the shards you're following (each shard is a separate MySQL cluster, so the VTGID has a GTID value for that specific cluster). Here is a simple example from my local dev environment:

    {
      "type": "VGTID",
      "vgtid": {
        "shardGtids": [
          {
            "keyspace": "commerce",
            "shard": "0",
            "gtid": "MySQL56/3a37ee54-5705-11ed-a848-db61527a6db3:1-1664"
          }
        ]
      },
      "keyspace": "commerce",
      "shard": "0"
    }

Connect to Vitess #1757

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions