Environment
-
Need separate environments for Development, Testing, and Production.
-
Development & Testing will have some % of sample data from Production.
-
Testing and Production will have a similar HW environment. (Cloud / In house)
-
Nice to have a similar environment for development.
-
Track changes, indexes, and query changes are done in the lower environment.
-
DR environment is part of the Production release.
-
Suppose it's in-house; deploy it in different data centers. If it's cloud, deploy it in different regions.