Amazon RDS (Relational Database Service)

learn more… | top users | synonyms

0
votes
0answers
20 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 ...
1
vote
1answer
17 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 ...
-1
votes
3answers
48 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
10 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 .
0
votes
1answer
17 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. ...
0
votes
2answers
47 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
25 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 ...
1
vote
1answer
23 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 ...
0
votes
1answer
25 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
1answer
42 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 ...
1
vote
2answers
54 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 ...
0
votes
0answers
52 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. ...
1
vote
0answers
13 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' ...
1
vote
0answers
12 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 ...
4
votes
1answer
155 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
0answers
22 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
26 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 ...
0
votes
0answers
16 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 ...
1
vote
0answers
64 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
30 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 ...
0
votes
1answer
59 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
130 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, ...
1
vote
0answers
83 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 ...
0
votes
0answers
4 views

Copy Production MariaDB RDS to Develop MariaDB RDS

What I need to do is to replicate on Demand my production RDS Database to my Develop RDS Database. My production RDS Database has backup, so I have snapshots, but I only found option to create new ...
4
votes
1answer
134 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 ...
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 ...
1
vote
1answer
70 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
0answers
47 views

Modify MySQL information_schema (specially create_time) on AWS RDS?

I am trying to modify the create_time of an entire database, tables, etc. I have found that information_schema TABLES stores the create date of the tables on the column CREATE_TIME. Unfortunately ...
0
votes
0answers
30 views

What is the benefit of the RDS Environment Variables being set for EC2 instances?

Background I am running an ASP.NET MVC website running from Elastic Beanstalk. I have an Windows EC2 instance running IIS and an RDS instance in an Elastic Beanstalk environment. The Problem I've ...
3
votes
1answer
58 views

Reducing AWS EC2 Instance and RDS - Is 'low' Network Performance acceptable?

I launched my site on AWS a few weeks ago. I have a m3.medium EC2 instance and a db.m3.medium RDS instance (MySQL database). I've looked at the monitoring for each and this is the average usage for ...
1
vote
0answers
33 views

Advice on management of large MySQL database [duplicate]

I've inherited responsibility for a 400GB MySQL database that is hosted in Amazon RDS. The DB serves an application that relies intensively on DB operations, so version releases frequently involve ...
2
votes
2answers
69 views

Can I access the failover server on AWS RDS?

I am trying to create a working proof-of-concept in AWS for our web application which suddenly needs to scale out very quickly. Currently it is hosted on a local VMware server and we are migrating to ...
0
votes
1answer
141 views

AWS VPC Public Private Subnets - EC2 Instance cannot reach RDS instance

Following rposcibed pattern here: Scenario 3: VPC with Public and Private Subnets and Hardware VPN Access Summary Description: I have configured a VPC with 1 public Subnet and 2 private Subnets Each ...
0
votes
1answer
41 views

20% CPU usage by RDS instance when idle

I have brought up a db.t1.micro PostgreSQL instance in us-east-1 region. It's single availability zone no backups not in a security group that's reachable from the outside world For some reason ...
1
vote
1answer
38 views

AWS Reducing RDS Instance size causes job to run longer

I recently reduced the size of one of our RDS instances from an r3.xlarge to an r3.large. Under usual load this is absolutely fine for this instance. We do however have a morning job that runs that is ...
0
votes
1answer
83 views

Demystifying MySQL Read/Write Ratio on RDS

I am in the process of upgrading/selecting resources for an application powered by a MySQL database running on Amazon RDS. I am considering introducing read replicas and some other strategies to ...
1
vote
1answer
154 views

Permissions for EC2 created by Elastic Beanstalk connecting to external RDS

I am quite new to Elastic Beanstalk and not very proficient with server administration, but I need to set up a Django project on Elastic Beanstalk connecting to external RDS MySQL database. I have ...
0
votes
1answer
90 views

Can't establish a command line connection to RDS MySQL from EC2

I have imported a CentOS VM to EC2, it is running correctly. I created a MySQL RDS. They are both apparently in the same VPC. From the shell in my VM I tried this command: mysql -u root -h ...
1
vote
0answers
45 views

Connect to RDS from EC2 - different AZ

I have set up a RDS instance with Multi-AZ support. It ended up in eu-west-1a. It is setup with "Publically available = YES" I have a EC2 instance in eu-west-1c, from which I want to access the RDS ...
1
vote
0answers
230 views

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 ...
2
votes
1answer
129 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 ...
1
vote
1answer
91 views

AWS Network ACL/Security groups and RDS access

Just want to clarify a few settings on a new Amazon setup I'm creating. I have followed a number of guides and everything appears to be working and secure, I'd just really appreciate if someone who is ...
0
votes
0answers
255 views

AWS RDS MySQL DB unable to connect in MySQL workbench and could not connect using telnet

I am using default VPC and created RDS MySQL instance (Publicly Accessible: Yes) with newly created db security group. I have given Inbound/Outbound rules as All Traffic, ALL, ALL, and Source = ...
1
vote
1answer
231 views

Mysql 5.6 client is unable show UTF8 characters

Mysql databases are hosted on AWS RDS Mysql 5.6 On one of the EC2 Cent OS 6.5 instance, I had Mysql Client 5.1. I used it to execute SELECT queries over the RDS-Mysql. There is one particular query ...
0
votes
0answers
220 views

Memory usage on db.t2.micro

I just brought up an RDS-MSSQL instance which this page says has .6GB of memory. However, the console shows this: I haven't added any databases, but the Memory Threshold looks like its peaking at ...
0
votes
2answers
1k views

AWS RDS MySQL vs Aurora

I read everywhere that Aurora is more performant (claims etc). If that's the case and cost differences are ignored, what would be the reason for any one to use RDS MySQL? What are the technical ...
3
votes
0answers
207 views

AWS: RDS + CloudFormation – VPC peering

So here's my situation: We are a young startup scaling up and we decided to give Mesosphere DCOS Community edition a try. The community edition deploys a stack of Masters, Slaves and LB's over AWS ...
0
votes
1answer
168 views

Amazon RDS CPU is about 55-65% after optimizing some Mysql tables

I was having high RAM consumption and, looking for a solution, I executed the script mysqltunner to monitor possible optimizations in the Mysql database. Its first advice was I had to run OPTIMIZE ...
1
vote
1answer
65 views

Connection / Tunnel to AWS RDS from EC2

I'm working on a website hosted in a VPC on AWS. Yesterday, we moved the mysql server from a EC2 instance to a RDS instance to allow the mysql server to perform better. So, before, when I wanted to ...