Questions tagged [amazon-rds]

Amazon RDS (Relational Database Service)

Filter by
Sorted by
Tagged with
2 votes
1 answer
883 views

Why does RDS have warm-up [closed]

I have a t3.micro postgresql (storage autoscaling) instance on AWS RDS. If I wait for something like 30 minutes after making an initial query and make the same query again, it takes up to 10 seconds ...
Bjørn Rivall Andersen 2018v's user avatar
2 votes
1 answer
2k views

RDS MySQL Insights: Top Query "commit"

We are trying to reduce the load on our AWS RDS instance by going through the performance insights. The top SQL statement listed in the insight is "commit": In particular, the commit ...
Simon Ninon's user avatar
2 votes
1 answer
13k views

OperationalError: could not connect to server: Operation timed out - when trying to change database from sqlite to postresql

I have upgraded my RDS amazon db instance (postgresql database ) from micro to small. Although it says that it is available on the amazon console, I keep getting the error (psycopg2.OperationalError) ...
Murcielago's user avatar
1 vote
1 answer
559 views

AWS RDS mysql.rds_set_external_master remains disabled after setting autocommit to 1

The goal is to create a master-master replication consisting of two RDS MySQL 5.6 instances, db0 and db1. I orientate myself by this article. So far, I have created db1 as a read-replica of db0 and ...
user540468's user avatar
1 vote
0 answers
388 views

Number of MySQL connections spikes, but no spike in number of queries

I am running LAMP stack with CakePHP and MySQL compatible AWS Aurora instance. The Aurora instance is set up with a writer and read replica. Using CakePHP request routing, the read replica is only set ...
Charles's user avatar
  • 67
0 votes
1 answer
113 views

Migrating Magento 1 db to Magento 2, Database is on Amazon RDS and the other is local to the new server

The company handling the migration is using a tool called UB Data Migration tool to migrate the magento website from 1.x which has its database hosted on Amazon RDS to a new amazon instance that ...
Amin Al-Ali Al-Darwish's user avatar
0 votes
0 answers
214 views

AWS RDS - Bottleneck

Working with AWS RDS for a couple of days right now, and i am a little underwhelmed by the time it takes to connect to the AWS RDS i did setup. My AWS RDS Server is a db.r5.large, in the same region ...
Tyralcori's user avatar
  • 125
0 votes
0 answers
458 views

Cannot migrate database on AWS Elastic Beanstalk

I have hosted a site in AWS. I have created a RDS DB instance for the elastic beanstalk. In my laravel app's config/database.php file, I have configured my database connection as : 'mysql' => [ ...
Sijan Bhattarai's user avatar
1 vote
1 answer
4k views

How to change hot_standby_feedback parameter for an existing database replica in RDS

I have a primary database instance and its read replica, both running on Amazon RDS for PostgreSQL. Recently the replica started to get a lot of canceling statement due to conflict with recovery ...
cansadadeserfeliz's user avatar
0 votes
1 answer
90 views

MySQL: normal CPU Utilization but I'm running out of memory. Should I get worried?

I'm running a heavy python script in a EC2 instance. This script is inserting tables (financial reports) to a MySQL server. There are lots of tables, the total amount is 240.000 tables. I started the ...
Dennis's user avatar
  • 75
7 votes
1 answer
1k views

does / should RDS have egress access outside of VPC?

I've done a little digging but struggled to come up with a definitive answer, for RDS should/do the require any form of external access i.e outside of VPC for server updates, ntp etc? Assuming it's ...
Matt James's user avatar
0 votes
0 answers
225 views

mysql storage filling up unexpectedly (RDS)

I am total newbie to database game. & I am using mysql 8.0 RDS 20GB free tier. I don't have much data on it.(just 300 Mb) But I always get a mail that you have exceeded 85% of storage limit.(...
NewGeek's user avatar
1 vote
0 answers
106 views

AWS data storage: how much to store with Cognito

I am new here. This is rather a choice-based question rather than purely technical one. Many mobile apps authenticate with Cognito, and I am going to use the same for ease of use + free tier ...
Nirav Bhatt's user avatar
1 vote
0 answers
2k views

how to disable SSL for samhain when connecting to a mysql database?

I have just compiled samhain from source and I added database connection credentials to the samhainrc file. For some reason, samhain will not write any entries to the mysql database. The db ...
S. Imp's user avatar
  • 586
1 vote
0 answers
61 views

Elastic Beanstalk suddenly stopped connecting to RDS database?

I have a Flask app that I'm deploying with Elastic Beanstalk. It connects to an RDS database running MySQL. I can connect to it just fine from my computer or through SSHing to the EC2 instance and ...
Jared Goodman's user avatar
1 vote
1 answer
3k views

Why can't my AWS Lambda connect to my AWS RDS proxy?

I can connect to my database locally just fine (of course with the normal DB endpoint, not the proxy endpoint). However, I just can't seem to get my lambda function to connect to the same database ...
Maxime Dupré's user avatar
2 votes
1 answer
1k views

Is DynamoDB latency almost the same as RDS latency?

I am exploring using AWS Lambda through Laravel Vapor. Avoiding the use of Redis can save us ~$56/mo (t2.small at ~$24, NAT Gateway at ~$32). Instead of Redis, I plan to use DynamoDB which is much ...
jcsoriano's user avatar
  • 121
0 votes
1 answer
471 views

AWS RDS Postgres not accessible via HTTP(S)

I'm trying to deploy an app that queries my postgres db, hosted on aws rds, and needs to be publicly available via HTTP. To achieve that, I changed the connection type in the inbound rules for the db'...
Rony Armon's user avatar
1 vote
0 answers
283 views

How do I connect to a Serverless Aurora Mysql Database outside of VPC using Mysql Workbench

I'm having allot of trouble connecting to Aurora Serverless. I run through the wizard, put the DB in public subnets with a security group to allow traffic on 3306, there are no ACLs blocking traffic, ...
Snickers3192's user avatar
0 votes
1 answer
606 views

How do I enforce encryption in transit with AWS RDS Oracle using CloudFormation YAML?

How do I enable and enforce / mandate encryption in transit for AWS RDS Oracle instances, when setting up the RDS database using CloudFormation YAML.
Tim's user avatar
  • 32.7k
2 votes
2 answers
45k views

AWS RDS to PgAdmin Error saving properties Unable to connect to server: timeout expired

Short description: AWS RDS connecting server to pgAdmin 4, PostgreSQL 11 Done: I have done similar to this guy or to this AWS guide, but at the end when I click Save, it does not accept it for me. ...
sogu's user avatar
  • 223
0 votes
2 answers
3k views

Cannot connect to AWS RDS MySQL from local computer with macOS

I'm new to database administration and trying to connect to an AWS RDS MariaDB 10.3.20 instance from my Macbook (10.14.6) on a home network -- having no luck. My understanding per other questions and ...
user's user avatar
  • 103
0 votes
0 answers
720 views

JDBC performances using AWS RDS instance / Tomcat

I'm using RDS MySQL database for both preproduction and production environment but I'm facing performance issues on the production server while accessing RDS instance through JDBC (db.m5.large) with a ...
tiamat's user avatar
  • 103
5 votes
1 answer
7k views

Can't upgrade RDS instance from MySQL 5.7.x to 8.0.x

I need to recover data from an old 5.6.x snapshot. With a little bit of tinkering, I managed to get the 5.6.x snapshot restored on an m3.xlarge instance (any instance type other than m3.* won't work)....
Zenexer's user avatar
  • 581
0 votes
1 answer
119 views

RDS Aurora - get number of bytes scanned by a query?

Is it possible to get the amount of bytes read by a query in aurora? If not at the query level, is it possible to have it at the table level?. I've looked into performance insights, and the ...
jlasarte's user avatar
  • 101
0 votes
1 answer
246 views

My RDS instance is getting flooded by my EC2 instance, but my EC2 instance is running smoothly

I have a rather complicated setup in my AWS console. I have an EC2 instance in region A with LAMP installed for what I will call my CRM. I have an RDS in the same region A for my CRM that contains ...
Jonathan's user avatar
  • 111
1 vote
2 answers
2k views

AWS RDS Postgres cross-account replication

Is it possible to set up cross-account replication with the AWS RDS Postgres database? The goal is to have a read-only replica in a separate AWS account. I know it's somewhat possible to accomplish ...
martin49's user avatar
  • 111
5 votes
1 answer
575 views

Why isn't there a character-set-client-handshake RDS parameter for MariaDB 10.2 or 10.3?

MariaDB has a parameter, --character-set-client-handshake, that can allow you to specify that the server should ignore the character set being specified by a client connecting. On RDS, when you ...
ilasno's user avatar
  • 236
0 votes
1 answer
1k views

Mysql instance of AWS got hacked

Today I opened my application and I can see its not working at all. I checked my logs and I saw tables were not found. I opened my mysql administrator and I can see my data wiped and a table created ...
Gvs Akhil's user avatar
  • 101
0 votes
1 answer
264 views

Update Your Amazon RDS SSL/TLS Certificates: Are we affected?

We have Amazon RDS MySQL instances. Our application appears to connect to it simply by being in the same security group and same VPC, and the relevant developer is 90% certain that SSL is not involved....
hbquikcomjamesl's user avatar
1 vote
1 answer
8k views

Not able to access RDS instance inside EKS cluster | EKS <-> RDS connection

I'm trying to access my existing RDS instance in the newly created EKS cluster. steps I have followed: Create a VPC peering connection by keeping RDS as requester and EKS as accepter. Add destination ...
Saikat Chakrabortty's user avatar
0 votes
1 answer
486 views

AWS (EC2 and RDS) Cross Region Performance Issue

I have the RDS server at Japan and two EC2 instances, one in the EU and the second in Japan. I am running one application on the Japan EC2 instance which connects to the RDS (Japan). In this ...
Kalpesh Rajai's user avatar
0 votes
1 answer
257 views

Error - Enable or disable IAM database authentication for the DB Cluster(Mule4 rds connector aurora)

I have created the dbcluster using aws-cli. and i wanted to create db instance within the created cluster using mule 4 rds connector. and when i give the values DBcluster name : cluster-name ...
sriaravind's user avatar
1 vote
1 answer
2k views

Connection between EC2 instance & RDS in 2 different VPC

We have a Amazon RDS database in a different VPC and our EC2 servers in a different VPC but in the same region i.e. us-east-1. Our servers connect to the RDS via it's publicly accessible endpoint. We ...
Axel's user avatar
  • 481
2 votes
2 answers
7k views

Force SSL on AWS RDS Postgres

I've got a brand new Postgres 11 RDS instance that I can connect to with or without an SSL cert. However, I would like to ensure that we never connect to this database without SSL. So I have taken the ...
Oliver Lorton's user avatar
0 votes
1 answer
594 views

How to migrate database from RDS in one VPC to RDS in another VPC?

I want to migrate the database from one RDS in one VPC to another RDS in separate VPC. This is not migrating the entire RDS but transferring the contents from one RDS to another and both RDS are in ...
programmingtech's user avatar
1 vote
0 answers
46 views

Switching database URL on Heroku between two AWS RDS instances has no effect

I am running a django app which connects to heroku. My database is configured to use AWS RDS. Now I needed to change db instances. So I created a new instance on AWS and changed the config vars in ...
Micromegas's user avatar
2 votes
0 answers
11k views

How does AWS RDS come up with the max_connections formula?

The following formula is used in my RDS parameter group for the max_connections property: {DBInstanceClassMemory/12582880} I have a relative understanding of the DBInstanceClassMemory per their ...
Gabriel Gates's user avatar
3 votes
1 answer
3k views

Update Amazon RDS Certificate SSL Issue with MySQL Lambda

Like many people I have updated my Amazon RDS Certificate to CA_2019 from CA_2015. At first everything seemed fine but later on checking I noticed the mysql lambda function which i wrote to query the ...
Sabbir Ahmed's user avatar
23 votes
7 answers
16k views

"Update Your Amazon RDS SSL/TLS Certificates by October 31, 2019"

I, like a lot of people, received an email saying to update my RDS instance to use the new rds-ca-2019 certificate for SSL connections (previous being rds-ca-2015 which expires March 5, 2020). Their ...
Tim Tisdall's user avatar
1 vote
1 answer
787 views

unable to create t3 burstable instances with custom VPC

I created a custom VPC with 9 subnets, such that for 3 AZ I have 3 subnets (public, private, and persistence). It has the following configuration: VPC 10.100.0.0/16 Subnets - 10.100.0.0/24 (az1) ...
clo_jur's user avatar
  • 121
0 votes
1 answer
77 views

How to access RDS publicly?

I created a new RDS Postgres DB and I want to access it from a local computer. I've checked the option to say yes to publicly accessible. What are the other steps needed to access this? I've tested ...
erotsppa's user avatar
  • 2,153
0 votes
0 answers
313 views

Why would AWS Aurora capacity settings not follow the "Pause compute capacity after consecutive minutes of inactivity"?

We have switched from an AWS MySQL RDS to AWS MySQL Aurora for our Wordpress website because of the "Pause compute capacity after consecutive minutes of inactivity" feature that could lower the costs. ...
wlarcheveque's user avatar
2 votes
1 answer
1k views

Avoiding DNS lookup issues with a cache

I'm running fairly simple PHP websites, on Ubuntu, with AWS EC2 instances, which use *.rds.amazonaws.com domain names to connect to their respective RDS instances. This introduces 2 issues: When the ...
Craig Francis's user avatar
0 votes
1 answer
663 views

Email notification when login attempt fails on RDS SQL Server DB

I need to get notified when there is an attempt to access our SQL database with the incorrect credentials. Is this something that I can do in AWS or do I need to do it in SQL Server? I can manually ...
Salbrox's user avatar
  • 51
1 vote
0 answers
657 views

Docker based Elastic Beanstalk timeout error connecting to RDS

Hope everyone is doing amazingly great just like me until last day. Case Story: 1 I have a laravel(php) based admin panel. 2 I ran and tested it locally by connecting it to a mysql database. 3 I ...
Sabit Mubarik's user avatar
0 votes
2 answers
3k views

mysql 5.7 on Amazon RDS getting "table foo doesn't exist"

After restoring a mysql backup in AWS RDS, I get "table doesn't exist": Server version: 5.7.22-log Source distribution mysql> show tables; +----------------------------+ | Tables_in_db ...
dfrankow's user avatar
  • 193
0 votes
0 answers
265 views

How to stop auto expanding of Aurora's storage (volume)

UPDATE: 10-9-2019: After spending much time on trying to find a solution, I terminated the RDS instance and started a regular EC2 instance with Mysql. You're welcomed to keep browsing this question, I ...
Tipxbomb's user avatar
1 vote
0 answers
416 views

Restore AWS RDS Database with memory optimized Filegroup in Amazon S3

Can't restore AWS RDS database that has memory-optimized data. I have a backup in S3 and when I try to do a restore into RDS: exec msdb.dbo.rds_restore_database @restore_db_name='MyDatabase', ...
Pedro Figueiredo's user avatar
0 votes
1 answer
3k views

Unable to connect with public postgresql rds instance : Connection Timed out

I created a basic test PostgreSQL RDS instance in a VPC. It is public and VPC security group. The security group whose configuration is as follows: Inbound Rule: Type: PostgreSQL Protocol: TCP Port:...
hakimi's user avatar
  • 1

1 2
3
4 5
12