Draft: Do not stick to primary when creating a container repository [RUN ALL RSPEC] [RUN AS-IF-FOSS]

What does this MR do?

This merge request attempts to reduce the primary database load coming from container registry authentication requests.

This endpoint is consistently in top 3 primary database consumers by json.db_primary_duration_s and by requests count.

Conformity

• I have included a changelog entry.
• Code review guidelines
• Merge request performance guidelines
• Separation of EE specific content