Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

Questions tagged [amazon-rds]

Amazon RDS (Relational Database Service)

0
votes
0answers
11 views

AWS PostgreSQL RDS much slower than Heroku PostgreSQL

We're in the process of migrating some apps out of Heroku to AWS, and we've encountered a problem with the performance of the database in RDS. We initially tried using an Aurora PostgreSQL cluster, ...
1
vote
1answer
44 views

Audit logs for RDS MySQL not appearing in CloudWatch

I've been trying to get a MySQL instance on Amazon's RDS to send logs to CloudWatch: in particular, both error logs and audit logs. Error logs work fine, they're appearing in CloudWatch, no issues at ...
0
votes
1answer
45 views

Why does an RDS snapshot have storage type?

I was under the impression that the snapshots were stored on S3 and so the original instance's storage type wouldn't be relevant. So why is the storage type listed under snapshots? Is the cost of the ...
1
vote
1answer
21 views

Amazon RDS: Why do I get more IOPS than I have provisioned?

We run a Multi-AZ r4.2xlarge Mysql RDS instance and we provision 2000 IOPS (which costs $400 per month extra). When I check the CloudWatch charts I can see large periods where the Write IOPS are more ...
1
vote
1answer
24 views

How to change RDS KMS Key without losing data?

We have a PostgreSQL database hosted on AWS RDS. When it was created using cloudformation I set it to be encrypted, but didn't set the encryption key. As such it was set up to use the default ...
0
votes
0answers
36 views

Master Master replication between RDS and database instance on EC2 Errno: 1032

I face this error many times with my replication Last_SQL_Error: Could not execute Delete_rows event on table db_name.event; Can't find record in 'event', Error_code: 1032; handler error ...
1
vote
2answers
33 views

Options for giving remote access to private AWS RDS Aurora cluster

We have a production database server which at the moment is not publicly accessible, has no public IP address, and sits in a private VPC subnet. At the moment it is only accessible from applications ...
1
vote
0answers
22 views

RDS CPU Credits decreasing faster than possible

A few days ago, I created a Postgres RDS t2.micro instance. I didn't use it at all beyond connecting to it and verifying that simple queries perform as expected. However, the CPU graph is a bit ...
0
votes
0answers
43 views

How to find and change DB Security Group to VPC Security Group

I have a ElasticBeanstalk environment that I can't update any more: Environment update is starting. Environment health has transitioned from Ok to Info. Application update in progress (...
1
vote
1answer
59 views

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

How to check via aws cli if a specific rds instance exists?

I want my bash script to detect, if an AWS RDS instance with a specific name exists already. This is what I tried: #!/usr/bin/env bash DBINSTANCEIDENTIFIER=greatdb EXISTINGINSTANCE=$(aws rds ...
1
vote
1answer
32 views

AWS VPC Peered - RDS accessing Active Directory Service

I have two aws accounts and I could establish a peering of two VPCs belonging to each account. Also, I was able to launch an EC2 instance one account joining to the AD domain on the other account. The ...
0
votes
1answer
45 views

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

AWS EB and RDS: Invalid storage size for engine name mysql and storage type gp2

I'm trying to deploy my (python/django) application to AWS Elastic Beanstalk, but I am getting the error. Deployments have been working fine for the last few months, so I'm confused what could be the ...
0
votes
0answers
36 views

MySQL RDS Write IOPS high

One of my client is having RDS MySQL DB for which write IOPS is high when compared to read IOPS. Tried increasing CPU and Memory to 8 and 61 GB respectively, but still it is the same. This is a small ...
0
votes
0answers
17 views

Connecting to RDS, created by custom VPC, using MySQL Workbench

I need to get an RDS in region X connected by Elastic Beanstalk from regions Y and Z. I have created RDS in a custom VPC. I need to connect to this RDS from my mac using MySQL Workbench. For VPC, ...
0
votes
0answers
21 views

AWS RDS different user or security group for reader and writer cluster endpoints

I crated an Aurora MySQL cluster with reader and writer instances. I would like to restrict the access to the writer cluster endpoint so that only my application can access it. I would also like to ...
0
votes
1answer
20 views

AWS - VPC and subnet group

In order to create RDS, I need to create a VPC and two subnets attached to it. If I choose 10.0.0.0/16 as IPv4 CIDR for VPC, can you please suggest IPv4 CIDR blocks for the two subnets that I have to ...
1
vote
2answers
84 views

RDS Mysql point in time restore fails - incompatible state

I have an RDS MySQL instance with MySQL version 5.7.19 for which a point in time restore failed with a status of "incompatible-state". Through experimentation I have determined that point in time ...
0
votes
0answers
82 views

Cross-VPC private RDS endpoint resolution from an RDS instance for replication

TL;DR : I'm trying to build cross-account MySQL RDS replication, but RDS seem to resolve DNS endpoints to public IP instead of private for cross-VPC RDS masters. I've set up VPC peering (across two ...
0
votes
0answers
14 views

Changed AWS RDS instance name and now can't connect to the databases

I have a basic Wordpress site setup on AWS in a high-availability setting in two different zones and behind a load balancer, the databases are on AWS RDS with the failover/backup one in the second ...
0
votes
0answers
30 views

Should I use Elastic Beanstalk provisioned RDS instances to host other non-related databases?

I've got a LAMP stack on AWS. I used Elastic Beanstalk to deploy one EC2 instance and one RDS MySQL instance. Separately, I have an extra EC2 box (not managed by EB) hosting three small apps. I ...
0
votes
1answer
38 views

Wordpress installation not accepting AWS RDS credentials

This is a strange one, I have an AWS EC2 instance setup where Im attempting to install Wordpress and use an RDS for the database. I can connect to the database from the instance just fine with mysql ...
0
votes
1answer
636 views

monitoring/troubleshooting aws rds high cpu usage

I have an RDS instance running and it uses an average of 20-30% cpu utilization. Last night it spiked up to 80% for a few minutes and I am trying to figure out why. Error logs show nothing, and I have ...
0
votes
0answers
53 views

Amazon RDS SQL Server permissions with legacy application

I am trying to run a legacy Windows application in AWS without modifying the code. The application uses Windows Authentication for the DB connection so this is what I have set up: a Simple Directory ...
1
vote
1answer
20 views

Copy and launch EC2 and RDS in another account

I need to copy and launch an EC2 instance in another account but the instance is using an RDS instance. I know I can make an image snapshot of the EC2 and the RDS and then launch them on the other ...
0
votes
0answers
72 views

Postgres (on AWS RDS) connects very slowly

I've created a Postgres 9.6 instance on AWS RDS. I can successfully connect from my workstation (using psql), but the initial connection takes 60-70 seconds. Once it's connected, it's perfectly ...
1
vote
2answers
65 views

Bash script in EC2 fails due to permissions

I am not quite experienced with EC2 and want to setup a cron job to create a dump of my RDS's database and copy it into my S3 bucket. #!/bin/bash AWS_ACCESS_KEY_ID=*** AWS_SECRET_ACCESS_KEY=*** ...
1
vote
1answer
78 views

AWS RDS Aurora Mysql swap CNAME in failover

Since a few days ago, I'm testing a RDS Aurora Writer-Reader (like classic mysql Master-Slave). Specifically in its recovery capacity agains a failover in the writer, among other task, RDS should swap ...
2
votes
0answers
231 views

How to associate existing RDS instance to Elastic Beanstalk, with the right storage size?

I found the post How to associate an existing RDS instance to an Elastic Beanstalk environment? and tried to associate my existing RDS instance to Elastic Beanstalk by following it: First, creating a ...
0
votes
1answer
159 views

Does Amazon RDS support multiple oracle databases per instance? [closed]

As you can see the AWS FAQ mentions that we can create only one database per instance for Oracle.
0
votes
0answers
281 views

Connecting to AWS RDS [Warning] IP address 'xxx.xx.x.xxx' could not be resolved: Temporary failure in name resolution

I'm new to AWS and trying to connect using PHP to a test RDS like this $dbhost = 'xxxx.xxxxxxxxxxx.rds.amazonaws.com'; $dbport = 3306; $dbname = 'xxxx'; $charset = 'utf8' ; $dsn = "mysql:host={$...
0
votes
1answer
26 views

Amazon RDS SQL Server Specification

I am about to launch an internal reporting and analytics SQL Server instance on Amazon RDS and am hoping someone can help me out with the answers to a few questions about instance specifications. Here ...
0
votes
0answers
63 views

PHP Has Trouble Connecting To AWS PostGreSQL RDS

I do not use Beanstalk or any AWS service, such as EC2. I've set up a PostGreSQL RDS and I can connect to it with PG Admin 3, but not PHP, despite allowing all protocols in the security group. I'm ...
0
votes
2answers
97 views

If I purchase AWS reserve instance in mid of month, will it cost for full month? [closed]

If I purchase AWS reserve instance (EC2 and / or RDS) in mid of month, will it cost for full month or it will be on pro rata basis ? I have searched on there docs I was not able to find, may be I ...
0
votes
0answers
212 views

EC2 to RDS timeout issue

I'm trying to connect to an RDS database from an instance. Unfortunately the connection times out instead of succeeding. I checked the usual suspects, and can't find a reason why it happens. Here are ...
0
votes
0answers
21 views

RDS instance became unreachable after EC2 instance was launched

These two days I was taking actions that don't have influence on each other from my point of view. But it appears that they did. Could you please clarify what happened. I launched RDS instance db.t2....
0
votes
1answer
131 views

To implement persistent queue, should I go for RDS or DynamoDB on aws?

This is my use case: I have a decoupled application system. One application is accepting requests, validating, and queuing in SQS. Other application is mounted on a cluster of EC2 workers that will ...
0
votes
0answers
59 views

AWS Lambda function to create multiple databases is only creating the first

I have an AWS Lambda function that I'm trying to use to create 3 new databases every night. It takes the most recent snapshot from each server and runs restore_db_instance_from_db_snapshot. Its meant ...
0
votes
0answers
123 views

Unable to set storage size for an AWS database cluster

I'm attempting to find a solution for this AWS restore_db_cluster_from_snapshot yet no instances however when I try to run the create_db_instance method I get the following error - *** ClientError: ...
1
vote
1answer
102 views

AWS restore_db_cluster_from_snapshot yet no instances

I'm writing an AWS lambda function to take my most recent snapshot of our production database and restore it as a new DB. This worked fine as a RDS instance but we recently switched our main DB to ...
1
vote
0answers
43 views

Any logs for AWS RDS auto start?

From AWS documentation Stopping an Amazon RDS DB Instance Temporarily: You can stop a DB instance for up to seven days. If you do not manually start your DB instance after seven days, your DB ...
0
votes
1answer
21 views

AWS RDS .NET SDK ModifyDBInstance not working for SQL Server engine

I'm using this AWS .Net SDK function to modify a SQL Server database instance. I am NOT trying to update the storage capacity as I know it cannot be done on SQL Server. However, any call to modify any ...
0
votes
1answer
126 views

How to display a drop-down list of RDS instance snapshot ID's when creating a new stack from a template?

I wrote a CloudFormation template which in addition to other stuff, also creates a RDS MySQL instance and restores data from a previously backed up DB instance snapshot. I want to enable the user ...
1
vote
0answers
43 views

Amazon AWS RDS - SQL Server, more flexible scaling

I currently have an AWS RDS SQL Server Instance in place and the app that uses it see's peek usages during certain hours of the day. (9-10 and 6-7), during these times we are seeing a huge slow down ...
1
vote
1answer
121 views

Can I connect an RDS instance to a software based VPN (an EC2 instance)

To elaborate, I have an AWS EC2 instance running a SoftEther VPN server, an AWS RDS instance, and clients on the VPN. What I need to be able to do is have my RDS instance(s) connect through the VPN ...
0
votes
0answers
246 views

Determine why 100% of Mysql CPU is being used

I setup a database on an Amazon RDS server The server is a db.m4.xlarge which is 4 vCPU's and 16Gig RAM yes our Magento (1.9) based website keeps causing our database to spike to 00% CPU utilization. ...
5
votes
1answer
896 views

Why is my “volume bytes used” always increasing on my Amazon Aurora cluster?

I have an Amazon (AWS) Aurora DB cluster, and every day, its [Billed] Volume Bytes Used is increasing. I have checked the size of all my tables (in all my databases on that cluster) using the ...
0
votes
2answers
892 views

How to refer to AWS RDS host name

I started an Amazon RDS instance (with Multi-Az enabled) and was provided with a host name like instance.abc123.us-west-1.rds.amazonaws.com. Will this instance's hostname ever change? Can I use this ...
1
vote
1answer
2k views

Download Amazon-RDS (SQL-Server) Backup or Snapshot

I want to download one of my backups and restore it on my laptop for testing a web app locally. I'm using SQL Express. This is similar to this MySQL question. Can I just run a backup using T-SQL? ...