From the course: Designing Highly Scalable and Highly Available SQL Databases

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Solution: Understanding database DevOps

Solution: Understanding database DevOps

From the course: Designing Highly Scalable and Highly Available SQL Databases

Start my 1-month free trial

Solution: Understanding database DevOps

“

(upbeat music) - [Instructor] Now there were a number of things that should be included in the DevOps strategy and set of practices. First of all, we should consider what kinds of metrics will we use to monitor the database? And we need to devise a logging strategy. We also need to include data growth with regards to our monitoring strategy so that we can understand what our data usage is going to be. Also, you're probably going to want to have a version control system. Now, if you have a team of software developers there's probably already one in place. So it makes sense to use one that exists. Now with databases, one of the specialized things around monitoring that we want to pay a particular attention to is monitoring queries that take the most resources because those are the ones that we want to optimize the most. And typically you can assume there's like an 80-20 rule that 80% of your resources compute memory…

Contents