so...now table-reorg is in 6.4.
pushbuild found a few problems...that are fixed.
what is left:
1) detailed test-prg (which will check consistency after each step, by pausing schema-trans)
2) handling of cluster-crash during reorg
only way right now, is to restore a backup if you get crash during reorg
3) node failure during might cause SUMA to not scan some fragments
(this bug is an old one, existing in 4.1, that also affect unique index build)
4) reorg-abort (in certain state) leaves REORG_MOVED bit on records,
cause subsequent reorgs (to different partitioning) to create inconsistent data.
Not too bad...
I do however think it's quite testable (although maybe not extremely interesting wo/ add node)
Will start on add-node...and fix problems above in parallel
How ProxySQL deal with schema (and schemaname) Long story - This article is the spin-off of the article How ProxySQL deal with schema (and schemaname) 1 How ProxySQL differes from MySQL in managing explicit default ...
1 week ago