search

canonical / mysql-router-operator

Mysql router operator charm
https://charmhub.io/mysql-router?channel=dpe/edge
Apache License 2.0
3 stars 3 forks source link

DPE-4643 Limit username to 32chars #151

Closed paulomach closed 2 months ago

paulomach commented 2 months ago

Issue

New server format for username can lead to bigger than 32 chars.

Solution

Ensure generated username is not bigger than 32 chars.

carlcsaposs-canonical commented 2 months ago

also I think a migration may be required to support upgrades, since _get_username is also used to clean up user

carlcsaposs-canonical commented 2 months ago

also I think a migration may be required to support upgrades, since _get_username is also used to clean up user

alternatively, if server can truncate to like <=28 characters or something, a migration would not be needed on router

it might be worth considering something like relation-4-432e5b on server

carlcsaposs-canonical commented 2 months ago

same thoughts as before (https://github.com/canonical/mysql-router-operator/pull/151#issuecomment-2182182755):

would it be possible for server to truncate to 24-26 characters (or less) so that upgrade migration is not needed on router?

paulomach commented 2 months ago

Closing as solution is server side only