Day 22: Amazon RDS 🌊🔍
👋 Hello! I'm passionate about DevOps and have over 1+ years of experience in the field. I'm proficient in a variety of cutting-edge technologies and always motivated to expand my knowledge and skills. Let's connect and grow together!
SKILLS:
🔹 Languages & Runtimes: Python, Shell Scripting, HCL, YAML 🔹 Cloud Technologies: AWS, Microsoft Azure, GCP 🔹 Infrastructure Tools: Docker, Terraform, AWS CloudFormation 🔹 Other Tools: Linux, Git and GitHub Actions, Jenkins, Jira, GitLab (beginner), Docker, AWS DevOps 🔹 Web Development: HTML, CSS, Bootstrap, Python, SQL
Job & Responsibilities:
🚀 Improved development efficiency by implementing CI/CD pipelines, resulting in a 30% reduction in deployment time on the test server. 🔒 Strengthened deployment and testing reliability by utilizing Docker containers and optimizing Dockerfile, reducing development issues on the test server by 20%. ⚙️ Automated S3 bucket log creation with Shell scripting, eliminating 100% of manual search and saving 2 hours per week. 📅 Scheduled EC2 instance start/stop using Lambda functions and Event Bridge, leading to a 25% decrease in infrastructure costs. 🔧 Utilized AWS, Linux, Python, Docker, Shell scripting, Terraform, Jenkins Pipelines, and automation to streamline workflows and improve overall system performance.
I'm very detail-oriented and possess strong written and verbal communication skills. As a high performer with a possibility mindset, I strive to solve problems using efficient approaches.
Let's Connect & Grow:
If you find my profile suitable for the role you are searching for, please feel free to reach out to me at sumanprasad9766@gmail.com.
Introduction 🗺️🚢
Dive into the seas of Amazon RDS (Relational Database Service), where managed databases take the helm, steering through the SQL realm. Explore the advantages, scaling capabilities, and disaster recovery features that make RDS a sailor's delight.
Amazon RDS Overview 🚀💽
Relational Database Symphony
RDS, or Relational Database Service, orchestrates databases in the cloud with seamless management for SQL-based databases:
Postgres
MySQL
MariaDB
Oracle
Microsoft SQL Server
Aurora (AWS Proprietary database)
Advantage over using RDS versus deploying DB on EC2 🛡️🔧
The Managed Advantage
Choosing RDS over manual deployment on EC2 comes with perks:
Automated provisioning and OS patching
Continuous backups with point-in-time restore
Monitoring dashboards for insight
Read replicas for enhanced read performance
Multi-AZ setup for Disaster Recovery (DR)
Hassle-free scaling (vertical and horizontal)
RDS – Storage Auto Scaling 🔄📈
Dynamic Storage Solutions
RDS Storage Auto Scaling ensures your database storage scales dynamically, preventing manual interventions. By setting maximum storage thresholds, RDS automatically adjusts storage when free storage is low, enhancing adaptability to unpredictable workloads.
RDS Read Replicas for Read Scalability 📚🔄
Replica Symphony
RDS Read Replicas bring harmony to read scalability:
Up to 15 Read Replicas within AZ, Cross AZ, or Cross Region
ASYNC replication ensures eventual consistency
Replicas can be promoted to standalone DBs
Ideal for read-heavy workloads, keeping the production DB unaffected
RDS Multi AZ (Disaster Recovery) ☂️🔄
Disaster-Proofing
RDS Multi AZ ensures disaster recovery with synchronous replication:
SYNC replication for automatic failover
Enhances availability, guarding against AZ, network, or instance failures
Read Replicas can be part of Multi AZ setup for DR
RDS Custom 🧰🛠️
Tailored Database Experience
For the ultimate customization, RDS Custom offers access to OS and database settings:
Managed Oracle and Microsoft SQL Server with customization
Full admin access to the underlying OS and database
Configure settings, install patches, enable native features
Access the underlying EC2 Instance using SSH or SSM Session Manager
Conclusion 🌊⚓
In the vast ocean of AWS, Amazon RDS emerges as a captain, steering your databases with finesse. With advantages, scalability, and disaster recovery features, RDS sets sail to make your database management voyage a breeze. ⛵🌐
