Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feature Request: MoveTables support for auto replacing auto_inc cols with sequences #16864

Closed
mattlord opened this issue Sep 30, 2024 · 1 comment · Fixed by #16860
Closed

Comments

@mattlord
Copy link
Contributor

Feature Description

Since #15679 we automatically strip any MySQL auto_increment clauses on tables that are being moved (using the MoveTables command) from an unsharded keyspace to a sharded one. And since #13656 we support initializing any sequences in the target keyspace on SwitchTraffic.

It would be really nice if we also supported automatically replacing those MySQL auto_increment clauses with Vitess sequences. This would eliminate a fair amount of toil and potential for mistakes.

Use Case(s)

Moving tables from an unsharded to a sharded keyspace, which is common e.g. when initialing migrating into Vitess. And one initial hurdle is moving from MySQL managed auto_increment values in the MySQL schema to Vitess managed AutoIncrement values in the Vitess vschema.

@arthurschreiber
Copy link
Contributor

Yes, this would be really really great.

@github-project-automation github-project-automation bot moved this from In progress to Done in VReplication Oct 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: Done
Development

Successfully merging a pull request may close this issue.

2 participants