Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Avni read db to medium and change in password for prod main #17

Closed
Tracked by #1479
petmongrels opened this issue Jan 5, 2024 · 2 comments
Closed
Tracked by #1479

Avni read db to medium and change in password for prod main #17

petmongrels opened this issue Jan 5, 2024 · 2 comments
Assignees

Comments

@petmongrels
Copy link
Contributor

petmongrels commented Jan 5, 2024

  • running queries on read db is becoming very slow and this must also be impacting the customers queries from reports
  • due to this I have been running queries on prod master which is not a good idea
  • the prod main password can be made confidential so that only few people have the password for it. this would force all database updates to go through a review process
@petmongrels petmongrels converted this from a draft issue Jan 5, 2024
@mahalakshme mahalakshme moved this from New Issues to Ready in Avni Product Jan 24, 2024
@vinayvenu vinayvenu moved this from Ready to In Progress in Avni Product Jan 25, 2024
@vinayvenu vinayvenu self-assigned this Jan 25, 2024
@vinayvenu
Copy link
Member

  • Read db moved to medium
  • prod main password change requires downtime for avni-server, avni-etl and avni-media. There are also other security issues that will need to be fixed to reduce the db login footprint. Moving it out of scope of this story

@vinayvenu
Copy link
Member

Added https://github.com/avniproject/avni-security/issues/83 to handle the items moved out of scope.

@vinayvenu vinayvenu moved this from In Progress to Done in Avni Product Jan 25, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Archived in project
Development

No branches or pull requests

2 participants