Questions tagged [amazon-rds-aurora]

The tag has no usage guidance.

13 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
16 views

AWS Aurora MySQL Serverless CPU utilization is growing for unknown reason

We have been using Aurora serverless databases in staging and production environments for a few months now, and find the CPU remains in the range 15-20% almost all the time. However in the past week ...
1
vote
0answers
125 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 ...
1
vote
0answers
34 views

Aurora PostgreSQL fail over process

Aurora PostgreSQL: How the process work on failover,I have a primary DB-prod for transaction database and read replica for reporting. where reporting will be pointed if primary fail. similar question ...
0
votes
1answer
25 views

Hints on bulk loading 3.6 billion rows to InnoDB on Aurora MySQL

everyone! I'm struggling for a week to bulk load 3.6 billion rows to an InnoDB table on Aurora MySQL 5.6.10a. This table has one FK to a "Main" table and has 12 columns. The first 1.4 billion were ...
0
votes
0answers
63 views

Migration from MySQL 5.7.10 to Aurora (MySQL)-5.6.10a Serverless and switching sql_mode

I am looking into migrating my locally managed MySQL 5.7.10 database to Amazon Aurora Serverless. I am tired of managing my database manually and I would like to use an auto-scaling feature of Aurora ...
0
votes
0answers
12 views

Can I use EBS data directory path as temp tablespace in ADS Aurora Postgresql?

I am having issue with RDS Aurora Postgresql's root storage (which is used for Temp files/tables and Logs) since its basically 2*PhysicalMemory. I thought of creating a new tablespace in data storage ...
0
votes
0answers
56 views

RDS Aurora postgres temp files removal

A report application generates lots of temp files in RDS aurora postgresql. Temp files loggings shows average 20G files being generated for each query execution. But the query execution not taking ...
0
votes
0answers
22 views

What database should I use locally if I'm going to use Aurora Serverless?

I'm planning to use Aurora Serverless in QA/PROD and then a docker container for running a compatible engine locally. Should I use MariaDB 10.0 or MySQL 5.6? Database need is low, we're not doing ...
0
votes
0answers
36 views

Does Aurora Postgres automatically kill process if replication lag is too high?

I have aurora postgres (9.6) master and reader. Time to time its getting swapped and message shows server process(PID 111111) was terminated by signal 9: Killed I didn't kill anything, and suspecting ...
0
votes
0answers
22 views

Weird Behaviour Aurora Mysql queries Timing out after DB keeps running for a while

I am shifting my database to Aurora Cluster MySQL. For testing, I have created a small sample data (2 GB DB size). I am connecting to the cluster writer endpoint. Connections and queries work fine for ...
0
votes
0answers
47 views

amazon aurora read_only {TrueIfReplica}

I have {TrueIfReplica} for read_only in parameter group for Aurora. I setup my aurora to replicate from an external master but it is 0 when I look at read_only in show variables. Why is this?
0
votes
0answers
55 views

Aurora MySql 5.7 killed processes doesn't die

We are using AWS Aurora MySQL and we recently moved to MySQL 5.7. After moving to this version, we started seeing issues with DDL statements. The processes which are running these statements just ...
0
votes
0answers
118 views

Finding Aurora functions (PostgreSQL)

On Amazon Aurora in the PostgreSQL (10) flavor there is a function names aurora_replica_status() documented. I can use the function and look at its definition: postgres=> select * from ...