Questions tagged [amazon-rds]
Amazon RDS (Relational Database Service)
559
questions
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 ...
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 ...
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) ...
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 ...
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 ...
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 ...
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 ...
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' => [
...
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 ...
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 ...
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 ...
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.(...
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 ...
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 ...
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 ...
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 ...
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 ...
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'...
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, ...
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.
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. ...
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 ...
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 ...
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)....
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 ...
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 ...
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 ...
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 ...
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 ...
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....
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 ...
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 ...
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
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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)
...
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 ...
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.
...
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 ...
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 ...
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 ...
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 ...
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 ...
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',
...
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:...