SShortSingh.
Back to feed

How to Resize AWS RDS Instances in Production Without Causing Downtime

0
·1 views

Resizing an Amazon RDS instance using the default in-place modification triggers 5 to 15 minutes of downtime as AWS reboots and migrates the database to a new host. To avoid this, engineers can use one of three zero-downtime strategies: RDS Blue/Green Deployments, read-replica promotion, or a Multi-AZ failover to a pre-resized standby. Blue/Green Deployments, now supported for MySQL, MariaDB, PostgreSQL, and SQL Server, is considered the preferred approach in 2026, with cutovers typically completing in under 60 seconds. Read-replica promotion suits older engine versions or cross-region scenarios, while the Multi-AZ failover method is best reserved for cases where neither other option is feasible. To reduce the need for emergency resizing altogether, AWS recommends monitoring Performance Insights weekly, using Graviton-based instance classes for better price-performance, and setting CloudWatch alarms to detect resource drift early.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Log in to join the discussion and vote.

Log in

Related stories

0
ProgrammingDEV Community ·

A 12-Month DevOps Career Roadmap for Beginners Targeting 2026 Job Market

A structured DevOps learning guide outlines a 9–12 month roadmap for beginners aiming to become job-ready, assuming 2–3 hours of daily study. The plan progresses through foundational Linux and networking skills, Git, Docker, CI/CD pipelines, and Kubernetes across sequential monthly milestones. Learners are then guided to gain deep expertise in a single cloud platform — AWS recommended for its job volume — and earn the AWS Certified Cloud Practitioner certification by month eight. Infrastructure-as-code using Terraform is highlighted as a key differentiator between junior and competitive DevOps candidates. The roadmap concludes with monitoring tools like Prometheus, Grafana, and the ELK Stack, alongside building portfolio projects that demonstrate end-to-end deployment pipelines.

0
ProgrammingDEV Community ·

Developer releases zero-dependency CVE scanner for Python and Node projects

A developer has released Depheal, an open-source vulnerability scanner designed for Python and Node.js projects that requires no external dependencies to run. The tool scans project dependencies for known CVEs and suggests safe upgrade versions, returning results in seconds. Its zero-dependency design addresses a common irony in security tooling, where scanners themselves introduce additional dependency risks. During testing, the developer discovered a real CVE in their own codebase, which was flagged within three seconds. The project is publicly available on GitHub under the username hunzo1.

0
ProgrammingDEV Community ·

One Mental Model That Makes Every Backtracking Problem Solvable

A software developer shares how years of memorizing individual backtracking solutions gave way to a single unifying insight: every backtracking problem is a decision tree navigated depth-first. The core pattern reduces to just three repeated steps — choose, explore, and un-choose — with the 'un-choose' step being the most commonly dropped and hardest to debug. Two silent bugs trip up most learners: forgetting to undo state changes between branches, and storing a mutable reference instead of a snapshot of the current path. The developer notes that classic problems like subsets, permutations, N-queens, and Sudoku all share this identical skeleton, differing only in what constitutes a valid choice, when recursion stops, and what can be pruned early. The key shift, they argue, is moving from memorizing solutions to understanding the tree structure, which makes adapting to any new variant straightforward.

0
ProgrammingDEV Community ·

Frontend dev ships first npm package 'daterly' using AI, now live in production

A frontend developer with three years of experience has published his first npm package, a React date picker called 'daterly', which is already deployed in internal projects at his company, Sima-Land. The package was built primarily using Claude Code and related AI tools, addressing recurring friction with an existing date picker that clashed with the team's react-hook-form workflow and design system. Daterly is built on react-day-picker v9 and date-fns v4, offering features like masked text input, locale and format customisation, optional time selection, and a separate RHF integration entry point to avoid unnecessary overhead. The developer notes that AI assistance was most effective for complex, self-contained algorithms, such as building a custom digit-only input mask with precise cursor restoration logic. The project was motivated not by a desire for npm downloads but by the need for a date picker that fits the team's consistent, shared tech stack, particularly for Russian-market requirements.

How to Resize AWS RDS Instances in Production Without Causing Downtime · ShortSingh