Questions tagged [amazon-rds-aurora]
The amazon-rds-aurora tag has no usage guidance.
25
questions
0
votes
1answer
22 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 ...
0
votes
0answers
25 views
Long Running Transaction in MySQL
I have very Long Running Transactions in MySQL (RDS Aurora)
select * from information_schema.innodb_trx where trx_id = 45638005;
+----------+-----------+---------------------+-----------------------+-...
-1
votes
2answers
47 views
MySQL Select Query not using Required Index
I have a Table which has 2 Million Records and No primary or Unique Keys.
I added Two Indexes and I'm expecting an Index to be used for my Select Query.
When I saw the Explain Plan , Optimizer is not ...
0
votes
0answers
43 views
SSHtunnelForwarder to Linux Box, then connect to Postgres RDS (AWS)
I'm trying to write a python script to update DDL in a Aurora RDS (postgres) on AWS. In Order to do this, I need to SSHTunnel to a linux box that sits at the edge of the VPC, then do another jump to ...
0
votes
0answers
50 views
Migrate cluster Aurora RDS postgres from 9.X to 10 without downtime
Ok, this question is to find some strategy or tool that helps me to migrate from cluster Aurora RDS postgres from 9.6 to 10 without downtime.
What I find until now
Aurora RDS is allowed to do major ...
0
votes
0answers
34 views
Data replication between Oracle and Postgres
Is there a way to replicate the DML changes that happen in a Postgres table into a table in Oracle database? My Postgres database is RDS in AWS environment. So I am unable to use the extension ...
1
vote
0answers
24 views
Constraint creation on a large table is too slow
There's a table with 723M rows, large amount of data and not partitioned. We're adding a constraint to the table as follows:
ALTER TABLE ONLY my_table ADD CONSTRAINT partial_constraint EXCLUDE USING ...
0
votes
1answer
86 views
Why and When the pg_stat_activity's most of the columns are null?
Recently, I have noticed that when I query the pg_stat_activity for few users most of the columns are [null] (pgAdmin 4) in the result.
Only thing I can see is datid, datname, pid, usesysid, usename,...
0
votes
1answer
101 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 ...
0
votes
0answers
71 views
AWS DMS: Table Mapping?
We are moving from SQL Server to AuroraDB (mySQL). Both our source database (SQL Server) and our target (AuroraDB) are on AWS RDS so we are naturally using DMS for the migration.
We make heavy use ...
0
votes
0answers
36 views
AWS aurora mysql is restarted unexpectedly
In our system
one of aurora mysql instances was't available for short period.
because this instance suddenly restarted at 08/14/2019 3:56JST.
we already checked error log for aurora.
but i found ...
0
votes
1answer
150 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 ...
1
vote
1answer
185 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 ...
0
votes
0answers
268 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
17 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
126 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
46 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
293 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
66 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
42 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
171 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
1answer
794 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
430 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
39 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
216 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 ...
