Juan Canas’ Post

Elevate your database management to new heights with MySQL 8.0 on AWS RDS. Here's why it's an essential choice for modern businesses. #MySQL #AWS #RDS #DatabaseManagement #CloudComputing #DataSecurity #Scalability #Performance #Innovation #DigitalTransformation #hiredeveloper

The Exorbitant Costs of MySQL 5.7 on AWS RDS 💸 ⏰ End of standard support for MySQL 5.7: February 29, 2024 💰 Extended Support costs 4x for the first 2 years, 6x in the 3rd year ⚙️ Automatic major engine upgrade after 3 years 📅 Plan upgrades now to avoid last-minute issues and downtime Start with a free trial!  https://app.cloudnetra.io/ Learn more about the advantages of using Cloudnetra. https://cloudnetra.io/ #AWS #MySQL #RDS #CloudComputing #DatabaseManagement #TechUpgrade #CostEfficiency #Cloudnetra

AWS RDS Backup Retention: How to Retain MySQL & PostgreSQL Database Data for Over 35 Days. https://lnkd.in/gWGaUFFk #AWS,#AWSRDS,#RDSbackup,#AWSbackup,#databasebackup,#RDSmanualsnapshot, #AWSbackupretention, #AWScloud,#dataprotection, #cloudbackups

Optimize your Oracle to Azure PostgreSQL migration with DMAP! Assess multiple schemas and applications concurrently with actionable insights. Automate up to 100% of schema conversion and up to 80% of application code conversion. Ready to accelerate? Explore DMAP on the Azure Marketplace! - https://rb.gy/a63dsr #newtglobal #DMAP #Oracle #PostgreSQL #migration #schema #Azure

A relational database is a way of keeping information (data). Relational databases help us connect information to other information. Some common relational databases are → MySQL → PostgreSQL → DB2 → Oracle Database To learn how to make a relational database on AWS Cloud 👇 🔗 : https://lnkd.in/dH5aNet8

Public Preview: In-database embeddings in #Azure Database for PostgreSQL - Flexible Server

I was not sure about the restriction that the AUTO_INCREMENT attribute of a column is not migrated to the target database when using a MySQL database as a source for AWS DMS, so I checked. #AWS #AWSDMS #MySQL #Database #SRE

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

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