...
We are running MySQL 5.5.12. Dev / test stacks can use , either as a local MySQL installation , staging and production stacks use (dev, test), or using Amazon's RDS service (staging and production). Currently, both stacks use different databases in the same RDS instance.
New Stack Database Configuration
...
- Create a new db user <stack><instance>User
- Generate a unique password for that user, important to not share passwords to decrease chances of accidently stomping on the wrong data. On windows, I use KeePass to generate a 40-bit hex key.
- Generate a unique encryption key for the user. Here use a 128-bit hex key. Update /gluster/work/platform/PasswordsAndCredentials/StackCredentials/IAMUsers/credentials.csv on sodo with appropriate security info.
- Create the schema <stack><instance>
- For staging / prod systems, grant the user ability to SELECT and INSERT on the common idGeneratorDB schema
- Grant the user all permissions except GRANT OPTION, CREATE ROUTINE, ALTER ROUTINE, and TRIGGER on their own schema
- Important: do not hand out this use to multiple instances
...