Questions tagged [amazon-rds]
Amazon RDS (Relational Database Service)
545
questions
1
vote
0
answers
93
views
Issues with AWS Aurora MySQL engine version "5.7.mysql_aurora.2.10.3"
Is anyone else experiencing problems after recent automated AWS Aurora MySQL database engine updates? (specifically "5.7.mysql_aurora.2.10.3")
Over the weekend our web servers started ...
1
vote
2
answers
55
views
How to find RDS public IP. - AWS
I have a command to connect the RDS instance, but I don’t know where this public IP address comes from. Where I can get the public IP address?
I took over a project. There is a RDS connection. ...
- 11
1
vote
1
answer
64
views
"Target KMS key" error when trying to enable backup replication on an AWS RDS instance
I created an RDS database instance using the AWS user interface, and I made sure that the "Backup replication" feature was enabled and I specified the ARN for a symmetric multi-region KMS ...
- 249
2
votes
1
answer
83
views
Can't connect Google LookerStudio to Amazon Aurora serverless PostgreSQL
There are no issues connecting to it from any other environment (local works fine, as does from the Cloud), and the security group is currently totally open. An actual PostgreSQL instance, hosted in ...
- 560
1
vote
1
answer
66
views
Is it possible to create a linked server between the ServiceNow ODBC driver and an AWS/RDS SQL Server instance?
I have an internal .NET 7 web application that uses an MSSQL database hosted on Amazon RDS.
I have a requirement to create a linked server to query data from a separate ServiceNow DB instance.
The ...
- 280
0
votes
0
answers
20
views
Problems accessing to a RDS through a Bastion Host from a local K3s
I'm trying to build a local Kubernetes with K3s and I'm having problems to access to my RDD that is situated in the private Area of the VPN.
For now, I'm trying to deploy a Passbolt (https://...
- 1
0
votes
0
answers
71
views
SSMS 19 issue with AWS RDS
still pretty new to SQL administration so please bear with me. We recently updated to SQL Server Management Studio 19 and have been running into issues.
The long and short of it is I am trying to get ...
-1
votes
1
answer
130
views
When will Amazon RDS suport MariaDB > 10.6?
RDS has historically added support for new mariadb releases within a year, but they seem stuck on 10.6 and haven't added the new 10.7, 10.8, 10.9, 10.10, 10.11, which are all GA.
MariaDB did change ...
- 129
0
votes
0
answers
63
views
Restrict connection to RDS database based on IAM Role and RDS tag
G'day!
I have IAM Authentication turned on for my RDS databases.
I can successfully connect using an authorised role and am denied when using an unauthorised role.
However, I have a role that I would ...
0
votes
0
answers
87
views
Using AWS Blue/Green deployment, how do I modify the staging database?
AWS has rolled out a Blue/Green Deployment feature for RDS, allow you to create a staging (green) database that's in parallel with your production (blue) database. Their documentation specifically ...
1
vote
0
answers
71
views
GitLab CI Runners faild InvalidParameterCombination: Cannot find upgrade path from 5.7.38 to 5.6 , Terraform
GitLab CI Runners faild the jbo with the following error message
│ Error: Error modifying DB Instance legacy-dms: InvalidParameterCombination: Cannot find upgrade path from 5.7.38 to 5.6.
│ status ...
- 49
2
votes
0
answers
131
views
Google DataStudio (LookerStudio?) Can't connect to RDS MySQL using SSL?
I am attempting to connect to an RDS MySQL instance from Google DataStudio (LookerStudio?). The RDS instance accessible via public internet. I'm able to connect to it successfully using non-ssl ...
google-cloud-platform
0
votes
0
answers
52
views
AWS RDS Database user of username@100.%.%.% (IPv4 Shared Address Space) is that safe?
We have an RDS instance that is not publicly accessible. We have a VPN and VPC with 172.X addresses that connects to it.
In our RDS logs, I'm seeing a LARGE number of failures, which has blocked our ...
- 131
0
votes
0
answers
92
views
How to create a copy of a user in AWS RDS PostgreSQL?
I need to replace a AWS RDS PostgreSQL user without causing an outage during the switch, so I'm trying to duplicate it's permissions and can't seem to find information on how to do it correctly.
In ...
- 1
0
votes
0
answers
81
views
How to connect securely from Redshift serverless to federated RDS Aurora cluster schema?
I have a Redshift serverless workgroup inside a VPC, and I want to securely create a federated schema of an RDS Aurora cluster through a security group or another mechanism. The Aurora cluster is in ...
- 101
7
votes
2
answers
3k
views
Is there anything about going from gp2 to gp3 storage which requires careful consideration?
I'm maintaining an AWS RDS database (db.m6g.xlarge) which has a 750GB disk. This gives 2250 IOPS and the RDS monitoring tells me that the read throughput on average is ~ 50MB/s and write throughput is ...
- 1,558
1
vote
0
answers
344
views
AWS RDS Slow Query, General, and Audit logs have disappeared. Enhanced Monitoring cannot be turned on
I had AWS RDS enhanced monitoring turned on in our Production and UAT RDS databases. These are connected to an ERP instance.
I went to look for slow queries while debugging a user issue, and the Audit,...
- 131
0
votes
0
answers
44
views
How to make start/stop time of an AWD RDS MSSQL instance quicker?
When I start/stop a simple AWS MSSQL RDS instance, it takes 5 minutes, even tho its nearly empty. How come ? Is there a way to make it faster ? Our on-premise MSSQL cluster apparently takes 10 seconds ...
1
vote
0
answers
342
views
AWS: Unable to drop MSSQL RDS database
We have an RDS MSSQL instance, configured as Multi-AZ.
I created a test DB, "Moose" on RDS.
After 5-10 minutes, it shows "(Principal, Synchronized)" in SSMS
<= So far, so good.
...
- 280
0
votes
0
answers
49
views
Fixed IP address to an EC2 Instance in CloudFormation
I'm developing an infrastructure in CloudFormation where the database and the application is separated, but since I don't know what IP my application will receive, I can't create a filter for the ...
0
votes
0
answers
44
views
What will happen if I start more than 10 RDS native backups at once?
I want to create a SQL Agent job in an RDS MSSQL instance to back up all user databases whose names match a pattern. I have written this code:
declare @TimeStamp nvarchar(10) = convert(nvarchar(10), ...
- 305
0
votes
1
answer
181
views
Hardware maintenance scheduled for AWS RDS - What could be the down time for the RDS instance which is in single availability zone?
One of my production RDS instance is scheduled for hardware maintenance. This instance is hosted in the single availability zone and storing the huge data. Now I'm worried that I cannot postpone the ...
- 103
1
vote
0
answers
2k
views
RDS does not support creating a DB instance with the following combination
AWS recently notified me I need to upgrade an RDS instance that's using an instance type that's being removed.
So I logged in, and bumped up my instance size from m1.small to m5.large (the smallest ...
- 3,590
0
votes
1
answer
603
views
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 ...
- 1
5
votes
2
answers
8k
views
Amazon AWS RDS Burst Balance vs CPU Credit Balance
I'm trying to understand if I have spec'd my database appropriately. Below is a chart showing the WriteIOPS, CPUCreditBalance and BurstBalance for a t3.xlarge instance of SQL Server. It looks like I'm ...
- 153
1
vote
0
answers
146
views
Can a RDS Multi AZ w/one standby be converted to Multi AZ w/two readable standbys?
I'm looking at the two AWS RDS options for highly available databases :
Multi-AZ with one standby
Multi-AZ with two readable standbys
https://aws.amazon.com/rds/features/multi-az/
My understanding ...
- 1,558
0
votes
0
answers
946
views
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 ...
- 11
1
vote
1
answer
390
views
AWS RDS database - Incompatible-network
I'm creating a database on AWS RDS, but every time I do, the status is Incompatible-network.
I'm wondering if it is because my Subnets have a deny all:
But I can't seem to delete the deny all, it is ...
- 121
0
votes
1
answer
2k
views
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 ...
- 508
1
vote
1
answer
299
views
Why does our Tomcat Java application suddenly open hundreds of connections to our database?
We have a Tomcat application running on Elastic Beanstalk and our MySQL database is hosted on AWS RDS (2 or 3 t3.medium instances). Ever since we upgraded from MySQL 5 to MySQL 8 (currently 8.0.23), ...
1
vote
1
answer
656
views
What is causing BadRequestException when calling the ExecuteStatement operation on Aurora Serverless db
I have a lambda function that retrieves records from AWS Aurora Serverless db. Now I thought of adding api gateway to trigger the lambda function but I get this error
Connect an AWS Lambda function ...
- 11
0
votes
1
answer
468
views
AWS Aurora mySQL vs Aurora postgreSQL [closed]
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 ...
- 103
0
votes
1
answer
75
views
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 ...
- 101
2
votes
1
answer
31
views
Managing AWS EC2 and RDS autoscalling configuraiton
A client of ours generally can get away with running just the one EC2 and also has an Aurora serverless MySQL 5.7 database running, however there are times when their load spikes up significantly. e.g....
- 121
3
votes
1
answer
4k
views
How to create a Super User Account on AWS's RDS Mysql?
The Master user has limited permissions on RDS.
I need SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privileges, and I don't know how to add them to my user.
Tried this solution from ...
- 131
0
votes
1
answer
94
views
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
...
- 1
0
votes
1
answer
109
views
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 ...
- 105
0
votes
1
answer
2k
views
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
...
- 542
0
votes
1
answer
2k
views
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....
- 111
0
votes
0
answers
81
views
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 ...
- 209
0
votes
1
answer
580
views
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 "...
- 317
2
votes
1
answer
770
views
Find which RDS is using a certain parameter group?
How can I find which RDS database (if any) is using a certain parameter group?
Clicking through each DB to check that is not a solution. There's too many DBs in the organization.
- 121
7
votes
1
answer
8k
views
AWS: What is the difference between Burst Balance and EBS IO Balance metrics?
AWS Docs describe Burst Balance and EEBS IO Balance in the following way:
BurstBalance The percent of General Purpose SSD (gp2) burst-bucket I/O
credits available.
EBSIOBalance% The percentage of I/O ...
- 81
0
votes
1
answer
404
views
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 ...
- 101
0
votes
1
answer
376
views
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 ...
- 23
3
votes
1
answer
2k
views
How to get a local mysql dump of a specific AWS RDS Snapshot
Hello I have a linux bastion host in AWS that I am able to SSH into. In the Bastion I am able to run a mysqldump command which makes a copy of an RDS instance. What I want to accomplish is being able ...
- 133
0
votes
0
answers
87
views
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 ...
- 437
4
votes
1
answer
676
views
Will critical security updates get applied even with "auto minor version upgrade" disabled?
RDS offers an "auto minor version upgrade" setting, described in the docs, which causes AWS to automatically upgrade your database engine from time to time:
If you want Amazon RDS to ...
- 717
2
votes
2
answers
2k
views
Can't create free-tier AWS RDS DB
I can't seem to create a 12-month free-tier AWS RDS DB running MySQL.
According to AWS, the following requirements need to be met for a 12-month free-tier RDS DB:
750 Hours per month of db.t2.micro ...
- 23
2
votes
2
answers
8k
views
AWS RDS: Invalid max storage size for engine name postgres and storage type gp2: 198
I'm getting this error while modifying DB instance. Invalid max storage size for engine name postgres and storage type gp2: 198 for schedule autoscaling.
This only happened yesterday, it's weird. Here ...
- 21