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

Questions tagged [amazon-rds]

Amazon RDS (Relational Database Service)

0
votes
0answers
8 views

nooby questions on aws and aurora serverless

We are currently in the process of moving our dev and production work on AWS. I was assigned to create the necessary VMs and databases, so I am reading here and there about these, since this is my ...
0
votes
0answers
7 views

Connection timeout when connecting to ASP.NET MVC app on AWS

I followed this tutorial and had success getting the demo project to run, but after using Amazon's deployment extension for Visual Studio to deploy my real application just as I had done for the ...
0
votes
0answers
14 views

Copying over indexes with AWS DMS

I need to use AWS DMS to copy one MySQL RDS instance to the other. I've been tinkering about have set it all up and I've run a successful migration. The issue is it doesn't create indexes. I ...
0
votes
0answers
28 views

AWS RDS {DBInstanceClassMemory*3/4} gives incorrect innodb_buffer_pool_size

Instance: db.t2.medium (2 vCPU, 4 GiB RAM) Engine: Aurora (MySQL)-5.7.12 In the parameters group, innodb_buffer_pool_size is set to {DBInstanceClassMemory*3/4}. Which should calculate to 4*3/4 = 3. ...
1
vote
1answer
46 views

Amazon RDS DB Migration - Replication Task cannot connect to AWS RDB but I can

I am doing a proof of concept to migrate an existing SQL Server database to Amazon RDS. I set up the Amazon RDS database (I tried with SQL Server and Aurora - the result was the same in both cases). ...
0
votes
1answer
20 views

Heroku Django App Very Slow

I have a Django app deployed on Heroku and it is VERY slow! I'm making small queries and I'm waiting a long time (10-15+ seconds to load 12 items (a 41KB request). I'm using the Insomnia tool to ...
0
votes
0answers
21 views

AWS Elastic Beanstalk - can't db:reset / db:seed Rails app after SSH

I'm stuck deploying my (second) Rails 5.2 app to AWS using Elastic Beanstalk. The code is deployed fine, but the PostgreSQL 9.4.18 database is causing problems. EB correctly created the RDS instance. ...
0
votes
0answers
27 views

Is there RDS support for remote storage for Prometheus?

I don't see PostgreSQL supported here: https://github.com/prometheus/prometheus/tree/master/documentation/examples/remote_storage/remote_storage_adapter and I don't see RDS supported here: https://...
0
votes
0answers
13 views

Best possible way to automate encrypted RDS mysql replication between 2 AWS accounts

I have 2 AWS accounts 1. Production 2. Development. I want to replicate the development RDS encrypted database to production account in a automated way. VPC peering is not allowed between the accounts ...
0
votes
2answers
70 views

AWS RDS with Postgres : Is OOM killer configured

We are running load test against an application that hits a Postgres database. During the test, we suddenly get an increase in error rate. After analysing the platform and application behaviour, we ...
0
votes
1answer
13 views

What is the best AWS RDS Aurora import method for large datasets?

I'm trying to read about importing data into Aurora. It seems that importing sql or csv files with mysqlimport are the available options. Is there a way of copying the raw database files into RDS ...
0
votes
1answer
15 views

Amazon EC2 (Tokyo) Can't Access Amazon RDS (Frankfurt)

I have EC2 instance in Tokyo : and I also have RDS instance in Frankfurt : EC2's IP address already listed in RDS security groups : But why EC2 Tokyo still unable to connect to RDS Frankfurt? ...
0
votes
0answers
28 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
144 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
65 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
67 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
46 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
62 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
150 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
27 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
80 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
115 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
360 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
56 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
185 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
348 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
83 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
32 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
23 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
37 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
130 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
161 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
15 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
41 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
70 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
1k 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
78 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
77 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
73 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
104 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
273 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
264 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
346 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
28 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
71 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
120 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
254 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
22 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
170 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 ...