Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

0
votes
0answers
41 views

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 ...
-1
votes
0answers
5 views

aws cloudformation iam policy to restrict certain rds actions

I am working on a cloudformation script that should only be able to perform certain actions. I have the following: { "Action": [ "ec2:AuthorizeSecurityGroupEgress" ], "Condition": ...
2
votes
2answers
1k views

When to increase AWS RDS MySQL Server instance to larger CPU/RAM?

I'm wondering at what stage do I need to increase the image for the RDS MySQL server to a larger CPU/RAM instance. The CPU utilization graph is near 0. The Avg Free Memory is around 150MB. The Avg ...
0
votes
0answers
33 views

AWS RDS subnet/az requirement doesn't work with virtual UTM

Background: I want to put an AWS RDS instance into a VPC that has a virtual UTM as its internet gateway. Virtual UTM is an normal EC2 instance with 2 network connections, one internal, one external. ...
4
votes
3answers
2k views

How do a I edit .conf file for a postgres AWS RDS?

I would like to alter pg_hba.conf in my postgres RDS instance so that I can use cert authentication. I have found the Parameters Group manager in the RDS which allows me to alter parameters but it ...
1
vote
2answers
6k views

Amazon RDS - SQL Server - Master User Privileges

I created an RDS instance with SQL Server Express Edition on it. The instance setup was all fine, and I also succeeded connecting to it. But once connected using the master user, I cannot create any ...
0
votes
1answer
19 views

On a pfsense router how would I redirect one IP to another?

I have a poorly made piece of software at work that only asks for a IP when connecting and cant use URL and I cant get a static IP for the database its connecting to (Amazon RDS). I was wondering if ...
1
vote
2answers
824 views

Can Amazon Elastic Beanstalk auto-scale Amazon RDS?

I'm planning to run a PHP/MySQL application using Amazon Elastic Beanstalk. In the settings I can define when it should launch new instances automatically (Auto-Scaling). However, as I understand ...
0
votes
1answer
120 views

Clone database or copy data from RDS MSSQL DB to local database

Is there anyway I can clone an amazon RDS MSSQL DB to my ec2 instance local DB? And this has to be done through powershell also. Basically I need backup of RDS MSSQL DB in sql or bak extension, but ...
0
votes
0answers
26 views

Create RDS Read-Replicate in a separate region using VPC

We have a MySQL RDS instance in a VPC, and want to setup a read-replicata in another region. Unfortunately since our RDS instance is in a VPC, we don't appear to have the option to replicate across ...
17
votes
4answers
13k views

Why can't I connect to Amazon RDS after setting it up?

So, I just created the Amazon RDS account. And I started an instance of database. The "endpoint" is: abcw3n-prod.cbmbuiv8aakk.us-east-1.rds.amazonaws.com Great! Now I try to connect to it from one ...
3
votes
2answers
2k views

Downtime for increasing RDS storage?

I am looking to increase storage of two RDS instances (just the storage space allocated, not the instance type or other parameters). The documentation at ...
6
votes
2answers
6k views

Amazon RDS Instances: db.m1.large vs db.m3.large

Recently, Amazon announced new instance types for RDS. Currently, we are running db.m1.large, and it looks like the new db.m3.large is comparable but cheaper. Before moving these over, I wanted to ...
0
votes
1answer
156 views

AWS RDS CLI: AccessDenied on CreateDBSnapshot

I want to use the AWS RDS command line tool to create a snapshot of my database my-database using create-db-snapshot. I have created a special backup role in IAM with a policy that allows me to ...
3
votes
3answers
1k views

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 ...
0
votes
2answers
930 views

Can't connect from EC2 to RDS via PHP. I can directly thought

I've set up an EC2 instance it has mysql and php-mysql installed (not mysql-server). I've set up an RDS instance and set the security group to the EC2 instance. I can connect via the command line ...
14
votes
1answer
7k views

What is “freeable memory”?

Amazon RDS has a metric for 'freeable memory'. It appears to go up & down in a sawtooth pattern. This leads me to believe that it's memory that is being used by MySQL for caching and that when ...
-1
votes
1answer
85 views

What are my options to run MS SQL 2012 on Amazon RDS for development if I only have MSDN license? [duplicate]

I want to run MS SQL 2012 SE BYOL on Amazon RDS under my own MSDN license but it looks like MSDN license doesn't allow me to run MS SQL unless I host it on the dedicated hardware Microsoft Volume ...
1
vote
2answers
110 views

Amazon RDS on solid state drives

I am planning to design a cloud based application which leverages the MySQL provided using Amazon RDS. I wish to setup read replicas for the data which I have obtained on solid state drives. Does ...
-1
votes
1answer
70 views

Why the latency increases on highload? [closed]

We have a system built on AWS. We use Beanstalk, we have autoscaling, our database (mysql) is hosted on RDS. We use apache and php. We wanted to test our system on highload. So, we chose large ...
9
votes
2answers
3k views

How to associate an existing RDS instance to an Elastic Beanstalk environment?

I have created my RDS instance before creating my Elastic Beanstalk environment. The two are working together with no problem, but I'd like them to be linked together, and have the RDS parameters ...
4
votes
2answers
4k views

AWS RDS MySQL / Slow Query Log

I'm trying to analyze slow queries on my system and I read that I should enable the "Slow Query Log'. I curious how I can I view this log when I'm using an instance of MySQL hosted on Amazon Web ...
2
votes
1answer
64 views

What is the best way to share an AWS RDS instance across multiple Stacks?

I'd like to create one larger RDS instance and share it across OpsWorks stacks so I can pool the database resources across multiple applications. Here is a reference to the OpsWorks docs for ...
1
vote
2answers
87 views

AWS RDS mysqldump hanging

I am attempting to migrate data between RDS MySQL instances. I cannot use snapshots because, with this migration, I want to encrypt the underlying disk and upgrade versions (5.1.73a to 5.5.41). The ...
0
votes
0answers
56 views

Elastic search custom mysql server

I want to use ElasticSearch nodes with Amazon RDS servers. How I can do this? The idea is to have the ElasticSearch feature only with a remote DB.
0
votes
1answer
913 views

How to move RDS database to different VPC

I didn't select a VPC when creating a MySQL RDS database, so it created it inside an auto-generated "default" VPC. I'm now unable to add it to any of my pre-defined security groups, or access it from ...
-1
votes
1answer
27 views

What happens if I exceed the initial database size of RDS from Amazon AWS?

When creating an Amazon RDS, I get asked for the size I want the database to be. If I set this to 5 GB, then what happens when the database size hits the 5 GB and exceeds it?
-1
votes
2answers
63 views

Who is responsible for performing the query EC2 or RDS?

Normally I run my own MySQL server (within EC2), but I was looking for the possibility's of RDS ( https://aws.amazon.com/rds/ ). As I understand RDS is (directly after setup) optimized for ...
0
votes
1answer
67 views

MySQL spends too much time cleaning tmp tables

I'm running some Django migrations on an AWS RDS MySQL instance. My team has tested the migrations very thoroughly and they ran fine (even taking less than 30 minutes when run on our laptops against a ...
0
votes
1answer
71 views

RDS replication from a remote master outside of my VPC

I'm attempting to replicate from an external MySQL master to an RDS instance. I don't really want to be sending data in the clear over the Internet, so I have an EC2 instance that I have set up an ssh ...
1
vote
0answers
139 views

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 ...
-1
votes
1answer
64 views

Custom domain name for AWS RDS

What possible ways to translate entry point like my-name.ck4k21dvamqbq9.eu-west-1.rds.amazonaws.com:5432 to db.domain.com? For own instances we use map in /etc/hosts based on private ip. Storing ...
1
vote
1answer
63 views

The more threads the less IOPS?

I've just started trying out AWS. I have a Postgres micro instance on RDS and I'm running a crawler on a c4.large. When I have just one spider (one thread), I get about 10 write IOPS. but if two ...
1
vote
1answer
38 views

How to implement table security without SUPER privilege?

A MAJOR provider of cloud-based MySQL does not grant the SUPER privilege to the master user. The provider is Amazon RDS, but my question isn't about Amazon RDS specifically, it's for the general case ...
1
vote
0answers
98 views

How to change permission of users in RDS?

We have created a MySQL RDS instance on AWS called "lolbob" and while dumping our data over port 3306 using the user that was created during instance creation (also called "lolbob") it fails because ...
0
votes
0answers
97 views

EC2 instance can't connect to RDS

I have created an EC2 instance and an RDS instance. Using Ubuntu and MySQL, RDS instance is public and not A-Z. I have created a security group that allows 3306 from anywhere on both Ingoing and ...
3
votes
1answer
47 views

Is it unusual for a database client to install the server's SSL certificate?

We use Amazon RDS for our databases at work. Recently we got an automated email from Amazon stating they'd be updating the SSL certificates and that if we didn't upgrade our database instances within ...
0
votes
1answer
213 views

How to upgrade an RDS SQL Server Instance to an SSD

I'm trying to upgrade my RDS SQL Server 2012 instance from magnetic storage to an SSD. It is an instance class of db.m1.large with bring your own license. I've tried modifying the storage type, but ...
0
votes
0answers
17 views

SQL Server 2012 Web uses max 4CPUs. AZ RDS allows deployment on R3.2xLarge (8vCPU) instance. Why?

According to MS documentation, SQL Server 2012 Web Ed. is limited to use 4CPUs. However, Amazon RDS allows it to be deployed on R3.2xLarge instance. BTW, R3.2xLarge offers 8vCPUs. So is it helpful ...
9
votes
3answers
8k views

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 ...
0
votes
1answer
50 views

How to access an AWS RDS host in a VPC

I have setup my first AWS VPC. It has a public subnet, and two private subnets. One of the privates has an RDS instance, and the other is vacant (in a different AZ). I followed the tutorials on AWS ...
8
votes
2answers
8k views

Highest value of max_connections in AWS RDS micro instance

Currently, the value for the max_connections parameter in a MySQL RDS t1.micro server model is {DBInstanceClassMemory/12582880} is 32. Since my server does not allowing any more connections after 32, ...
2
votes
1answer
136 views

Sending Data extremely slow or RDS

I have the following two profiles for a basic SELECT STATEMENT: select count(*) from mturk_completion; Here are the two profiles: # My Local machine, using a local db Status ...
1
vote
1answer
58 views

Debugging a mysql connection

I am trying to figure out how to diagnose a mysql connection issue. When I run a group of queries locally on my machine it takes about 1s to run. When I run that same group of queries on an AWS ...
3
votes
0answers
201 views

TCP congestion collapse

I am experiencing suboptimal performance on an EC2 instance connecting to an RDS instance. This particular instance was built before VPC's existed, so all the traffic is flowing through a single ...
0
votes
2answers
70 views

How to create hostname alias WITHOUT IP address?

In linux , /etc/hosts stores ip aliases. But I want to create a hostname without knowing its IP address. In Amazon RDS , it's endpoint is a long domain name such as : ...
0
votes
0answers
78 views

PHP FPM, chroot can't connect to AWS RDS

I've been experimenting with chroot'ing php-fpm pools via the built-in chroot method in php's pool config. This is for the purpose of hosting multiple wordpress websites on the same AWS EC2 instance. ...
0
votes
1answer
248 views

Can't connect to RDS MySQL

So, I created a new DB and my EB app is reaching it fine, but I can't seem to access MySQL from my computer. When I try to run: mysql --host=123.abc.us-west-2.rds.amazonaws.com –-port=3306 –u myname ...
2
votes
1answer
694 views

Why can't I create a superuser in AWS Postgresql instance?

I have an AWS EC2 instance connecting to an RDS instance (Postgresql). When I created the RDS instance, I told it the DB root's username was: my_user1 and the password was password1. Now I'm ...
3
votes
1answer
147 views

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 ...