Questions tagged [aws-aurora]
Managed cloud database service from Amazon Web Services, available for Postgres or MySQL.
0
votes
0answers
20 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
34 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
15 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
15 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 ...
2
votes
0answers
172 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
27 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
28 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
39 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 ...
1
vote
0answers
20 views
AWS RDS Performance insights - Do DBAs would need a DB user? [closed]
This question is more to clarify or expand my knowledge. Currently, on my work, we're migrating all our systems to AWS. Regarding to databases, we start using performance insights but I'm not really ...
0
votes
1answer
159 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
16 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
138 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
19 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
145 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
48 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
153 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 ...
