Stack Overflow
Stack Overflow

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.

1558 questions
62
votes
13 answers

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, I select RDS > Instances > Aurora > Serverless…
Phong Vu
  • 2,726
  • 6
  • 24
  • 52
50
votes
3 answers

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 RDS MySQL MySQL on EC2 instances I see Amazon…
Khalid Al-Mutawa
  • 829
  • 1
  • 9
  • 16
50
votes
3 answers

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 the Aurora documentation states that Aurora…
Hard worker
  • 3,916
  • 5
  • 44
  • 73
45
votes
2 answers

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 the name of the Database is optional, and no…
Vinícius Queiroz
  • 849
  • 1
  • 7
  • 19
34
votes
0 answers

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

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-specific. Are these states any indicators of…
Nikhil Gaur
  • 1,280
  • 3
  • 19
  • 40
34
votes
3 answers

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 would be the best way to handle the situation?
Wei Zhu
  • 617
  • 1
  • 7
  • 14
30
votes
3 answers

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 read-only though, so why is this happening?
sashoalm
  • 75,001
  • 122
  • 434
  • 781
26
votes
6 answers

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 MySQL 5.7 I dont see any option in restore snapshot…
Satish Gadhave
  • 2,880
  • 3
  • 20
  • 27
25
votes
3 answers

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 unacceptable, what should I do to avoid downtime? Here…
troy
  • 2,145
  • 2
  • 23
  • 31
23
votes
5 answers

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-serverless.create.html) Form my understanding,…
howard.h
  • 808
  • 1
  • 8
  • 14
23
votes
3 answers

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?
Dror
  • 1,262
  • 3
  • 21
  • 34
22
votes
5 answers

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 id, first_name, last_name, email, phone: const…
niqui
  • 1,562
  • 1
  • 16
  • 28
22
votes
3 answers

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 ask as a relative newcomer to AWS - what are some…
griffinjt
  • 241
  • 1
  • 2
  • 3
20
votes
5 answers

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 upgrade as pending until the next maintenance…
pendo
  • 792
  • 2
  • 5
  • 27
20
votes
2 answers

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 (Type: All Traffic, Protocol: All, Port: All,…
Hao Chang
  • 355
  • 2
  • 3
  • 12
1
2 3
…
99 100