I am trying to consolidate databases used in our application as of now we have 10 rds (small) instances and users created during RDS creation.
Now we see there are plans to add 20+ application this year and we don't want to have additional 20 RDS instances.
Instead we are looking to consolidate as a big Single RDS instances and create 40 database and give access based on application.
Looking for opinions and steps on following:
- Will there be degradation of performance if we consolidate?
- How user creation is managed since I don't want use shared creds created during RDS creation
- Is there a better approach to manage users automatically?
- Some wiki or docs to get started
Your thoughts will be really helpful.