All Questions
Tagged with amazon-rds aws-aurora
34 questions
0
votes
1
answer
30
views
Amazon Aurora RDS - invalid undo record
Context
Aurora RDS, MySQL 8.0.mysql_aurora.3.05.2
Problem
The writer instance is constantly cycling. In the AWS RDS console, under Logs & events for the writer, I see
Attempting to restart the ...
- 121
0
votes
0
answers
46
views
How can I find what's eating so much space in Postgres in AWS RDS Aurora?
Essentially when I run
SELECT
pg_size_pretty(SUM(pg_total_relation_size(relid))) as total_size,
pg_size_pretty(SUM(pg_indexes_size(relid))) as index_size,
pg_size_pretty(SUM(pg_relation_size(...
- 101
0
votes
0
answers
117
views
database "template0" is not currently accepting connections
i got the following error
database "template0" is not currently accepting connections
How to vaccum it?
Thanks
UPDATE
i got the following yesterday
postgres=> select * from public.test;
...
- 259
0
votes
1
answer
474
views
Aurora PostgreSQL TEMP TABLE creation taking more CPU than expected?
I'm running on an Aurora PostgreSQL on a db.x2g.2xlarge instance. Simply creating temporary table showed up as the third highest wait, which surprises me, as I expected it to be one of the lighest ...
- 1,655
1
vote
0
answers
237
views
Aurora RDS - difference between ConnectionAttempts and DatabaseConnections
So I have read this a few times about these two metrics: ConnectionAttempts and DatabaseConnections.
Based on the above, is RDS rejecting lots of connections? Here are the graphs of these two metrics.
...
- 11
1
vote
1
answer
1k
views
Amazon Aurora RDS (serveless) - How to match an ACU in terms of CPU number and memory
I need to migrate an Amazon RDS back to on-premises envoriment. How to How to match an ACU in terms of CPU number and memory?
My instance has:
Minimum capacity
1 ACUs (2 GiB)
Maximum capacity
10 ACUs (...
- 801
1
vote
0
answers
170
views
Ways to reduce latency in importing data from csv files into MySQL Workbench when connected to an RDS MySQL db Instance
This question is a follow-up to this question I asked on Stack Overflow yesterday after answering my own question by creating a Aurora MySQL db Instance and establishing a connection between it and ...
- 227
0
votes
1
answer
803
views
Postgresql Sequence Hopping
I have recently migrated (dump and restore) my database from AWS RDS PostgreSQL v12 to Aurora Serverless v2 PostgreSQL v14.6. The issue is we have setup sequencing in a table on old RDS, now in the ...
- 11
1
vote
0
answers
97
views
How to encrypt a production unencrypted RDS Aurora MySQL 8 cluster
I have a running RDS Aurora MySQL 8.0.23 cluster running in production. The database is unencrypted and I need to enable encryption for it. As far as I understand, this is not possible to do directly. ...
- 111
1
vote
0
answers
146
views
Assign privileges to a postgres user
I am working on creating a postgres user and assign certain privileges to the user. These are privileges to execute certain functions with the end goal of being able to replicate data or change-data-...
- 111
0
votes
1
answer
436
views
Creating a multi-region active-passive DR plan for Aurora MySQL?
I'm trying to create a disaster recovery plan for a cost efficient, maintainable and with little down for Aurora MySQL.
I want two read/write databases in two different regions, they can be separate ...
- 101
1
vote
0
answers
952
views
Does the "max vCPU" limit only apply to the "CPU" wait state?
In the Average Active Sessions chart of Performance Insights for Aurora MySQL 8, there is a horizontal Max vCPU (at 16, in my case). Now I wonder if this limit applies only to the CPU wait state (...
1
vote
2
answers
610
views
Automating MySQL replication using snapshots on AWS RDS (or Linux)
I'm currently working on a BASH script to build a new Aurora cluster based on the latest snapshot of an existing cluster, then set up MySQL replication from the old one to the new. In the past I've ...
- 143
3
votes
2
answers
4k
views
What's the advantage of sharding in AWS Aurora?
AWS' RDS docs on multi-master Aurora state the following:
In an Aurora multi-master cluster, each shard is managed by a specific DB instance, and a DB instance can be responsible for multiple shards.
...
- 447
2
votes
0
answers
619
views
Why is this DELETE causing my Aurora MySQL 5.7 instance to crash?
I have a large table (2.3TB of data, 1.9TB index, 33 billion rows). A user recently executed a DELETE statement (32k rows) against the table, which caused the server to eat up all memory and then fail ...
- 143
1
vote
1
answer
712
views
How to clear AWS RDS Aurora MySQL local storage?
I got a warning message about running out of AWS RDS local storage.
The free storage capacity for DB Instance: {MY INSTANCE NAME} is low
at 2% of the provisioned storage [Provisioned Storage: 157.36 ...
- 111
1
vote
0
answers
2k
views
AWS Lambda to RDS PostgreSQL connection
Hello fellow AWS contributors, I’m currently working on a project to set up an example of connecting a Lambda function to our PostgreSQL database hosted on RDS. I tested my Python + SQL code locally (...
- 11
1
vote
1
answer
870
views
RDS slow queries after few weeks
Since I updated from MySQL 5.6 to 5.7 I started to have very slow queries in my Aurora RDS instance. In my local XAMPP the same queries took a few seconds but in RDS some of them were about 6 minutes. ...
- 113
1
vote
0
answers
329
views
Does AWS Aurora MySQL not support encrypted binary log replication with RDS MySQL master?
Trying to setup replication between an RDS MySQL (5.6) master with an Aurora MySQL (also 5.6) replica cluster in the same region via binary log replication for a work project. However, this doesn't ...
0
votes
1
answer
792
views
How to set PostgreSQL's permission when migrate other database to it on AWS?
We want to migrate an Oracle DB to a PostgreSQL DB in RDS with DMS.
There is an official guide for preparision in the PostgreSQL's DB:
https://docs.aws.amazon.com/dms/latest/sbs/chap-oracle2postgresql....
- 177
0
votes
1
answer
675
views
Index maintenance on pg_catalog tables in AWS RDS
I have had some bad historical usage on my Aurora PostgreSQL instance. Namely, connections that create a lot of temporary objects and some very long running transactions (which limits autovacuum).
Now ...
- 780
0
votes
0
answers
102
views
Is it possible to use check_user_proxy on AWS RDS?
My top-level goal is to enable two-user (zero-downtime) secret rotation for RDS users. To recap/summarize the approach, you always have two accounts in your DB that have equivalent access. You switch ...
- 101
2
votes
4
answers
2k
views
Migrating MySQL 8.0.20 database to AWS Aurora
I originally posted this question on stack overflow as I did not know this service existed and someone suggested I may get a better answer here.
I was trying to use the AWS RDS Proxy service and ...
- 121
0
votes
1
answer
175
views
Why is there a writable instance inside a secondary region for MySQL AWS Aurora Replica?
I have created two Aurora MySQL clusters with two nodes in two regions using terraform. The secondary region is set up to replicate from primary region using binlog. This seems to be set up correctly, ...
- 101
0
votes
1
answer
1k
views
Why a query takes too long in statistics thread state in AWS Aurora MySQL?
The following query execution too long in statistics state and I couldn't figure out why.
DB engine - 5.7.mysql_aurora.2.07.2
DB Size - db.r5.4xlarge
Sample Query Profile output
+----------------------...
- 101
1
vote
0
answers
23
views
Storing Analytic Data for Multi-Tenet SaaS with AWS Aurora [closed]
I have an app that a user can upload an excel sheet of analytics data to S3. I am wanting to trigger a Lambda function on upload to do some data processing and then write the analytics to a client's ...
- 111
1
vote
1
answer
607
views
Limiting user access by subnet to Amazon Aurora PostgreSQL
How do I limit user access by IP? For example, assuming I have two non-superusers (user1 and user2), how can allow general access (only limited by security groups) to the instance/cluster by user1 but ...
- 121
0
votes
1
answer
1k
views
AWS Aurora RDS 2nd reader gets no queries
Running a Postgres Aurora RDS with one writer and two readers.
One reader is used heavily, but the other is barely used at all according to CloudWatch.
The Laravel application this is connected to ...
- 399
0
votes
0
answers
384
views
High constant CPU on Aurora/RDS
I've noticed recently that our resting CPU on our Aurora RDS cluster appears to be about 80%. I'm unsure when this started, as we don't have alarms/metrics in place (something I plan to rectify now).
...
- 101
1
vote
1
answer
1k
views
mysql/aurora not immediately seeing results of committed transactions
In a system running against an AWS aurora-mysql database, the following (obviously extremely simplified) code runs. It's a highly concurrent system, multiple threads, multiple connections to db. The ...
- 111
1
vote
0
answers
766
views
Predicting AWS RDS MySQL Instance Performance
I have a small MySQL db running on AWS RDS t2.small instance.
So far, the CPU usage has been very predictable based on the traffic from my app.
Example:
1000 concurrent users = 15% CPU
2000 ...
- 111
0
votes
1
answer
3k
views
Find queries causing a lot of read IO
I'm trying to find the cause of a higher amount of VolumeReadIOPs in our Aurora Postgres instance on AWS. This is what the past 6 weeks look like:
I found the cause of the largest period (02/27 to 03/...
- 127
3
votes
0
answers
1k
views
AWS Aurora Database Corruption
I'm running Aurora Postgres and noticed that metric Maximum Used Transaction IDs is increasing a lot. Trying to manually vacuum the tables that's was not automatically vacuumed lead me to the ...
- 131
1
vote
1
answer
1k
views
Are read replicas heavy reading in affect masterDB?
We have a very heavy load in Read side with large DB tables in 2 hours per day that affect to Db so as solutions I have created read replica for it.
If application fetches large heavy data on read ...
- 113