Questions tagged [amazon-rds-aurora]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...