Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [amazon-rds]

Amazon RDS (Relational Database Service)

Amazon RDS (Relational Database Service) is a distributed relational database service based on popular variants, running in the cloud. Currently supported are:

  • MySQL
  • Oracle
  • SQL Server
  • PostgreSQL

Additional Documentation:

549 questions
0
votes
1 answer

AWS Policy to Read/write RDS

In my scenario , I want a policy that will allow reading and writing of abc-database-backups/rds/postgresql-backup on S3? We'll want the my servers to have that access added. Is creating a role and attaching it to the servers is best or adding a key…
samtech
  • 1
  • 2
0
votes
0 answers

MySQL on AWS Aurora Workbench Timeout

Running Aurora with mySQL in AWS and accessing from a management machine in the same VPC. If I run the query from the command line (management machine) it finishes in about 2 minutes. If I run the same query on MySQL Workbench it gives this error…
Steve A
  • 11
  • 3
0
votes
1 answer

Connecting to Amazon RDS using SSH client

I have created an Amazon RDS instance and I want to connect to it using an SSH client (puTTY). I am following this document: Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/. In the…
Hooman Bahreini
  • 518
  • 6
  • 17
0
votes
1 answer

AWS Aurora mySQL vs Aurora postgreSQL

We decided to go with AWS Aurora (and not with RDS-MSQL or RDS-PostgreSQL directly) Ignoring the SQL syntax differences and the different clients that I will use to connect. What are the main points to consider? Mainly on those areas: DR, BCP,…
Izack
  • 103
  • 1
0
votes
1 answer

AWS RDS Free Tier

I have setup an AWS EC2 instance over 12 months ago on the Free tier and it's now charging me, which is understandable since the 12 months free tier has expired for the EC2. I am now wanting to try out the AWS RDS DB instance. The question I like to…
Aaron
  • 101
0
votes
1 answer

AWS RDS PostgreSQL Upgrade from 9.6.22 to 10.17

I just finished upgrading my AWS RDS database engine from 9.6.22 to 10.17. I used these steps to make the upgrade using the AWS Console: Create snapshot of target database to upgrade Restore snapshot Upgrade the restored snapshot's (which is now a…
JB Omega
  • 1
0
votes
1 answer

EC2 Instance connection to an RDS instance accessible only via VPN

I have a Laravel application (API) that I am trying to move to AWS, however, the DB sits privately in AWS and is only accessible to me through a VPN. The database is an RDS instance. How can I provide my EC2 instance with access to the RDS Database?
chewie
  • 105
  • 1
0
votes
1 answer

AWS RDS MySQL connection limits

I have a MySQL database server, db.t3.micro, parameter group is 'default.mysql8.0', max_connections is '{DBInstanceClassMemory/12582880}' I figured out that it cannot handle more than ~63 connections According to AWS RDS documentation…
John
  • 542
  • 5
  • 16
0
votes
1 answer

Intermittent 500 Error caused by psycopg2.OperationalError: could not translate host name

20% of requests to our backend Django application (deployed on AWS using ECS and Postgres RDS) are throwing 500 errors. Looking at the ECS logs, various related errors are shown: psycopg2.OperationalError: could not translate host name…
Zev
  • 111
  • 6
0
votes
0 answers

Can one detect, via the AWS RDS API, any I/O suspension when creating a snapshot for a single-AZ DB instance?

This is very similar to this existing question: amazon web services - RDS snapshot: how long does I/O suspension occur? - Server Fault Unfortunately, the only answer provides more of a background about why a suspension is required/inevitable and…
Kenny Evitt
  • 209
  • 4
  • 12
0
votes
1 answer

restoring a DB snapshot to a different zone

I'd like to restore a snapshot from a DB instance in one region to a DB instance in another region. I can copy the DB identifier but in the Connectivity section I only have two options for "Virtual private cloud (VPC)" - "Default VPC (vpc-21cbe95b)"…
neubert
  • 317
  • 8
  • 26
0
votes
1 answer

How to deploy multi master Microsoft SQL database as IaaS or AWS RDS

We have a vendor product, which support only relational databases (Oracle and MS SQL). Due to operational efficiency and cost, we are planning to use MS SQL. However, we have a challenge to deploy the product in Active-Active mode in two different…
Indranil
  • 101
  • 1
0
votes
1 answer

Can't access RDS instance externally

I've spun up an RDS postgres database in an existing VPC (which has both public and private subnets - connected to a NAT gateway) which I've set as publicly accessible. I've added the relevant IP addresses to the attached security group, and this…
Mike
  • 23
  • 7
0
votes
0 answers

Migrating from Postgres RDS to Aurora without changing endpoint

I have around 40 micro services that connect to my Postgres RDS database. Now I am considering migrating to Amazon Aurora. Each of the connections connect to the RDS endpoint and modifying that across 40 micro services will mean that there will be…
David
  • 447
  • 1
  • 5
  • 11
0
votes
1 answer

Why can't my DB back up to my S3 bucket?

I'm trying to test a differential backup and restore on an RDS SQL Server 2019 instance in preparation for migrating some web resources into AWS. Both the EC2 instance (Windows Server 2019) on which I'm running SSMS and the RDS instance have roles…
Don R
  • 143
  • 2
  • 11
1 2 3
…
36 37