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 :

4797 questions
133
votes
8 answers

What are the respective advantages/limitations of Amazon RDS vs. EC2 with MySQL?

I realize a couple of basic differences between the two, i.e. EC2 is going to be cheaper RDS I wouldn't have to do maintenance Other than those two, are there any advantages to running my database from RDS as opposed to a separate EC2 server…
Macgyver
  • 1,791
  • 2
  • 14
  • 19
124
votes
16 answers

Access denied; you need (at least one of) the SUPER privilege(s) for this operation

So I try to import sql file into rds (1G MEM, 1 CPU). The sql file is like 1.4G mysql -h xxxx.rds.amazonaws.com -u user -ppass --max-allowed-packet=33554432 db < db.sql It got stuck at: ERROR 1227 (42000) at line 374: Access denied; you need (at…
kenpeter
  • 5,152
  • 10
  • 48
  • 73
112
votes
8 answers

MySQL/Amazon RDS error: "you do not have SUPER privileges..."

I'm attempting to copy my mysql database from an Amazon EC2 to an RDS: I successfully did a mysqldump of my database into my root folder using this: root@ip-xx-xx-xx-xx:~# mysqldump my_database -u my_username -p > my_database.sql Then I tried to…
tim peterson
  • 22,033
  • 50
  • 162
  • 279
96
votes
2 answers

How does Amazon RDS backup/snapshot actually work?

I am an Amazon RDS customer and am experiencing daily amazon RDS write latency spikes, corresponding roughly to the backup window. I will also see spikes at the end of a snapshot (case in point: running a snapshot takes appx 1 hour, and in the final…
esilver
  • 25,374
  • 21
  • 112
  • 159
79
votes
4 answers

How to export database from Amazon RDS MySQL instance to local instance?

AWS documentation has this page that talks about importing and exporting data from MySQL server, but it's mostly about import. The only thing I see in their documentation is a way to export 5.6 data using replication, which is documented here. I was…
Srini K
  • 3,067
  • 7
  • 33
  • 46
79
votes
7 answers

Amazon RDS: Restore snapshot to existing instance

I have created a snapshot of my instance and made some unwanted changes in DB. Now I want to restore my instance from this snapshot. When I try to do it - it creates me one more instance, additionally to the one I have. I specify "DB Instance…
SmxCde
  • 3,810
  • 4
  • 18
  • 35
75
votes
5 answers

Amazon RDS (postgres) connection limit?

I've searched the web and browsed the RDS docs, yet I can't seem to find an open connection limit. For what it's worth, I'm planning on using the new Postgres flavor of RDS, but I suppose an answer from the mySQL side of the house would be…
cs44
  • 1,090
  • 1
  • 7
  • 11
74
votes
7 answers

download RDS snapshot

I recently downgraded my EC2 instance. I can no longer connect to RDS. I think it might be that the internal IP is different and now the logins are attached to that specific IP. I haven't been able to figure it out. I would like to be able to…
William
  • 1,105
  • 1
  • 9
  • 18
72
votes
6 answers

Exporting table from Amazon RDS into a csv file

I have a mysql database running in Amazon RDS, and I want to know how to export an entire table to csv format. I currently use mysql server on Windows to query the Amazon database, but when I try to run an export I get an error, probably because…
Kenny
  • 1,031
  • 1
  • 9
  • 12
68
votes
5 answers

Creating A New MySQL User In Amazon RDS Environment

I need to create a new MySQL user with limited permission on an existing Amazon RDS instance. After encountering a couple error messages I was sort of able to do this using the official MySQL Administrator tool and the user now appears in the list.…
Dan
  • 1,370
  • 3
  • 11
  • 17
65
votes
10 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
  • 3,922
  • 6
  • 35
  • 61
62
votes
8 answers

AWS: can't connect to RDS database from my machine

The EC2 instance/live web can connect just fine to the RDS database. But when I want to debug the code in my local machine, I can't connect to the database and got this error: OperationalError: (2003, "Can't connect to MySQL server on…
Aminah Nuraini
  • 13,849
  • 6
  • 73
  • 92
60
votes
2 answers

AWS RDS Provisioned IOPS really worth it?

As I understand it, RDS Provisioned IOPS is quite expensive compared to standard I/O rate. In Tokyo region, P-IOPS rate is 0.15$/GB, 0.12$/IOP for standard deployment. (Double the price for Multi-AZ deployment...) For P-IOPS, the minimum required…
Jee Seok Yoon
  • 4,369
  • 9
  • 28
  • 46
57
votes
9 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
  • 611
  • 1
  • 6
  • 5
57
votes
3 answers

Amazon RDS running out of freeable memory. Should I be worried?

I have an Amazon RDS instance. Freeable Memory has been declining since setup over 1-2 weeks, starting from 15GB of memory down to about 250MB. As it has dropped this low in the last days, it has started to resemble a sawtooth pattern where Freeable…
william tell
  • 3,692
  • 5
  • 21
  • 27
1
2 3
…
99 100