search

vitessio / vitess

Vitess is a database clustering system for horizontal scaling of MySQL.
http://vitess.io
Apache License 2.0
18.53k stars 2.09k forks source link

Feature Request: Allow cross cell promotion in PRS #16460

Closed GuptaManan100 closed 2 months ago

GuptaManan100 commented 2 months ago

Feature Description

If the users want to promote a replica in a different cell than the current primary using PlannedReparentShard, they have to specify the new primary with the --new-primary flag.

It would be nice to have the capability for PRS to be able to auto-select a replica from a different cell too.

Use Case(s)

If you're running a mode wherein you have multiple tablets in different cells, and you want to reparent away from the current primary, and you want to allow PRS to be able to choose the best candidate from all the possible cells, then this new feature is required.

arthurschreiber commented 2 months ago

This seems like a duplicate of https://github.com/vitessio/vitess/issues/15846. 😬

Super happy to see this was tackled. Thanks @GuptaManan100 for the great work!

GuptaManan100 commented 2 months ago

You're welcome ❤️