Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [amazon-rds]

Amazon RDS (Relational Database Service)

Amazon RDS (Relational Database Service) is a distributed relational database service based on popular variants, running in the cloud. Currently supported are:

  • MySQL
  • Oracle
  • SQL Server
  • PostgreSQL

Additional Documentation:

549 questions
9
votes
2 answers

AWS add option group

I asked this on the AWS forum but not getting much traction. My root problem is that I'm trying to restore a MS SQL Server RDS database and getting the error message "Database backup/restore option is not enabled yet or is in the process of being…
nasch
  • 151
  • 1
  • 1
  • 9
9
votes
2 answers

AWS DynamoDB Cost efficiency

I have to move a business application into the cloud, therefore cost is one of my biggest concerns. DynamoDB seems to be a good option, while a big part of our data is able to migrate from relational database to NoSQL. It's said, AWS DynamoDB is…
Diligent Key Presser
  • 223
  • 2
  • 8
9
votes
1 answer

Amazon RDS automated hourly snapshots

I have been looking on Amazon RDS for a way to automatically created incremental snapshots for RDS databases. I want to create hourly snapshots. Can anyone help me ?
Tony
  • 445
  • 2
  • 6
  • 14
9
votes
4 answers

AWS RDS connection count

I am using AWS RDS with MySQL for a project and have a "large" instance. The documentation is clear on what this means as far as compute resources and RAM goes, but I can't find anything that documents how many open database connections that I can…
wmarbut
  • 301
  • 2
  • 4
  • 12
9
votes
2 answers

Amazon RDS: What are IO Requests?

I have an RDS instance that is costing me a lot of money. From my account activity on amazon I see that the instance has had about 800,000,000 IO requests over the past 7 days. To give you a little perspective, my app only gets about 6,000 unique…
Abe
  • 93
  • 1
  • 3
9
votes
4 answers

MySQL query very slow on Amazon RDS but really fast on my laptop?

I would love to know if anybody knows why this is happening. i've just migrated over to Amazon RDS for our website and our biggest query which takes .2 seconds to execute on my macbook takes 1.3 seconds to execute on the most expensive RDS…
Luc
  • 219
  • 1
  • 2
  • 4
8
votes
1 answer

RDS snapshot: how long does I/O suspension occur?

As we're relying on RDS Postgresql manual backup for our backup strategy, we encountered the issue with the possible downtime of the RDS instance (single AZ) during snapshot creation. According to AWS: Creating this DB snapshot on a Single-AZ DB…
Arcobaleno
  • 191
  • 1
  • 3
8
votes
2 answers

Any drawback in using AWS RDS "dev/test" instance for production?

When we create a RDS instance, we are asked whether it is intended for a production environment or not. We can't figure out what is the real difference between those. It looks like "dev/test" doesn't allow for IOPS provisionning and multi-AZ…
Balmipour
  • 314
  • 1
  • 3
  • 10
8
votes
1 answer

AWS RDS db.t2 instance performance thresholds & monitoring

We have been rolling out a standard web server configuration for mainstream CMS software like Drupal & WordPress, with the server & storage on EC2 / EBS and the database for those software packages in RDS / MySQL. Usually we go into production…
rphair
  • 173
  • 3
  • 9
8
votes
2 answers

Amazon RDS Instance slowly losing free diskspace

A while back the server running my instance had 20GB of EBS storage. It then started getting disk storage errors, so I increased it to 40GB. Then again, storage missing errors so I increased again to 60GB. (So this is a 60GB RDS Instance) You can…
Laykes
  • 441
  • 5
  • 14
8
votes
1 answer

AWS: Should my EC2 and RDS instances be in the same Availability Zone?

I just noticed that all of our EC2 instances are in zone us-west-2b, but our Multi-AZ RDS instance is in us-west-2a. Performance-wise everything seems to be okay, and it will be a hassle to "move" the instances to one place since you have to stop…
DOOManiac
  • 791
  • 6
  • 12
  • 26
8
votes
1 answer

Amazon: How do I know if I need Provisioned IOPS?

We recently moved to Amazon Web Servers and are still learning our way around. Our EC2 Web instance and our RDS MySQL instance (right now we only have 1 of each) seem to be chugging along okay. But I was wondering if we could get even better…
DOOManiac
  • 791
  • 6
  • 12
  • 26
8
votes
4 answers

Ways to auto scale MySQL servers?

I run a site which has high traffic surges and because of that auto scaling solutions is very profitable for this case. Currently the web server is able to horizontally auto scale but the bottleneck is on the MySQL server. I have tried with Amazon…
Zillo
  • 111
  • 2
  • 4
8
votes
2 answers

Is there anything about going from gp2 to gp3 storage which requires careful consideration?

I'm maintaining an AWS RDS database (db.m6g.xlarge) which has a 750GB disk. This gives 2250 IOPS and the RDS monitoring tells me that the read throughput on average is ~ 50MB/s and write throughput is ~ 2MB/s. The database IOPS hovers around 2250,…
sbrattla
  • 1,578
  • 4
  • 28
  • 52
7
votes
2 answers

Why are database queries running so much slower on AWS RDS?

I've been working on performance-sensitive features. I've been developing locally, running a MySQL server on my Mac. One key query runs in about 1.2 seconds on my machine, which is in the acceptable range for me. Everything was running speedy…
fnsjdnfksjdb
  • 233
  • 3
  • 6
1 2
3
…
36 37