Questions tagged [amazon-rds-aurora]

The tag has no usage guidance.

1
vote
0answers
83 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
30 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
0answers
18 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
10 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
30 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
20 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
30 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
16 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
43 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
36 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
104 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 ...