Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [aws-aurora]

Managed cloud database service‎ from Amazon Web Services, available for Postgres or MySQL.

-1
votes
0answers
7 views

JDBC: pooled connection not seeing new row

The problem here is easy to reproduce: 1) First a request creates a row. The front-end receives the row-ID. 2) Then another request is sent to read the row's data using the ID (like 200 ms ...
2
votes
0answers
70 views

Database design for ~ 2.7B records per year / 26.000 data points every five minutes

The current situation We're currently looking into a new product that will send device data back to us to interpret. These are the numbers we're looking at: Devices will most likely send data every ...
0
votes
0answers
17 views

How to change the Aurora MySQL instance role

I created a Aurora MySQL cluster a few weeks ago. There are two instances in the cluster. One has a writer role and the other has a reader role. AS-IS +----------------...
0
votes
0answers
19 views

CPU usage is 98% But process is no… in Aurora 1.19.0 [closed]

My development environment cpu usage is very high. It is rds aurora. Instance type is db.t2.small. DB total size is about 300MB. Memory still remains about 200MB. process is nothing... Why this ...
1
vote
0answers
26 views

Got an error reading communication packets on writer instance only

So I am connecting with aurora MySQL 5.7.12-log with Django. Below (1) is the query auto-generated by Django when I hit runserver. SELECT `django_migrations`.`app`, `django_migrations`.`name` FROM `...
1
vote
1answer
63 views

Postgres RDS: is there a way to use LDAP authentication?

We have a client interested in using LDAP (specifically Active Directory) for user authentication on a PostgreSQL AWS RDS (Aurora, specifically) database. Anybody doing this successfully?
0
votes
1answer
22 views

Reducing latency in read operations

Table size 45 million rows Schema: item name, categories and subcategories, order quantity and price. What is the fastest way to put each item into an appropriate bucket? For example: price range ...
1
vote
1answer
23 views

Optimizing query performance with aggregation tables and partitioning

Our setup is a bit complex, so I will try to simplify what our tables look like but still try to describe the real problem: We have a large table (items) with about 500 million rows (grows with ~1....
0
votes
0answers
5 views

Benchmark for a rowlock in mysql

I am trying to benchmark a sql transaction with a select..for update statement which uses an exclusive lock on the row and then insert a row into another table as shown below. START TRANSACTION; ...
0
votes
1answer
11 views

Dump roles on AWS without pg_dumpall -g access (postgresql 9.6.8)?

We have a system on AWS RDS Aurora, PostgreSQL v 9.6.8 option. We are trying to move its roles to a new encrypted 10.5 instance, but we don't have superuser access that's required to do pg_dumpall -g ...
1
vote
0answers
83 views

AWS Aurora Database Corruption

I'm running Aurora Postgres and noticed that metric Maximum Used Transaction IDs is increasing a lot. Trying to manually vacuum the tables that's was not automatically vacuumed lead me to the ...
1
vote
1answer
130 views

Downgrading from AWS Aurora MySQL 5.7 to AWS Aurora MySQL 5.6

We are trying to downgrade from AWS Aurora MySQL 5.7 to AWS Aurora MySQL 5.6 due to some issues. But AWS RDS doesn't allow Aurora MySQL 5.7 snapshot restore to Aurora MySQL 5.6 instance/cluster. Does ...
0
votes
0answers
23 views

Aurora MySQL 5.7 DDL statements hangs intermittently

We are using AWS Aurora MySQL and we recently moved to MySQL 5.7 version. After moving to this version, we started seeing issues with DDL statements. The processes which are running these statements ...
1
vote
1answer
20 views

Seeing AWS PostgreSQL-on-Aurora snapshot sizes of 0 GB - is this normal for a db of ~800mb?

While working on some code to manage our manual snapshots, I noticed that a number of recent AWS PostgreSQL-on-Aurora snapshots show a storage size of 0 GB (older ones are at 1 gb). I thought it might ...
3
votes
1answer
352 views

ERROR: improper qualified name (too many dotted names) when trying ALTER FUNCTION

Working with Amazon Aurora Postgres Version 2.0, which is basically PostgreSQL 10.4 with a modified storage layer. Trying to restore a dump that contains multiple lines like: ALTER FUNCTION ...
0
votes
0answers
51 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 ...
-1
votes
1answer
37 views

What is a beachhead? (replication / sharding)

I quote the following from this blog post from AWS: Because you’re running on MySQL, you can use one of the methods listed in the Aurora documentation to establish a beachhead in Aurora. What ...
1
vote
1answer
82 views

migrating from a local PostgreSQL database to Amazon Aurora

I have a local PostgreSQL database and I want to migrate it to Amazon Aurora, how do I do that? I found a documentation on how to migrate from RDS PostgreSQL database, however, mine is local and I ...
0
votes
1answer
257 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
18 views

How do I debug max_allowed_packet going to -1?

I am using Amazon's MySQL Aurora and using JDBI on the client side. Every once in a while, the connection goes bad and I get errors like this - com.mysql.jdbc.PacketTooBigException: Packet for query ...
1
vote
1answer
253 views

Is Postgres sharding available on Aurora (AWS)

I need to shard and/or partition my largeish Postgres db tables. The Postgres partitioning functionality seems crazy heavyweight (in terms of DDL). I see talk from <=2015 about pg_shard, but am ...
2
votes
0answers
22 views

MySQL Queries Truncate Causing Connection Spikes

We have a MySQL Master Instance & Read (failover only) on AWS. MySQL 5.6 Aurora running Magento. Performance is great, and better than standard MySQL (we have high traffic site so see the benefits)...
1
vote
1answer
194 views

Are read replicas heavy reading in affect masterDB?

We have a very heavy load in Read side with large DB tables in 2 hours per day that affect to Db so as solutions I have created read replica for it. If application fetches large heavy data on read ...
-2
votes
1answer
52 views

Which database is suitable for serving big timeseries metrics with rollups? [closed]

I have big mysql table containing daily metrics for large number of subjects. Here is the hypotetical schema: day DATE subject_id INT metric1 metric2 metric3 What I want is to find top X subjects (...
1
vote
1answer
175 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 ...