PERF 9. How do you select the appropriate database solution for your system?

 

 

The optimal database solution for a particular system can vary based on requirements for consistency, availability, partition tolerance, and latency. Many systems use different database solutions for different sub-systems and enable different features to improve performance. Selecting the wrong database solution and features for a systems workload can lead to lower performance efficiency.
Best practices:
 Policy/Reference Architecture Select instance type and size based on predicted resource needs based on an internal governance standard.
 Cost/Budget Select instance type and size based on predicted resource needs based on internal cost controls.
 Benchmarking Load test a known workload on AWS and use that to estimate the best selection – testing a known performance benchmark vs. a known workload.
 Guidance from AWS or from an APN Partner Select a solution based on best practice advice.
 Load Test Deploy the latest version of your system on AWS using different instance types and sizes, use monitoring to capture performance metrics, and then make a selection based on a calculation of performance/cost.