cli icon indicating copy to clipboard operation
cli copied to clipboard

Add Option to Exclude Special Vitess Tables from dump command

Open orware opened this issue 3 years ago • 0 comments

Recently, I was using pscale database dump after submitting a deploy request that had dropped a table that had a significant amount of data and I was surprised to see that the dump included Vitess Schema Change Lifecycle tables that I wasn't expecting: https://vitess.io/docs/13.0/user-guides/schema-changes/table-lifecycle/

Example: image

After 24 hours had passed and those tables started working through the Vitess lifecycle, those unneeded tables eventually weren't included in the dump output anymore, but since the behavior is a bit unexpected/unneeded, it may be easier to automatically filter those tables out by default when using pscale database dump, and possibly add in an optional flag that would allow for the current behavior so they can be included again, if that's something that would be useful to have available, although at the moment I'm not sure if that would be something I would need as a user.

The expected output would have looked more like this for my example: image

orware avatar Jun 22 '22 17:06 orware