Automating Amazon RDS backup and maintenance windows for Daylight Saving Time shifts | Amazon Web Services

Automating Amazon RDS backup and maintenance windows for Daylight Saving Time shifts | Amazon Web Services

Twice a year, some database administrators face the same tedious task: manually adjusting Amazon Relational Database Service (Amazon RDS) backup and maintenance schedules across multiple instances when Daylight Saving Time (DST) begins or ends. Because RDS operates on Coordinated Universal Time (UTC) while backup and maintenance schedules often reflect local time zones, each spring and fall, DST shifts create misalignment between intended schedules and actual execution times, which shifts maintenance windows by an hour and potentially disrupting planned activities during critical business hours. When you add the complexity of cron jobs operating on local system time while RDS maintains UTC, you face risks of missed backups, maintenance occurring during business hours, and compliance violations. By automating RDS backup and maintenance windows to adjust to time shifts, it eliminates manual DST adjustments and you’ll have consistent database operations across DST…

https://aws.amazon.com/blogs/database/automating-amazon-rds-backup-and-maintenance-windows-for-daylight-saving-time-shifts/