Questions tagged with MySQL

Hi Team, I am using Aurora MySQL with instance class db.r6g.xlarge (32 GB RAM). Based on the standard formula max_connections = DBInstanceClassMemory / 12582880, the calculated default value comes to...

I have a Lambda function running in private subnets within a VPC that needs to connect to an on-premises MySQL database over a VPN Site-to-Site connection. The on-premises firewall only allows connect...

I would like to clarify a question regarding the text below that I received from AWS support concerning the MySQL version upgrade on my RDS instance: """ [Action Required] Amazon RDS for MySQL is dep...

So I’ve been informed that MySQL 8 will be deprecated in 2026 and an upgrade to a ‘new major version’ is required. I’m currently on 8.0.42. Is 8.4 a new major version or will I need to upgrade to v9...

Hello all, We are planning a database migration and long-term data synchronization setup. Our current configuration is an on-premises MySQL database that needs to be replicated to a target AWS RDS My...

Hi, I'm trying to modify my RDS instance from db.t3.medium to db.t4g.medium (Multi-AZ enabled). **Timeline:** - 07:14 - Backup started - 07:28 - Multi-AZ failover completed (according to events) - 0...

Severity: High (Production environment impact) ### 1. Problem Description Since completing a Blue/Green deployment, we are unable to establish new connections to our Production RDS MySQL instance fr...

``` LOAD DATA FROM S3 FILE 's3://bucket-name/path/to/file.csv' INTO TABLE `schema_name`.`table_name` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE...

Hello AWS Community, We are facing an issue with a MySQL RDS instance (preprod-300) in ap-south-1a. Details: Snapshot Name: beforeswitch Snapshot Type: Manual, unencrypted, gp3 storage Observation: ...

Hi, I am looking for a solution on column-level encryption of multiple RDS databases without involving any coding at database/application level. The only solution I found so far which matches the requ...

Hi, My new company still has an RDS which is currently running in 5.7, I have been trying to upgrade this to atleast 8.0 for the few months that I have been here but no schedule yet has been approve...

I have an existing Amazon RDS Reserved Instance purchased for 3 years. Currently, I am no longer using it and would like to know the possible options to optimise or save costs. Specifically: Can I se...