Jignesh Shah’s Post

Amazon RDS Multi-AZ DB Clusters now support C6gd - a new database instance type. C6gd is an ideal candidate for cost optimizing dev/test workloads on RDS Multi-AZ DB Clusters. Read our announcement for more details #rds #performance #availability #multi_az_db_cluster

Step-by-step instructions on how to migrate an AWS RDS for MySQL to #HeatWave MySQL database with minimal downtime: https://lnkd.in/eKkF74QF

Setup and Configure PostgreSQL 17.2 on AWS RDS #postgresql #postgresql17 #awsrds #cloudatabase #awsrdspostgresql https://lnkd.in/ggz4QD_v

Ready to break free from vendor lock-in and achieve a truly open-source PostgreSQL migration on AWS? Leveraging our experience migrating dozens of customers and our innovative sct-migrator tool, we'll help you ditch AWS SCT extension packs and migrate to a performant, future-proof PostgreSQL compatible code. #PostgreSQL #AWSSCT #ExtensionPack #TrulyOpen #Oracle #aws_oracle_ext Explore our blog for more details. https://lnkd.in/dFgrPRuE

Don't miss out! Whether you're assisting a customer or collaborating with a partner to convert code to PostgreSQL using the AWS Schema Conversion Tool, this demo is a must-see. Join us to discover how you can unlock truly open PostgreSQL code and avoid hidden lock-ins with Extension Packs. Demo - https://lnkd.in/dSpe6sbr App - https://lnkd.in/dmfqpR3j #PostgreSQL #AWSSCT #Migration #Conversion #RDS #AmazonAurora #PLSQL #PLpgsql #ExtensionPack #aws_oracle_ext

Amazon RDS Multi-AZ deployments with readable standby instances now support C6gd database instances Amazon RDS Multi-AZ deployments with readable standby instances just got better! Now, with support for C6gd database instances, you can enjoy a lower-cost entry point to use a PostgreSQL or MySQL cluster. The smallest size supported is a three-instance setup of c6gd.medium with 1 vCPU, 2 GiB RAM, and 59 GB NVMe SSD each. #Amazon #RDS #PostgreSQL #MySQL Link: https://lnkd.in/gSdHkp-j

We recently worked for upgrading AWS RDS Postgresql instances from PSQL version 13 to 15 and on completion of this major version upgrade we ran across an issue with the log messge "no pg_hba.conf entry for host "x.x.x.x", user "<<username>>", database <<db_name>>, no encryption. Applications failed to connect to databases. Upon troubleshooting this issue further , We came to know that rds.force_ssl parameter value is set to 1 by default starting AWS RDS Postgresql 15 which forces the connections to be encrypted by default. For internal reasons, we did not want to enable this (the value remained 0 by default in previous versions of psql) and setting this value to 0 helped resolve the issue. If you are planning to perform major upgrades and want to get rid of these issues in future, It is advised to perform a quick comparison between the old and new parameter groups with the compare parameter group option provided under Actions tab in parameter groups to get drifts between current and future version parameters of parameter group. #awsrds #majorversionupgrade #psql15 #dba #awscloud Repost to share with fellow cloud engineers.

#Day16 Amazon RDS: Database service Amazon RDS (Relational Database Service) is a managed service that simplifies the setup, operation, and scaling of relational databases. AWS RDS Database Engines There are six database engines which RDS provides, and they are: Amazon Aurora PostgreSQL MySQL MariaDB Oracle Database Microsoft SQL Server Provides automated backups, monitoring, and patching, reducing administrative overhead. Easily scale compute and storage resources to match application needs. Use AWS Management Console, CLI, or SDKs to create and manage RDS instances. Choose database engine, instance type, storage, and other configurations. Access database using standard SQL clients or tools. Monitor performance metrics and set up alarms for proactive management. Easily scale up or down to handle changes in workload. Benefit from high availability and reliability features offered by AWS. Suitable for a wide range of applications, from small projects to enterprise-level systems. #cloudwithexlearn #cloudtraining #45daysofcloud Exlearn Technologies

How to Move a Database with Users from One MariaDB RDS Instance to Another on AWS

⚠️ Facing high costs for Amazon RDS extended support? Percona offers a smarter, more affordable way to manage MySQL 5.7 beyond EOL. You'll get: ▶️ 24/7/365 Support ▶️ Critical Bug Fixes ▶️ Up to 3 Years of Post-EOL support https://bit.ly/3OLzqKd #MySQL #OpenSource #DevOps