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)

1
vote
1answer
48 views

Does RDS in private subnet inside AWS VPC need a NAT instance/gateway?

I have hosted an AWS RDS inside the private subnet of the VPC. While creating the VPC with public and private subnets, I had to create a NAT instance. I know NAT instance is mainly for private ...
1
vote
1answer
51 views

Connect an AWS Lambda function triggered by API Gateway to Aurora Serverless MySQL database

I have an AWS Lambda function which is being successfully run via a HTTP request to an API Gateway. It returns a JSON response which I can see in my local web browser. Now I want it to gather data ...
0
votes
0answers
27 views

Can you upgrade an AWS RDS sql server license to enterprise version after it's been running?

My company is trying to decide on whether to to buy a standard or enterprise license of Microsoft SQL Server on AWS. We will probably outgrow a standard license in 4-5 years, so we know we are going ...
2
votes
2answers
77 views

Unknown Database when trying to connect to an AWS RDS instance

I created a MySQL RDS instance, however, when I try to connect without writing the database name, it connects but does not allow me to create any tables. When I do write the name, the connection fails ...
1
vote
0answers
40 views

Can't connect Postfix to AWS MySQL RDS over SSL SSL_CTX_set_default_verify_paths

I'm trying to set up a mail server with Postfix (3.3.0) with virtual domains, queried against an Amazon RDS MySQL (8.0.11) instance, with SSL between the mail server and the RDS instance. I'm just at ...
0
votes
0answers
8 views

AWS RDS database instance is running in Private Subnet, but I want to access Private RDS Instance from Google & Azure services ?

I want to keep RDS instance in Private subnet But I only want Public Cloud services to get access this Private RDS instance ? Azure and Google services, dont have a Private or Public IP for setting ...
0
votes
0answers
45 views

Error log flooding with aborted connections (Aurora 2.03 - MySQL 5.7.12)

Here's some contextual information: I have a multi-tenant, WordPress MU installation running on Elastic Beanstalk, scaled up to 2 instances minimum. These are connected to the RDS database and are ...
2
votes
1answer
95 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
12 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
1answer
38 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 ...
1
vote
1answer
151 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
43 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
74 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
74 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
96 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
16 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? ...
1
vote
0answers
35 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
329 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
67 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
124 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
90 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
84 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
293 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
32 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
104 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
226 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
791 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
100 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
490 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
666 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
115 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
39 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
31 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
76 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
158 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
221 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
51 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
127 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
2k 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
106 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
21 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
83 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
78 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
128 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
310 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
360 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
404 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={$...