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
1answer
23 views

Handling traffic spikes for a medium scale ecommerce application

Let me first briefly describe our stack. Single EC2 instance with 4 vCPU and 16 GB RAM running Ubuntu [m4.xlarge] Single RDS instance with 2 vCPU and 8 GB RAM running MySQL 8 [db.m5.large] We are ...
0
votes
0answers
19 views

AWS RDS instance 100% CPU utilisation for PostgreSQL for normal usage

am using aws rds Postgres 9.4. I am facing an issue of very high CPU utilization. Instance type is t2.xlarge (16 gb ram). All the time I can see very low ram usage i.e. 14 gb free, 15 gb free. But ...
0
votes
1answer
28 views

AWS Lambda needs to be moved in different Subnet

I have a Lambda function that is in VPC-A and Subnet 1A and 2A. I want to move it to Subnet 1b and 2B. The command below is giving error: aws rds modify-db-subnet-group --db-subnet-group-name "XXXX" ...
0
votes
1answer
44 views

How to see what is my Amazon rds password

Hi I think it is possible to rest Amazon rds password, I mean db password. Is it called master password. I mean RDS-PASAWORD. But any way to see current rds password. I searched internet for a long ...
0
votes
1answer
39 views

How to keep an Amazon ElastiCahe Memcached/Redis before a RDS MySQL database and use ElastiCache to cache the content?

I created one cluster in ElastiCache and connected that cluster with EC2 instance. And I want to include ElastiCache in front of my RDS(MySQL database). I have two questions which are as below. 1)Is ...
0
votes
1answer
24 views

Migrating data from a RDS Read Replica to Redshift

I am trying to create a AWS DMS (Data Migration Service) task to migrate the data from a RDS Read Replica running Postgres to a Redshift cluster, however my task is always failing when it is time to ...
1
vote
1answer
33 views

Migrating from DynamoDB to RDS

I'm considering the different options available for migrating a DynamoDB Database to RDS. The data structure makes much more sense in a relational format. There are 8 tables with around 1 million ...
0
votes
1answer
21 views

Doubts on moving RDS instance from EC2-Classic to VPC

I'm using Oracle RDS in the classic configuration pre-VPC era. I have created rules on the RDS security group to allow EC2 public IPs from VPC instances to access the DB. I have used all the 20 ...
1
vote
1answer
58 views

Aurora Serverless Blue/Green deployment

I am currently investigating strategies for implementing blue/green deployment using RDS Aurora Serverless for Mysql. The 2 methods I am thinking about are: A. Create a duplicate database and ...
0
votes
0answers
23 views

Amazon's Database Migration Service (DMS) - Exact meaning of “Partially supported datatypes”

I have several columns in my db that are float8, I'm looking to do a direct postgres10 to postgres10 migration between two RDS instances. Upon doing the Assessment for the task, it states there are ...
1
vote
1answer
150 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
312 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
85 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
537 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
73 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 ...
2
votes
1answer
199 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
1answer
45 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
350 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
119 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
140 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
117 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
14 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
155 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
17 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
17 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
41 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
576 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
75 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
214 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
155 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
112 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
482 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
37 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
123 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
369 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
1k 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
154 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
960 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
1k 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
158 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
48 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
37 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
115 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
213 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
264 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
65 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
169 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
161 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 ...