Questions tagged [amazon-rds-aurora]
The amazon-rds-aurora tag has no usage guidance.
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
22 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
19 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 ...
1
vote
0answers
79 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 ...
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
15 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
1answer
53 views
Aws RDS cpu Spike to 100% because of running set isolation command and set
My application running with the AWS RDS as a backend.
currently i am doing a performance test.
While doing that i am seeing RDS cpu usage goes 100% after 20min.
While seeing the performance insights ...
0
votes
0answers
40 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
33 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 ...
0
votes
1answer
395 views
Error log flooding with aborted connections (Aurora 2.03 - MySQL 5.7.12)
Here's some contextual information: I have a multi-tenant, WordPress MU installation running on Elastic Beanstalk, scaled up to 2 instances minimum. These are connected to the RDS database and are ...
0
votes
1answer
196 views
Multi-AZ failover - replica still read only after failover
Setup:
I have a single RDS cluster. This cluster has two instances, one in each zone. Naturally, one "replication role" reader and one writer.
What happened:
I manually triggered a failover of the ...
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 ...
1
vote
1answer
182 views
Can AWS Aurora High Availability allow different Schema on Replicas?
Our company is thinking of migrating from SQL Server to Amazon AuroraDB.
In SQL Server, there are AlwaysOn and Transactional Replication - two different things.
AlwaysOn is utilized more for ...
