Morgan Tocker

Results 73 issues of Morgan Tocker

There is a possible race in acquiring locks the connection pool to threads +1: - The checksum acquires a LOCKS TABLES .. READ to start the RR connections for checksumming...

bug

We had a failure scenario where the pod was terminated but with a grace period waiting for the migration to complete. The networking on the pod had been shutdown but...

bug

The main goal of setting a target chunk time is to limit the maximum time row locks are held during chunk copies. Since chunk copies are performed in auto_commit the...

enhancement
for-future-development

It is expected that inserting into a larger table can slow down. This is particularly true if the table has unique indexes or is using Aurora (can't use insert buffer)....

enhancement
for-future-development

Usually the checksum phase takes about 10-20% of the time that the copier phase does. However, on some very IO bound cases I have noticed it take significantly longer. Much...

enhancement
for-future-development

Algorithmically we can support resuming from a source (old term: master) node failure. But we don't test it and thus don't advertise it. We should be able to do this....

enhancement

For spirit to survive aurora cutover, it should enable this option: https://github.com/go-sql-driver/mysql#rejectreadonly Otherwise, it can end up with a scenario where it reconnects too quickly on failover and keeps using...

enhancement

Currently we auto-select the `rds-ca-2019-root.pem` certificate if the hostname matches an RDS hostname. There's 2 problems with this: 1. Users may select a newer RDS certificate. 2. Users (outside of...

enhancement
help wanted

See if we can remove the canal library. We have quite a few workarounds around it. It might be better to use go-mysql directly instead.

enhancement
for-future-development

This is a regression from https://github.com/cashapp/spirit/pull/332 The binlog event it is waiting on looks to be a GTID event: ``` mysql> SHOW BINLOG EVENTS IN 'mysql-bin-changelog.002567' FROM 82282378 LIMIT 10;...

bug