CompTIA DataSys+ (DS0-001)Database Management and MaintenanceHard
A database administrator is deploying a new version of their database management system (DBMS) to apply critical security patches and performance enhancements. The deployment process requires careful planning to minimize downtime and ensure data consistency. Which of the following patching strategies is BEST suited for an environment requiring high availability and zero downtime?
- ARolling upgrade
- BFull database rebuild
- COffline patching
- DIn-place upgrade
Show answer & explanationAnswer & explanation
Correct answer: A. Rolling upgrade
A rolling upgrade allows for patching and upgrading nodes in a cluster one at a time, ensuring that the database remains available and operational throughout the process, achieving near-zero downtime.
Why the other options are wrong
- B. A full database rebuild is an extreme measure usually for severe corruption or migration to a new architecture, and it involves significant downtime and data transfer.
- C. Offline patching explicitly means the database is unavailable during the patching process, which directly contradicts the requirement for high availability and zero downtime.
- D. In-place upgrades typically require the database to be taken offline during the upgrade process, leading to downtime.
Rolling Upgrade
A patching or upgrade strategy for clustered systems where components are updated sequentially, one at a time, allowing the overall system to remain operational throughout the process.
- Minimizes downtime for high-availability systems.
- Requires a clustered or replicated environment.
- Ensures continuous service availability during updates.
Memory trick: Rolling upgrades are like changing tires on a moving car.