CompTIA DataSys+ (DS0-001)Database Management and MaintenanceMedium
A database administrator is tasked with setting up a new production database server for an application that requires high availability and minimal downtime for maintenance. They need a strategy to apply database patches and upgrades without taking the entire system offline. Which deployment strategy best fits these requirements?
- ABig Bang Deployment
- BBlue/Green Deployment
- CRolling Deployment
- DCanary Deployment
Show answer & explanationAnswer & explanation
Correct answer: C. Rolling Deployment
Rolling deployment allows updates to be applied to a subset of servers at a time, gradually updating the entire cluster while maintaining overall service availability. This minimizes downtime for maintenance tasks like patching and upgrades.
Why the other options are wrong
- A. Big Bang deployment involves taking the entire system offline for the update, resulting in significant downtime.
- B. Blue/Green deployment involves running two identical environments and switching traffic, often used for application code, but can be complex for databases if state needs to be synchronized.
- D. Canary deployment releases changes to a small subset of users to test before full rollout, primarily for application features, not typically for full database patching without downtime.
Rolling Deployment
A deployment strategy where application or database updates are applied incrementally to a subset of servers or nodes at a time, ensuring continuous availability.
- Minimizes downtime during updates.
- Requires a clustered or distributed architecture.
- Allows for rollback if issues are detected.
Memory trick: Roll through the updates, keep the lights on.