Skip to content

Feature Request: tablets with type EXPERIMENTAL should be able to serve queries #20114

@ejortegau

Description

@ejortegau

Feature Description

It should be possible to send queries to tablets with type EXPERIMENTAL from vtgate.

Currently, tablets of type EXPERIMENTAL can't actually get queries routed to them from vtgate, which seems to be a consequence of PRIMARY/REPLICA/RDONLY being hard coded as the only tablet types that are can serve traffic. This is specified in at least two places:

When trying to query them, vtgate returns an error indicating No partition found for tabletType experimental in keyspace <keyspace_name>. This essentially makes the EXPERIMENTAL type only usable if you query vttablet directly via gRPC.

Use Case(s)

To test performance & correctness of new configuration and/or MySQL & vttablet versions, it would be useful to have EXPERIMENTAL tablets that can be queried if explicitly selected by the client, and compare with the real queries. While this could be done out of band by targeting vttablet directly, the queries would follow a different path and would therefore be harder to compare with the real ones.

Metadata

Metadata

Assignees

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions