Stack Overflow
Stack Overflow

Questions tagged [amazon-rds]

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.

Amazon RDS (Relational Database Service) is an online storage web service offered by Amazon Web Services. Amazon RDS is a web service that makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks, freeing you up to focus on your applications and business.

References

Related tags:

6750 questions
2
votes
1 answer

Direct access a database in a private subnet without SSH tunnel

I have a database set up (use RDS) in a private subnet, and a bastion is set up in front of it in a public subnet. The traditional way to access this database from local laptops is to set up an ssh tunnel on that bastion/jumpbox and map the database…
Z.Wei
  • 3,658
  • 2
  • 17
  • 28
2
votes
7 answers

Postgres pgAdmin: Unable to connect to server: timeout expired

I'm trying to connect a local Postgres server to an AWS RDS instance. When I enter in the credentials: I keep getting an error: Unable to connect to server: timeout expired I searched and it seems to be an issue with the security group. I did the…
IamWarmduscher
  • 875
  • 2
  • 10
  • 27
2
votes
1 answer

Slow and frequent PostgreSQL database connection booting in Rails API

I have a Rails API with a PostgreSQL database. Some requests to the API show a strange behavior that doesn't depend on the endpoint. These requests (around 5-10% of total requests) start with the same 7 database queries : SET client_min_messages…
Henry Boisgibault
  • 826
  • 7
  • 26
2
votes
4 answers

How to backup Amazon RDS database to S3 bucket using Lambda function

How can I backup an Amazon RDS database to S3 bucket using an AWS Lambda function? Is there is a Lambda script available? The information in RDS should be backed-up to the S3 bucket and scheduled every hour using the Lambda function.
Mukesh
  • 33
  • 1
  • 6
2
votes
1 answer

Confusion in max connections allowed in AWS RDS types

I know we can find the max connections by {DBInstanceClassMemory/12582880}(12582880 is the magic number for my AWS resources). However, for db.m4.large (8 GB RAM) I checked online at many places that the maxConnections are 648. However, when I made…
walt3rwhite
  • 73
  • 1
  • 12
2
votes
2 answers

Expected downtime to reboot a multi az rds instance without failover to apply some static parameter changes

I would like to know how much downtime should I expect to reboot an multi az rds instance without failover. I want to apply some static parameter changes. The instance is t2 medium with 100 GiB storage. It's running postgres 9.6. I am not looking…
Nitin S
  • 153
  • 2
  • 10
2
votes
1 answer

Unable to connect to Aurora MySql with Aws ECS fargate container

I have a .net core 3.1 application which is deployed as docker container on AWS Ecs with fargate. I'd created 2 new Aurora MySql dbs and tried to connect to one of the db cluster by using the writer endpoint. Now the issue is when I try to call the…
Ask
  • 3,076
  • 6
  • 30
  • 63
2
votes
1 answer

How to create a DB link between two Oracle RDS instances

I'm trying to create a DB link between two Oracle RDS instances in two different VPCs. I have created a peering VPC connection, added routes and edited security groups according to this guide. But I'm getting "ORA-12154: TNS:could not resolve the…
AchalaM
  • 33
  • 1
  • 6
2
votes
0 answers

AWS Oracle RDS - Multiple port configuration

First of all apologies if my question is too silly. We have an AWS Oracle RDS which is listening on 1521 for plain text authentication and it is working fine. But we are trying to add an additional port (2484) for TCPS/SSL. We have enabled both tcp…
Sabbir Hassan
  • 175
  • 14
2
votes
1 answer

Aurora Serverless (Postgresql) - execute statement timeout 502

I am building a lambda api connecting to AWS Aurora Serverless Postgres. Follow AWS instruction to setup an Aurora Serverless with Postgres compatible (for MySql but still useful for Postgres):…
franco phong
  • 2,219
  • 3
  • 26
  • 43
2
votes
1 answer

AWS RDS MYSQL import db Access Denied

I cannot import a database in AWS RDS because of this commands in my sql file: SET @@SESSION.SQL_LOG_BIN= 0; SET @@GLOBAL.GTID_PURGED=/*!80000 '+'*/ ''; SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN; Are they important ? whiteout them there…
Borjan Mukaetov
  • 27
  • 5
2
votes
2 answers

parameters needed for connecting to aws rds instance via ssh

Does anyone know where to find the values needed for the parameters required for an ssh connection involving a bastion host and an AWS RDS instance? I have listed what I have been able to find so far below: SSH Hostname - Endpoint given for RDS…
user11508332
  • 537
  • 1
  • 11
  • 28
2
votes
1 answer

why is rds in 3 subnets in aws

I haven't changed my vpc/subnet settings since making an aws account, and I've recently found my rds instance is apparently in 3 subnets (subnet is listed as default with 3 subnet names underneath), one of which also has my application server. Is it…
user11508332
  • 537
  • 1
  • 11
  • 28
2
votes
0 answers

Enable TLS certificate verification for AWS RDS MySQL

I use MySQL 5.7.17 on AWS RDS. I encountered a strange behavior and I am looking for an explanation. In short: I try to connect over SSL, with settings that I think should cause the connection to FAIL, but it succeeds! The following PHP code…
obe
  • 7,378
  • 5
  • 31
  • 40
2
votes
1 answer

Is it safe to use rds.DatabaseInstanceFromSnapshot long term?

Is it safe to keep a database in CDK as this.database = new rds.DatabaseInstanceFromSnapshot(this, 'name', {...}) I'm concerned that the database might get accidentally deleted at some point in the future. There was an incident recently where we had…
jeznag
  • 4,183
  • 7
  • 35
  • 53
1 2 3
…
99 100