Stack Overflow
Stack Overflow

Questions tagged [amazon-rds]

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.

Amazon RDS (Relational Database Service) is an online storage web service offered by Amazon Web Services. Amazon RDS is a web service that makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks, freeing you up to focus on your applications and business.

References

Related tags:

6750 questions
2
votes
2 answers

How to set current date time in AWS RDS?

I have an RDS MySQL 5.7 instance and wanted to change the current date time ahead to do do some testing. How to do it? I could not find any option to configure it in the RDS parameter group.
Ajithkumar_sekar
  • 631
  • 9
  • 23
2
votes
1 answer

AWS, Rotating SSL/TLS certificates for RDS

As part of, AWS's standard maintenance everyone using RDS should update their SSL/TLS by 2/5/2020. I don't use SSL/TLS keys for my personal project, and I understand we still need to rotate the certs if you do not wish to restart. From AWS docs: I…
edmamerto
  • 7,605
  • 11
  • 42
  • 66
2
votes
1 answer

Is it possible to create a multi source read replica in RDS

We use RDS MySQL with a micro service architecture. Each service has its own database and we have been slowly moving them into their own instances for load management and whatnot. We have a replica still attached to the primary instance (where most…
Aaron Luman
  • 635
  • 1
  • 10
  • 29
2
votes
1 answer

how get status RDS instance by name with boto3

guys I have specific names of instances and I need to get available/stopped status RDS instance by name with boto3. Example I can get list ALL instances with InstanceId and status as that rds = boto3.client('rds') response =…
Margarita Kvaapagarrot
  • 23
  • 1
  • 4
2
votes
0 answers

RDS Postgresql CPU usage 100% with unknown connections "others"

I am using Multi AZ RDS Postgresql db.m4.2xlarge instance. For a couple of days my instance is experiencing 100% CPU utilization. I have enabled performance insight and it is showing normal AAS for my queries along with the others connections, which…
Sam
  • 53
  • 4
2
votes
1 answer

Rails + Amazon RDS : latency issues

I have an app whose database is being migrated to amazon RDS. I experienced a significant drop of performance, due to the latency of the queries between RDS and our server (like 30s of loading time only because of the queries). There is no explicit…
MrRuru
  • 1,932
  • 2
  • 20
  • 24
2
votes
2 answers

Unable to connect to any of the specific MySQL hosts with AWS Lambda to RDS MySQL

I have an AWS Lambda function for an API. I have a test function inside of the API that returns a "Success" string so I know that I can hit the API from my machine (Postman). The Lambda API is inside of my VPC. I have public and private subnets. …
John Rousseau
  • 85
  • 8
2
votes
3 answers

AWS RDS Postgres connection failure

I am getting started on AWS RDS. I am trying to create a public PostgreSQL instance (free tier) and trying to connect from my local laptop through SQL Workbench. I am following the instructions from this…
Jesu Benin
  • 27
  • 1
  • 6
2
votes
2 answers

How to configure sequalize & node mysql to use new aws rds root cert rds-ca-2019

As AWS changes their root ssl cert for rds services 2019, the old certificate from 2015 looses its validity 03/2020. see https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.SSL-certificate-rotation.html How to I configure sequalize…
Manuel
  • 9,112
  • 13
  • 70
  • 110
2
votes
0 answers

CPU credit balance in RDS

enter image description hereI am a beginner in this AWS technology area. Every day I start and stop my RDS instance(db.t2.micro (MSSQL Server)) of AWS using a lambda expression. The fact that CPU credit balance acquired and spent on a daily basis…
user8424883
2
votes
0 answers

RDS MySQL timing out intermittently when called from Lambda using NodeJS

My web app uses Lambda using NodeJS and backend is RDS(MySQL). I'm using serverless-mysql to make db calls. For some reason, the db call times out intermittently. I tried the following: Enabled flow logs to see if there are any errors (but couldn't…
Mohsin Aboobacker
  • 69
  • 7
2
votes
1 answer

Postgres' CREATE UNIQUE INDEX seems stuck for a while

I created an index in Postgres like this: CREATE UNIQUE INDEX my_index_name ON my_table USING btree (custid, date_trunc('day'::text, timezone('UTC'::text, somedate)), …
Daniel
  • 21,933
  • 14
  • 72
  • 101
2
votes
1 answer

Error in Lambda Passing SQL to RDS Data API

In following a tutorial, I am trying to set up an AWS Lambda function that will pass a SQL query to an AWS RDS Aurora Serverless MySQL database using the Data API and return the query results (presumably as a JSON). The code I used is below (where…
OJT
  • 887
  • 1
  • 10
  • 26
2
votes
0 answers

I need a foolproof checklist for hosting an already built e-commerce site on Amazon Web Services

I have built an e-commerce website on my local computer that uses Django version 2.2 and python 3.7. The website consists of: fancyfetish is the main project directory. The apps, (cart, users, baseapp, products, blog) are all stored in their own…
CThomas
  • 199
  • 1
  • 10
2
votes
0 answers

Dockerize a Rails 6 app with AWS RDS database and one local

I'm just getting to know Docker and specifically how to dockerize an existing Rails 6 application to be deployed as an AWS Elastic Beanstalk. I've followed some tutorials but still a bit confused how my Dockerfile and docker-compose.yml file should…
Demian Sims
  • 871
  • 1
  • 14
  • 29
1 2 3
…
99
100