Questions tagged [amazon-aurora]

Amazon Aurora is a MySQL and PostgreSQL compatible relational database management system (RDBMS) that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases.

Filter by
Sorted by
Tagged with
54votes
12answers
35kviews

AWS Aurora MySQL serverless: how to connect from MySQL Workbench

I was trying to use AWS Aurora Serverless for MySQL in my project, but I am impossible to connect to it, though I have the endpoint, username, password. What I have done: From AWS console managment, ...
user avatar
  • 2,396
48votes
3answers
22kviews

Amazon RDS Aurora vs RDS MySQL vs MySQL on EC2?

I've been looking around for best practices when setting up your database on the cloud but it still isn't clear to me which of the following solutions should we be going for? Amazon RDS Aurora Amazon ...
user avatar
37votes
3answers
17kviews

Why does AWS RDS Aurora have the option of "Multi-AZ Deployment" when it does replication across different zones already by default?

When launching an Aurora instance I have the option of "Multi-AZ Deployment", which it describes as "Specifies if the DB Instance should have a standby deployed in another Availability Zone." However ...
user avatar
  • 3,586
34votes
0answers
13kviews

AWS Aurora: What is 'delayed send/commit ok done' process state [closed]

What do the following process states mean in AWS Aurora (MYSQL-Compatible) delayed send ok done delayed commit ok done Noticing many sleeping processes with the above state. These seem to Aurora-...
user avatar
  • 1,240
29votes
2answers
22kviews

AWS Aurora: The MySQL server is running with the --read-only option so it cannot execute this statement

I am getting this error when executing a GRANT statement on my Aurora DB instance in AWS: The MySQL server is running with the --read-only option so it cannot execute this statement My user is not ...
user avatar
  • 68k
29votes
3answers
14kviews

Any way to run AWS Aurora locally?

We are thinking about migrating to AWS Aurora from MySql. We are running vagrant for developers, so each virtual box has its own mysql instance. Is there a way to run Aurora locally? If not, what ...
user avatar
  • 557
25votes
6answers
13kviews

How to upgrade AWS RDS Aurora MySQL 5.6 to 5.7

We are using AWS RDS Aurora MySQL 5.6 for our production database. AWS launched MySQL 5.7 compatible Aurora engine on 6th Feb, 2018. I dont see any option in "modify instance" to change engine to ...
user avatar
24votes
1answer
20kviews

What's the difference between Cluster and Instance in AWS Aurora RDS

I guess the title is pretty objective, but just to clarify: When you create an Aurora Database Instance, it is asked to give a name for a Database Instance, a Database Cluster and a Database (where ...
user avatar
22votes
5answers
13kviews

Creating an Aurora Serverless Cluster from cloudformation?

From Aurora Serverless's document, there are 3 ways to create an Aurora serverless DB cluster: AWS management console, CLI, and RDS API. (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/aurora-...
user avatar
  • 778
19votes
3answers
13kviews

Optimize write performance for AWS Aurora instance

I've got an AWS Aurora DB cluster running that is 99.9% focused on writes. At it's peak, it will be running 2-3k writes/sec. I know Aurora is somewhat optimized by default for writes, but I wanted to ...
user avatar
  • 211
19votes
5answers
6kviews

AWS RDS Data API executeStatement not return column names

I'm playing with the New Data API for Amazon Aurora Serverless Is it possible to get the table column names in the response? If for example I run the following query in a user table with the columns ...
user avatar
  • 1,322
19votes
3answers
14kviews

Is it possible to migrate back from Amazon Aurora to native MySQL in Amazon RDS?

I saw Amazon introduced new Amazon Aurora MySQL migration from native MySQL to Amazon Aurora MySQL. Would it be possible to migrate back from Amazon Aurora to regular MySQL with Amazon RDS?
user avatar
  • 1,132
17votes
1answer
12kviews

How to change AWS-RDS instance type without downtime?

I'm using AWS-RDS(Aurora MySQL5.6) and It's a cluster, it has one writer instance and one reader instance. I find each instance would be down for nearly 10 minutes when I change its type, it's ...
user avatar
  • 1,415
17votes
4answers
7kviews

How do you switch between standard and serverless configurations in Amazon Aurora

I am looking a this Amazon page - https://aws.amazon.com/rds/aurora/serverless/ and it has this quote: You pay on a per-second basis for the database capacity you use when the database is active, ...
user avatar
  • 3,975
17votes
1answer
8kviews

How to change character_set_server in Amazon's Aurora DB?

Currently using Amazon's Aurora DB and in our Jira we are seeing some names with question marks (???) due to their characters. After further looking into this it seems that I need to change the ...
user avatar
16votes
1answer
18kviews

AWS RDS Writer Endpoint vs Reader Endpoint

I created an Amazon Aurora instance in my VPC. When the instance was created, it came with 2 endpoints, a writer and a reader endpoint. The instance is using a security policy with an ingress rule (...
user avatar
  • 315
15votes
3answers
9kviews

Aurora RDS instance can not be stopped

I am trying Amazon Aurora instance and I can not see an option to stop it. The only options are Delete and Reboot. Am I missing something.
user avatar
  • 1,669
15votes
4answers
8kviews

How do you remove/undo/delete a pending modification on Amazon Aurora RDS?

I was pegging the 90 total connections allowed on my Aurora RDS instance, now that I've got a few more heavy duty sites than I had before. I decided to upgrade the instance and I did so, but put the ...
user avatar
  • 702
14votes
10answers
18kviews

Amazon Aurora 1.8 Load Data From S3 - Cannot Instantiate S3 Client

With the latest Aurora update (1.8), the command LOAD DATA FROM S3 was introduced. Has anyone gotten this to work? After upgrading to 1.8, I followed the setup guide Here to create the Role to allow ...
user avatar
  • 1,220
13votes
3answers
4kviews

Amazon aurora postgres serverless: Database returned more than the allowed response size limit

We are exploring aurora serverless as a database storage for one of our project. While doing the POC to fetch events from aurora serverless cluster we are receiving "Database returned more than the ...
user avatar
12votes
1answer
12kviews

Sequelize connection timeout while using Serverless Aurora, looking for a way to increase timeout duration or retry connection

I'm having an issue at the moment where I'm trying to make use of a Serverless Aurora database as part of my application. The problem is essentially that when the database is cold, time to establish ...
user avatar
12votes
2answers
9kviews

What database driver should be used to access AWS Aurora?

What ruby database driver should be used to access AWS Aurora? We intend to use this db as the backend for a Rails app.
user avatar
  • 4,096
12votes
1answer
7kviews

Connecting to Amazon Aurora using SQLAlchemy

I am trying to connect to Amazon Aurora with SQLAlchemy using an SSL connection, specifying the IAM role as the database user account and the authentication token as the password, as described here in ...
user avatar
  • 121
12votes
2answers
630views

How to handling PDO MySQL fail over in AWS using persistent connections

We have experienced a problem with AWS Aurora failover and looking for pointers as to how to resolve. Scenario AWS Aurora set up with two end points: Writer: host: stackName-dbcluster-ID.cluster-...
user avatar
  • 17.3k
10votes
3answers
2kviews

Enable Aurora Data Api from CloudFormation

I have a CloudFormation template that creates my RDS cluster using aurora serverless. I want the cluster to be created with the data API enabled. The option exists on the web console: https://docs....
user avatar
10votes
2answers
6kviews

Blocking on idle connections on ClientRead for parametrized queries (bindings) during high traffic

I am looking for good solution for my problem which occurs during high traffic peaks. I use postgres on AWS with nodejs (knex for queries buliding) - details below. When I am looking on Performance ...
user avatar
  • 101
9votes
5answers
4kviews

terraform the db instance and ec2 security group are in different vpcs

i am trying to create a vpc with public and private subnet along with Aurora mysql cluster and instance in same vpc with custom security group for RDS. i've created vpc (public/private subnet, custom ...
user avatar
9votes
1answer
3kviews

How to create an index on an XML column in PostgreSQL with an xpath expression?

I'm running into this error when attempting to create a btree index on an XML data type column that uses an xpath expression on AuroraDB - PostgreSQL 9.6: ERROR: could not identify a comparison ...
user avatar
  • 3,759
9votes
1answer
5kviews

How do you associate a IAM Role with an Aurora Cluster using CloudFormation?

Following the instructions found here, I have created the following IAM Role "DatabaseS3Role": { "Type": "AWS::IAM::Role", "Properties": { "AssumeRolePolicyDocument": { "...
user avatar
9votes
2answers
2kviews

AWS RDS Aurora - How to connect using PgAdmin?

Yesterday AWS launched Aurora serverless for PostgreSQL, but it doesn't seem to have the same configuration options as other RDS databases, I can't set it to public facing for example, it forces me to ...
user avatar
  • 1,443
9votes
1answer
6kviews

Copy data from AWS S3 to Aurora Postgres

I'm trying to copy data from AWS S3 to Aurora Postgres. Currently my process is as follows: Download files from S3 locally (on EC2 instance) Run "COPY FROM STDIN ... " command to load data from ...
user avatar
  • 788
9votes
0answers
2kviews

intermittent "unknown database"

We are currently trying to troubleshoot an issue running dotnet core and EF core with an AWS Aurora (mysql) db running on RDS. We are getting "unknown database" errors in some of our selects through ...
user avatar
  • 91
8votes
2answers
14kviews

AWS DMS issue with source endpoint in EC2-classic

We are using several EC2-Classic servers (Linux Ubuntu) with following configuration: mounted EBS volumes and on them is running Server version: 5.5.48-MariaDB I would like to use AWS DMS (AWS ...
user avatar
  • 154
8votes
2answers
4kviews

The DB instance and EC2 security group are in different VPCs, cloudFormation error

I want to automate the process of creating RDS. I would like to create RDS Aurora. When deploying the application, stack cloudFormation is validated and I have an error: An error occurred: ...
user avatar
8votes
1answer
14kviews

MySQL: How long are binlogs retained?

I have a mysql slave which I am attempting to replicate a master mysql instance. I migrated the data a week or so from the production master instance. At the time I invoked SHOW MASTER STATUS on the ...
user avatar
  • 6,389
8votes
2answers
2kviews

AWS Aurora server sometimes responds with "Unknown Database: ..."

I have a .NET application that executes queries on a MySQL database in Amazon Aurora RDS. The database is a MySQL 5.6 database - the version that comes with Aurora. I execute the queries against a ...
user avatar
  • 181
8votes
1answer
2kviews

Internet Access to lambda function without NAT

I have a AWS Aurora db in vpc in private subnet. From Aurora, we need to execute lambda which will connect to pinpoint to send sms. Lambda function needs access to internet. How to provide internet to ...
user avatar
8votes
1answer
612views

PostgreSQL slow insert of a single row with RETURNING (taking 500ms in production)

Bit stumped here. I have a small table called request_to_print. This is the table structure. It has a single primary key of request_internal_id. The table has 747 rows in it. When an insert takes ...
user avatar
  • 1,933
8votes
2answers
10kviews

.NET & MySQL error - A call to SSPI failed ... "message received was unexpected or badly formatted" AND "buffers supplied to a function was too small"

I hope this is not too vague of a question, but I have looked far and wide but have not been able to find anything helpful for this error. I have a .NET 4.5.2 web service tier (using ServiceStack &...
user avatar
  • 4,245
7votes
3answers
6kviews

AWS Aurora Serverless - Communication Link Failure

I'm using MySQL Aurora Serverless cluster (with the Data API enabled) in my python code and I am getting a communications link failure exception. This usually occurs when the cluster has been dormant ...
user avatar
  • 1,746
7votes
2answers
5kviews

Provision multiple logical databases with Terraform on AWS RDS cluster instance

So, i've got Aurora MySql cluster with one RDS MySql instance provisioned. The obstacle occurs with the AWS underlying API allowing only for 1 logical DB to be created. Thus, I was wondering if any of ...
user avatar
7votes
4answers
5kviews

Can Aurora PostgreSQL be used with AWS AppSync?

I've seen examples of DynamoDB as the data source for AWS AppSync but I'm wondering if Aurora (specifically PostgreSQL) can be used? If yes, what would the resolvers look like for a basic example? ...
user avatar
  • 3,095
7votes
3answers
2kviews

Can not upgrade Aurora RDS Postgres version from 12 to 13

I am trying to upgrade Aurora RDS Postgres cluster db.r5.xlarge from version 12.7 to 13.3. I choose Engine version 13.3, default DB cluster parameter group and DB parameter group default.aurora-...
user avatar
  • 940
7votes
1answer
3kviews

Amazon Aurora Replica

I have a big database (~250GB) in Aurora getting lots of inserts. There's only one instance, so I'd like to create a replica for redundancy. While we are doing nightly snapshots, we would prefer a ...
user avatar
  • 9,181
7votes
1answer
19kviews

How to disable foreign key constraints in postgresql

I'm using AWS Aurora Postgres and using DMS to migrate from RDS postgres to Aurora PG. In order to perform the FULL LOAD I want to disable foreign key constraints and triggers on all the objects. I'm ...
user avatar
  • 687
7votes
2answers
5kviews

Does Amazon Aurora Postgres support lambda invocations?

From what I could gather in AWS's documentation, Aurora MySQL supports invoking lambda functions as triggers: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/AuroraMySQL.Integrating.Lambda.html ...
user avatar
7votes
2answers
2kviews

DeletionPolicy:Snapshot cannot be specified for a cluster instance, use deletion policy on the cluster instead

I am trying to create RDS cluster and aurora instance using the cloudoformation template below: { "AWSTemplateFormatVersion" : "2010-09-09", "Description" : "example setup", "Parameters" ...
user avatar
  • 2,884
7votes
3answers
3kviews

Does Elastic Beanstalk support Amazon's Aurora DB?

In the Oregon region, Elastic Beanstalk let's me select "aurora" from a list of RDS databases. However, when I try to launch the application, I get this flash message: DBEngine: Invalid option value: ...
user avatar
  • 111
7votes
2answers
8kviews

Occasional 'temporary failure in name resolution' while connecting to AWS Aurora cluster

I am running an Amazon Web Services RDS Aurora 5.6 database cluster. There are a couple of lambda's talking to these database instances, all written in python. Now everything was running well, but ...
user avatar
7votes
1answer
3kviews

Which endpoint to connect to for read/write operations using AWS Aurora PostgreSQL Database Cluster

I have an application (AWS API Gateway) using an Aurora PostgreSQL cluster. The cluster has 1 read/write (primary) and one reader endpoint. At the moment, my application connections to the specific ...
user avatar
  • 1,933

15 30 50 per page
1
2 3 4 5
26