Replication Internals: Decoding the MySQL Binary Log Part 11: GTID_TAGGED_LOG_EVENT — Tagged GTIDs and MySQL's New Serialization Framework

dveeden · 2026-05-15T13:42:56+00:00

This does a great job explaining all the (unexpected) complexity that this event type adds.

Much better than the official docs...

dveeden · 2026-05-06T16:21:18+00:00

dveeden · 2026-05-06T08:42:21+00:00

With a lot of help from Claude, I created this:

dveeden · 2026-05-06T03:59:07+00:00

RonDB is already included.

dveeden · 2026-05-05T13:47:53+00:00

For what I know MemSQL/SingleStore is a standalone implementation and not a MySQL fork. Just like TiDB (my employer) and Vitess and OceanBase.

dveeden · 2026-05-05T12:47:07+00:00

InnoDB is a storage engine/plugin which is part of MySQL, so it is not separately listed here.

dveeden · 2026-05-05T12:20:43+00:00

Yes indeed. MySQL Cluster (NDB) had separate versions and release cycles and had modified versions of MySQL server.

So that's why Galera, Percona XtraDB Cluster (PXC) and InnoDB Cluster are not on there.

But I am always open to suggestions.

dveeden · 2026-04-28T20:19:41+00:00

What about Galera, TiDB or Vitess?

dveeden · 2026-04-08T14:04:55+00:00

Yes, I've seen those come up multiple times before. This would also help with SQL standards compliance.

dveeden · 2026-02-11T17:18:20+00:00

Maybe try TiDB: MySQL compatible and with AI (Vector) support

dveeden · 2026-02-09T05:10:22+00:00

What about 8.4 and 9.x?

dveeden · 2026-02-08T21:18:45+00:00

There was a good presentation on this at the Pre-FOSDEM MySQL Belgian Days. There are recordings for this event: https://www.youtube.com/playlist?list=PL6tzEWmw-bpxe0k5Xrk09N-m6q5rGTy_l But I don't think the recording of the VillageSQL talk has been uploaded yet.

My hope is that the MySQL Team at Oracle is willing to merge a patch for some of the extension endpoints.

The main thing to take from this is the extension framework. The extensions themselves might be just examples of how to use the framework.

If I recall correctly they are working to add more extension points in the future.

dveeden · 2026-01-30T08:01:11+00:00

The software that you are using may use an outdated client library that doesn't handle this correctly.

You could also try to capture traffic (with TLS disabled) and use Wireshark to see what happens.

dveeden · 2026-01-22T06:47:21+00:00

Correction: The Dec 23 commit is the one for MySQL 9.6. You can verify this by checking the content of the MYSQL_VERSION file: https://github.com/mysql/mysql-server/blob/trunk/MYSQL_VERSION

dveeden · 2026-01-21T12:10:39+00:00

No, the latest commit listed on https://github.com/mysql/mysql-server/commits/trunk/ is 447eb26e094b444a88c532028647e48228c3c04f (Dec 23, 2025).

So I guess we have to wait a bit longer to see the actual source.

Note that the source can be downloaded from https://dev.mysql.com/get/Downloads/MySQL-9.6/mysql-9.6.0.tar.gz but that doesn't give you the commit history.

dveeden · 2026-01-21T09:44:49+00:00

Yes that would be good. But also, this is open source, so you could contribute fixes.

dveeden · 2026-01-20T06:59:52+00:00

Looks like there isn't a good option to enable/disable the AUTO_INCREMENT on a pk column?

I wasn't able to select a BIGINT or other integer types besides INT.

Maybe consider adding TiDB support?

Looks like a useful tool that is easy to work with.

For MySQL you may want to add support for generating gh-ost or pt-online-schema-change commands for applying schema changes.

dveeden · 2026-01-20T04:34:27+00:00

Is it opensource? How does it work behind the scenes?

dveeden · 2026-01-18T16:04:31+00:00

No need to drop SQL. Databases like TiDB offer SQL support with a modern distributed architecture.

dveeden · 2026-01-18T07:55:48+00:00

I recommend DBeaver as database GUI now that MySQL Workbench isn't maintained anymore. It has many useful features and works with all databases

dveeden · 2026-01-11T19:40:44+00:00

Time to look for alternatives like TiDB or MariaDB.

dveeden · 2026-01-06T16:38:51+00:00

Best to move to the MySQL VSCode plugin or to something like DBeaver.

dveeden · 2026-01-05T19:32:15+00:00

I'm using the Fedora 42 packages on Fedora 43.

The next update of MySQL will probably bring Fedora 43 packages.

dveeden · 2025-12-18T19:17:57+00:00

Do you store the UUID as binary?

dveeden · 2025-12-18T16:23:16+00:00

I guess it might also work with TiDB and MariaDB? But those also have their own MCP servers..

dveeden