All Content tagged with Database

ust a simple thing like storing MySQL connectionstring in a parameterStore secure variable is a major PIA: Since our RDS MySQL is in a VPC, my Lambda needs to be there also - then you need to setup...

Hi community, I need to store hourly and daily data for about 6,000 assets in my PostgreSQL Aurora DB. Given the scale, I plan to keep three years of daily data and three months of hourly data....

Hello, We have function called trigger_neptune_loader_job(), which has following functionalities: 1. Connecting to Neptune and sets up S3 access. 2. Clears existing data in the Neptune cluster. 3....

I created a parameter group and adjusted the queryConcurrency and queryQueueSize to 0. I applied the group to the running Timestream InfluxDB database. After a while, it went into a **FAILED** status....

I am experiencing issues with my Amazon RDS instances, which currently show the status "**Inaccessible-encryption-credentials**." The affected instances are: Website Production Aurora (Regional...

We have one RDS and We are operating two EC2s in different regions. However, because it is in a different region, the connection speed and query speed are very slow. So I want to try `Direct...

Do we need to set the pg_audit value at the database level? or can we set them in the parameter group commonly

I am doing a major version upgrade from postgres (with postgis extension) from version 15.7 to version 16.3 using aws blue/green deployment. I have followed the AWS guide and have encountered an error...

Hi! In my AWS environment I have several RDS instances that are created and connected to my dev environment on the cloud and secure via VPC. For local development until now I runned a docker...

We have a 'regional cluster' Aurora Mysql witth 4 instances, serverless v2 (0.5 to 6 ACUs) To cut down costs we need to reduce multi-AZ from 3 zone to 2 How ?!

I have a current db running with time zone UTC and I want to change the time zone GMT+7 for the same time in my country. I have researched and understand we can't do this with db running. We just...

hello, I'm a student who want to test RDS Failover, I need to know if the Ip changes or how much time it needs to reboot RDS. My teacher said that RDS have no downtime (disaster recovery feature) then...