What is the convention/best practice store the database related information
I would like to know the convention/best practice that is followed in the puppet managed projects for storing database information.
Do you store it in YAML/JSON to be called in hiera or in Consul?
How do you store secrets like username/password for DB in keys?
Please suggest some best mechanisms and examples if any.