Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

1
vote
2answers
47 views

Connect to RDS from EC2 instance in a different Availability Zone (AZ)

OK, so I have a VPC with three app servers and an instance of Postgres in RDS. I have a security group called 'rds-staging' that allows inbound connections on port 5432 from a security group called '...
1
vote
1answer
28 views

How do I make an AWS RDS MySQL Read “replica” have a different schema?

Rather than using the AWS CLI/UI to create a read replica, I would like to create a DB instance with a "close enough" schema and SET it to be the replica. I need to make a schema change (a collation ...
0
votes
0answers
14 views

AWS MySql RDS migrate to AWS Aurora without taking downtime in diffrent region [closed]

I've AWS MySQL RDS instance located at Singapore, and I'm planning to migrate it to AWS Aurora (Mumbai). This process roughly takes about 30-40 minutes. I don't want to take any downtime while ...
2
votes
1answer
19 views

Is it possible to connect to a non publicly available RDS instance from SequelPro?

I have a MySql AWS RDS instance inside a VPC. I was wondering if it is possible to make the RDS instance NOT publicly available, but still be able to somehow connect to the DB via SequelPro or ...
0
votes
3answers
4k views

Remote Server can't access RDS Database

I'm having problems accessing my Amazon RDS MySQL Database from my server. I get this:- [Thu Sep 22 13:45:33 2011] [error] [client xx.xx.xx.xx] PHP Warning: mysqli::mysqli() [<a href='function....
3
votes
1answer
114 views

How to calculate current IOPS usage and IOPS credit count and graph on AWS RDS

I have a running Mysql db.m3.medium RDS instance at AWS, running with 20GB SSD as in: RDS machine description Last hour write and read operations went as following: Disk operations It looks like max(...
0
votes
1answer
16 views

importing data into Amazon RDS extremely slow

I need to import a PostgresSql db from an old server into a new Amazon RDS. I created a db dump file, connected to my RDS via pgAdmin, and started to import pgAdmin console (\i dump_file.sql). ...
4
votes
2answers
430 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 ...
0
votes
1answer
21 views

Can't connect MySQL EC2 master to RDS slave

I am having issues setting up replication between a MySQL RDS instance and an external master on EC2. As far as I can tell, everything is set up correctly but the slave never reaches the master and ...
0
votes
1answer
11 views

HY000 General Error on RDS

I have just set up my Laravel (PHP) project on Amazon with EC2 and RDS. Using MySQL 5.7. However, I've stumbled upon an error after I log in. I can register a user just fine, but when I log in, I get ...
1
vote
2answers
88 views

Track what is causing AWS RDS to use insanely high bandwidth

We are having a high traffic (100K hit/day) Drupal news website hosted on AWS. Its behind cloudflare & 2 Load Balanced Varnish servers. For some reason the bandwidth usage is very high for RDS. ...
0
votes
1answer
43 views

How to redirect database traffic to a new master on RDS after promoting a read replica?

A lot of RDS's documentation about read replicas contains a magical step along the lines of "direct database traffic to the new master." For instance, their instructions on implementing failure ...
1
vote
1answer
25 views

AWS - Setup elastic beanstalk RDS with an old snapshot

While setting up an elastic beanstalk environment in AWS, it is possible to start it with an RDS instance, so RDS configurations will be present in the elastic beanstalk's config panel. While setting ...
0
votes
1answer
36 views

How do I configure full-text InnoDb functionality in MariaDB on AWS RDS?

I'm in the process of moving to MariaDB on RDS. My tables are up and running and everything looks good, but given that I'm on MariaDB 10.0.24, I'm considering switching a couple of my MyISAM tables ...
0
votes
1answer
24 views

How to add an existing RDS Database to a running stack?

I'm creating a cloud formation template that I would like to use to run and create an environment. The only problem is that I have an existing database that I would like to form a part of this stack. ...
1
vote
1answer
23 views

AWS RDS host instance creation fails: “hardware error”

I'm trying to create a MySQL RDS host instance on AWS (via Ansible) and getting the following error: The database instance has been put into STORAGE_FAILURE due to a hardware failure It happens ...
0
votes
3answers
56 views

Verifying the reason why people say it's not a good practice to let an app connect to your db directly

I'm working with postgre (AWS RDS) for my db and using node (AWS EC2) for server side. I'm just starting out so I don't have much context. I always used other third party software like Parse for DB so ...
0
votes
1answer
20 views

Reset slow_log tables in RDS of AWS

I enabled the slow_log_query in RDS in AWS. I want to reset the table but i am getting Access denied in PhpMyadmin while truncating . Any Idea to make it possible .
3
votes
3answers
4k views

AWS RDS (SQL Server): SSL Connection - The target principal name is incorrect

I have a Amazon Web Services (AWS) Relational Database Service (RDS) instance running SQL Server 2012 Express. I've installed Amazon's aws.amazon.com/rds certificate in the client machine's Trusted ...
4
votes
1answer
186 views

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

Upgrade RDS to new instance type?

We have a db.m3.large RDS MySQL instance in us-west-2 w/ multi-AZ that we need to upgrade to a larger instance type (and would like to move to current generation, as well). However, for the last 2 ...
1
vote
1answer
31 views

Why is there a delay with executing queries on my RDS instance

I have an application running on an ec2 m3 instance and mysql running on an dRDS instance. They're both in the same, region, VPC hwoever they appear to be in different availability Zones. The issue ...
1
vote
1answer
35 views

Amazon RDS Replication

I'm having an issue with working with Amazon RDS in itself, is there a way through RDS to create a seperate RDS instance and have RDS Server 1 replciate to RDS Server 2? I cannot seem to figure out ...
0
votes
1answer
44 views

How do I view the RDS_ prefixed environment variables in AWS ElasticBeanstalk?

If you set up RDS with ElasticBeanstalk how can you go into the box (via eb ssh) and view the environment variables that are set when you apply RDS to your EB Instance? Amazon automatically sets up ...
0
votes
2answers
377 views

Installing testlink on Amazon EC2 instance

I have created an Amazon EC2 instance to host a testlink server with RHEL. I have successfully configured mysql client, Apache and PHP, but when I try to install it and create the DB, I'm unable to ...
6
votes
2answers
3k views

How to Rename a Database on a SQL Server Amazon RDS Instance?

Attempts via SQL Server Management Studio and Transact SQL to rename a database hosted on a SQL Server Amazon RDS instance result in the following error. User does not have permission to alter ...
0
votes
1answer
82 views

RDS Mixed replication, master in EC2-Classic, replica in VPC (MySQL)

I have a heavy used RDS instance (MySQL) in EC2-Classic with three read replica instances. We're on plan to move some of our micro-services into VPC and some of them need to read on those replica ...
3
votes
1answer
2k views

Possible to join an Amazon RDS SQL Server 2008 instance to a Windows Domain?

We're planning on using an Amazon RDS MS SQL Server 2008 instance in our Amazon VPC. Since we don't have access to the underlying OS for RDS, I was wondering if it's at all possible to join an RDS ...
2
votes
2answers
109 views

How to do offsite AWS RDS PostgreSQL backups?

As a measure to mitigate against catastrophes such as a malicious entity gaining full access to our AWS account and deleting everything, I am in the process of setting up offsite backups for our ...
2
votes
4answers
4k views

Allow access to RDS instance from EC2 instance on same VPC

I am having trouble gaining access to a MySQL RDS instance. I am trying to connect to the RDS instance from an EC2 instance. Both the RDS instance and the EC2 instance are contained within the same ...
0
votes
0answers
85 views

Too Many database connections on Amazon RDS dropping connection

I need to import a large user base in my application. But while stress and load testing I found that, after 200-300 concurrent requests, mysql starts rejecting the calls and gives the below error. ...
8
votes
2answers
9k views

First attempt to migrate EC2 MySQL to Amazon RDS no going well - SUPER privileges

I've been trying to move an existing db from MySQL running on EC2 to a new Amazon RDS instance (an experiment to see if we can move across). So far, it's not going well. I'm stuck at the initial ...
5
votes
3answers
6k views

How do you transfer AWS RDS snap shot to a different AWS account

I have an RDS database that I need to transfer a snapshot of to another AWS account. I understand there are issues being able to do this between availability zones so I'm really unsure if this is ...
1
vote
0answers
15 views

What happens when we remove the SnapshotIdentifier from our Cloudformation config

When we spun up our Cloudformation stack, we restored our DBCluster from a snapshot. We are now in the process of updating our stack. What will Cloudformation do with our DBCluster if we remove the ...
1
vote
0answers
17 views

MariaDB on Amazon RDS - Initial setup user grants and permissions

I'm trying to learn more AWS, and have an EC2 setup and an RDS setup running MariaDB. When I created the RDS instance, it asked for user/pass for the initial user, and created 'rdsadmin'@'localhost' ...
4
votes
1answer
333 views

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

when do amazon RDS instances change internal IP addresses?

So I hear that RDS instances can change their IPs unexpectedly. What does that mean, exactly? When MS updates cause a reboot? When the DB backup occurs? When the moon changes phases? I am not ...
1
vote
1answer
31 views

how to identify and report bad RDS hardware

Recently we [finally] migrated all of our production hardware from the deprecated default networking into VPCs including EC2 and RDS nodes. Everything went pretty well except when we started to run ...
1
vote
0answers
68 views

Cannot connect to remote MySQL server (RDS)

When I am trying to connect to RDS from my vps, it says connection refused. When I tried connecting it from local or other vps, it worked fine. I figured out that it must be a firewall issue on my ...
0
votes
0answers
17 views

amazon RDS vs automated snapshot

Hello running a wordpress website and I want to know If I need an RDS instance. I am curious because RDS has automated backups but It's also possible to add a script to run an Automated snapshot.
0
votes
1answer
23 views

Backing up website that uses amazon ec2 and RDS as database

Hello I'm currently using Amazon ec2 instance to run a wordpress website OS is amazon linux AMI and I'm using RDS as my database I need to back up my website without downtime is that possible? RDS ...
4
votes
1answer
141 views

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 ...
3
votes
3answers
7k views

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

Public Amazon RDS database?

Is there any way to add a wildcard security group to Amazon RDS? I'm trying to connect from an EC2 under the same account, but had no luck with the security groups. So I'm resorting to just opening ...
0
votes
0answers
33 views

Restrict RDS users to particular region

I am trying to create a policy where I can restrict users to access different region RDS. However I want to give them admin access to only one region i.e. ap-southeast-1. I have created some policies ...
9
votes
2answers
3k views

Is it possible to force Re-creation of EC2::Instance or RDS::DBInstance in amazon cloudformation?

It's possible to force the re-creation of a EC2 or RDS instance using cloudformation stacks? My stack goes stuck in a point where simply destroying and creating the resource will fix it, instead of ...
0
votes
1answer
78 views

Amazon RDS and Auto-Scale EBS: Security Groups

I have the following setup on Amazon AWS: An Auto-Scaling Group An ELB An RDS database Everything is in the default VPC The only thing about this setup that I don't quite understand yet relates to ...
4
votes
1answer
196 views

If you can't change the RDS endpoint of an AWS Beanstalk instance, how do you do a blue/green deployment?

From what I can tell, one can't change the Amazon RDS (RDS) endpoint of an existing Elastic Beanstalk (EB) instance? If that is the case, than you can't have your code deployed to a stage server, ...
2
votes
1answer
154 views

What is the meaning of red stripe next to RDS instance name?

In AWS RDS web console, what is the meaning of red stripe next to RDS instance name (read replica pair)? Also, in 'Replication' tab, both on replica master and slave, Read Master instance name is ...
0
votes
0answers
1k views

MySQL RDS Instance full

I have a MySQL instance on Amazon RDS, with 6GB of storage. All databases installed into this instances weight 500MB. Today the server had no space available. How can I identify the problem? This is ...