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
5
votes
1 answer

AWS RDS keeps backing up my server on creation

I am using Amazon CloudFormation to create a Stack with EC2 and RDS (Postgres 9.4.4, 5gb, db.m1.small). The RDS instance initiates a backup as soon as it starts. How can I stop RDS from backing it up at startup? Here is the Postgres log: 2016-01-12…
szxk
  • 171
  • 7
5
votes
2 answers

Is it possible to install MySQL extensions on Amazon RDS?

We are about to migrate our existing system from local MySQL instances on the same EC2 to a proper remote Amazon-RDS. Unfortunately there is a functionality called Median that MySQL is missing. Our existing code base is utilising MySQL Infusion UDF…
Houman
  • 1,545
  • 4
  • 22
  • 36
5
votes
0 answers

Bugzilla extremely slow on EC2, RDS PostgreSQL

The Problem I have installed Bugzilla on an EC2 instance, using PostgreSQL RDS as my database. After entering a few dozen bugs, Bugzilla became unbelievable slow, and I get a lot of timeouts. Server load The machine is pretty idle: 14:26:00 up 23…
Adam Matan
  • 13,194
  • 19
  • 55
  • 75
5
votes
1 answer

Assign Elastic IP to RDS instance

Is it possible to assign a fixed Elastic IP to an AWS RDS database instance? If I create a new database instance, the instance gets a random endpoint like myDb.aws6z6uffdfv.us-west-2.rds.amazonaws.com:1433. I would like to map this to a static (and…
Thomas Uhrig
  • 153
  • 1
  • 1
  • 6
5
votes
1 answer

How to troubleshoot slow performance on AWS EC2/RDS?

We recently moved our web servers from some 10 year old boxes to AWS EC2. Usage of the site is currently higher now (it's our busy season) and the site has become much slower, which is unexpected because our instance sizes are much higher than what…
DOOManiac
  • 791
  • 6
  • 12
  • 26
5
votes
4 answers

Amazon RDS Pros/Cons of Multiple DBs per instance

I run two completely independent websites. I am moving their MySQL databases to Amazon RDS. I'm not going to do Multi A/Z deployment - let's remove that variable from this question. I'm not sure whether to create a single RDS instance with two…
Joe Flowers
  • 51
  • 1
  • 2
5
votes
1 answer

What is the Amazon RDS tenancy model?

My organization would like to better understand the Amazon RDS architecture. In particular, my managers would like to understand RDS's "tenancy" model, that is, how the service accommodates multiple customers and how an Amazon RDS DB Instance…
user35042
  • 2,681
  • 12
  • 34
  • 60
5
votes
1 answer

MySQL transaction issue with Django and Amazon RDS

I'm having a problem with a MySQL 5.5 database instance running on Amazon RDS. Periodically (once every couple of days) a transaction will fail to complete and appears to leave the tables locked. Normally the transaction times out and everything…
Richard Owen
  • 51
  • 2
5
votes
2 answers

Amazon AWS RDS Burst Balance vs CPU Credit Balance

I'm trying to understand if I have spec'd my database appropriately. Below is a chart showing the WriteIOPS, CPUCreditBalance and BurstBalance for a t3.xlarge instance of SQL Server. It looks like I'm consuming my BurstBalance in another 15 hours or…
Sean
  • 153
  • 1
  • 1
  • 7
5
votes
1 answer

Why isn't there a character-set-client-handshake RDS parameter for MariaDB 10.2 or 10.3?

MariaDB has a parameter, --character-set-client-handshake, that can allow you to specify that the server should ignore the character set being specified by a client connecting. On RDS, when you create a parameter group for a MariaDB v10.1 instance,…
ilasno
  • 236
  • 1
  • 3
  • 16
4
votes
1 answer

How to migrate snapshot to an existing database in AWS RDS

I currently have two databases, one for production environment and the other one for staging environment. I made snapshot of the production database to migrate it into the staging database. I researched about how to do that, but most of resources…
Jay
  • 189
  • 1
  • 2
  • 8
4
votes
3 answers

Static IP on an AWS RDS Instance/ Opening port 3306 to DNS Endpoint?

So I have previously asked this question over at stackoverflow but I was informed that I should ask it over here also since it seems to be more of a network based question. I did search serverfault for similar questions and came across this one from…
iamdapro
  • 41
  • 1
  • 1
  • 3
4
votes
1 answer

AWS ELB Latency issue

I have two c3.2xlarge EC2 machines with Ubuntu environment both in us-west-2a AZ. Both contains same code with mySQL database from AWS RDS (db.r3.2xlarge). Both instances are added to an ELB. Both has one cron scheduled that runs twice in a day. ELB…
Thamilhan
  • 93
  • 11
4
votes
1 answer

Why the time taken to fetch results of a query for 10,000 times from a RDS is so uneven? (experiment)

tl;dr : Why the time taken to fetch results of a SELECT statement for 10,000 times from a RDS when requested from an EC2 is so uneven? Updated the question with results of small and medium RDS servers While experimenting with AWS for checking time…
Sumit Sinha
  • 159
  • 1
  • 3
4
votes
1 answer

EC2 cannot connect to RDS on VPC. Subnet issues?

I was able to deploy our .NET app using the AWS toolkit for Visual Studio. I set up the RDS database manually (MySQL) and deployed the app using elastic beanstalk (set up on VPC). The issue was that when i tested the signup form on the app running…
BellaGurl
  • 41
  • 2
1 2 3
…
36 37