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
2
votes
0 answers

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 documentation:…
Gabriel Gates
  • 121
  • 1
  • 4
2
votes
1 answer

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 database is not working anymore.. Lambda is using…
Sabbir Ahmed
  • 21
  • 2
2
votes
1 answer

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 DNS cache expires, every 5 seconds, the next…
Craig Francis
  • 633
  • 1
  • 8
  • 23
2
votes
2 answers

Can't Connect a RDS slave on a distant Master

I would like to create a replica of a database hosted on a VM on my computer (MASTER) to the AWS cloud (SLAVE). I can connect on the 2 DB from a EC2 instance. I set the parameters with the AWS script: mysql> CALL mysql.rds_set_external_master…
jerome
  • 21
  • 2
2
votes
1 answer

AWS RDS DB Connections 90+

I have a single db.m5.large RDS instance running in my aws setup. When I check for max connection from mysql console, with bellow query. mysql> show variables like 'max_connections'; …
Aparichith
  • 121
  • 1
  • 4
2
votes
1 answer

AWS: MySQL running on ECS vs RDS

I'm working on a project where we will be using ECS to run the API of each client, it will start with one but it will eventually grow. We will also need a database for each client and the Project Manager decided that we should have an instance of…
Tomás Fonseca
  • 57
  • 1
  • 5
2
votes
1 answer

AWS RDS CLI: DB instances not listed

I've created an IAM user (CLI only) with AmazonRDSReadOnlyAccess permissions. Now every time I try to list my db instances I get an empty JSON object, even though I have one active RDS instance: aws rds describe-db-instances { "DBInstances":…
manifestor
  • 6,079
  • 7
  • 27
  • 39
2
votes
1 answer

How can I scale a mysql database with high I/O used for queue jobs with 300 workers?

I'm currently using angular on the frontend for a dashboard that displays the progress of queue workers. On the backend, I use 50 AWS EC2 instances that each have around 6 workers and those are managed by supervisord. Those workers take the next job…
Mike
  • 23
  • 2
2
votes
1 answer

Connect an AWS Lambda function triggered by API Gateway to Aurora Serverless MySQL database

I have an AWS Lambda function which is being successfully run via a HTTP request to an API Gateway. It returns a JSON response which I can see in my local web browser. Now I want it to gather data from an Aurora Serverless MySQL database which I…
Rob Fisher
  • 151
  • 5
2
votes
1 answer

nooby questions on aws and aurora serverless

We are currently in the process of moving our dev and production work on AWS. I was assigned to create the necessary VMs and databases, so I am reading here and there about these, since this is my first aws attempt. Firstly, I noticed that I can…
Skaros Ilias
  • 131
  • 5
2
votes
1 answer

Amazon RDS DB Migration - Replication Task cannot connect to AWS RDB but I can

I am doing a proof of concept to migrate an existing SQL Server database to Amazon RDS. I set up the Amazon RDS database (I tried with SQL Server and Aurora - the result was the same in both cases). To perform the migration, Amazon sets up the…
patschiboy
  • 121
  • 1
  • 4
2
votes
1 answer

Audit logs for RDS MySQL not appearing in CloudWatch

I've been trying to get a MySQL instance on Amazon's RDS to send logs to CloudWatch: in particular, both error logs and audit logs. Error logs work fine, they're appearing in CloudWatch, no issues at all. For audit logs, I know I need to have the…
pat
  • 311
  • 1
  • 3
  • 9
2
votes
2 answers

Amazon RDS: Why do I get more IOPS than I have provisioned?

We run a Multi-AZ r4.2xlarge Mysql RDS instance and we provision 2000 IOPS (which costs $400 per month extra). When I check the CloudWatch charts I can see large periods where the Write IOPS are more than the 2000 that we pay for: (during weekdays…
Tom
  • 4,277
  • 11
  • 42
  • 52
2
votes
0 answers

AWS RDS different user or security group for reader and writer cluster endpoints

I crated an Aurora MySQL cluster with reader and writer instances. I would like to restrict the access to the writer cluster endpoint so that only my application can access it. I would also like to make the reader cluster endpoint available to…
user34814
  • 71
  • 1
  • 1
  • 6
2
votes
0 answers

How to associate existing RDS instance to Elastic Beanstalk, with the right storage size?

I found the post How to associate an existing RDS instance to an Elastic Beanstalk environment? and tried to associate my existing RDS instance to Elastic Beanstalk by following it: First, creating a manual snapshot from my existing RDS instance,…
Jorge Orpinel Pérez
  • 121
  • 4
1 2 3
…
36 37