Case study on VPC analysis
You are the Site Reliability Engineer (SRE) in charge of the availability of all the applications of a media company. Your company runs a streaming service where users watch movies, TV series, and other video content. You have been receiving reports from the support team that customers are noticing a decline in the speed at which the movies are loading for watching and from time to time, the video does not stream smoothly. After checking the application, you notice that the application runs fine but the application connects to Amazon Aurora PostgreSQL and you need to check how traffic goes and returns from the application to Amazon Aurora. What actions would you take to investigate this?
Solution
The first step is to create a VPC flow log, because both the application, which will most likely will be in EC2, and the Aurora database are both running on VPCs. Analyze the logs collected in either CloudWatch Logs or Amazon S3. Check the logs where the destination...