Stack Overflow
Stack Overflow

Questions tagged [amazon-rds]

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.

Amazon RDS (Relational Database Service) is an online storage web service offered by Amazon Web Services. Amazon RDS is a web service that makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks, freeing you up to focus on your applications and business.

References

Related tags:

6750 questions
66
votes
11 answers

Are Amazon RDS instances upgradable?

Will I am able to switch (I mean upgrade or downgrade) Amazon RDS instance on need basis or do I have to create a new afresh and go through migration?
Kabeer
  • 4,138
  • 7
  • 40
  • 62
62
votes
5 answers

Is there a way to run initial SQL when creating an RDS database instance using CloudFormation?

I am creating an RDS instance using CloudFormation using this: "Resources": { "myDB": { "Type": "AWS::RDS::DBInstance", "Properties": { "AllocatedStorage": "5", "DBInstanceClass":…
Mike Hogan
  • 9,933
  • 9
  • 41
  • 71
59
votes
3 answers

Should I stick only to AWS RDS Automated Backup or DB Snapshots?

I am using AWS RDS for MySQL. When it comes to backup, I understand that Amazon provides two types of backup - automated backup and database (DB) snapshot. The difference is explained here. However, I am still confused: should I stick to automated…
James Wise
  • 1,715
  • 4
  • 16
  • 21
59
votes
10 answers

how to run command "mysqladmin flush-hosts" on Amazon RDS database Server instance?

I got a database server failure, says host is blocked because of many connection errors. It ask me to unblock with 'mysqladmin flush-hosts' how and where should I run this command to our amazon rds database server? thank you
user955461
  • 631
  • 1
  • 6
  • 5
59
votes
3 answers

AWS RDS instance upgrade down time

I have a few questions in regards to upgrading the RDS instance. What is the downtime when upgrading the instance from let's say small to large. Is the downtime relatively similar when you go and change any instance type(small, large, xlarge) or…
Chuck Morris
  • 1,128
  • 1
  • 8
  • 13
56
votes
7 answers

Can I CREATE TRIGGER in an rds DB?

I'm trying to create a trigger on a table in my Amazon RDS database, and I can't seem to make it happen. I tried to create a trigger on a table in the mysql client I use (Navicat), and got the error that I needed the SUPER privilege to do so. After…
tedders
  • 1,012
  • 2
  • 11
  • 22
54
votes
2 answers

How many databases can I create on a single Amazon RDS instance

How many databases can I create on a single Amazon RDS instance? I need to move from Xeround to another server (they are closing for public clouds). My two options are either create a single EC2 instance with EBS backed (10,000 iOPS) or RDS. I have…
Liron Harel
  • 10,819
  • 26
  • 118
  • 217
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
46
votes
9 answers

How do I change the publicly accessible option for Amazon RDS?

When you create a new amazon rds instance, you are offered to choose true/false for the "publicly accessible" option, Is there a way to change this for an existing instance?
Ron Gross
  • 1,474
  • 5
  • 19
  • 34
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
45
votes
4 answers

can AWS Lambda connect to RDS mySQL database and update the database?

I am trying to connect AWS Lambda function to RDS mysql database. I just wanted to update the database from my lambda function. Is it possible to access RDS by specifiying IAM Role and access Policy?. I can connect to mysql databse using mysql…
ARUNBALAN NV
  • 1,634
  • 4
  • 17
  • 39
44
votes
4 answers

AWS RDS PostgreSQL error "remaining connection slots are reserved for non-replication superuser connections"

In the dashboard I see there are currently 22 open connections to the DB instance, blocking new connections with the error: remaining connection slots are reserved for non-replication superuser connections. I'm accessing the DB from web service…
michael
  • 3,835
  • 14
  • 53
  • 90
42
votes
10 answers

Using PHPMyAdmin to administer Amazon RDS

I can't get PHPMyAdmin to connect to my Amazon RDS instance. I've granted permissions for my IP address to the DB Security Group which has access to this database I'm trying to access. Here's what I'm working with... …
Ben
  • 60,438
  • 111
  • 314
  • 488
42
votes
3 answers

How do I kill a process in MySQL running within Amazon RDS?

I’m using MySql 5.5.37. As root, I’m trying to kill a transaction that’s locking some tables. I run SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX\G and get the output … *************************** 6. row *************************** …
Dave
  • 15,639
  • 133
  • 442
  • 830
1
2
3
…
99 100