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
4
votes
1 answer

Deleting log files from an AWS RDS Postgres instance

How can I delete logs from an RDS Postgres instance? I just noticed that my instance is displaying the message, storage-full. I can find any descriptions of how to deleted the log files, which I think are the reason that the storage is full. The…
celenius
  • 273
  • 1
  • 4
  • 17
4
votes
2 answers

Can Amazon Elastic Beanstalk auto-scale Amazon RDS?

I'm planning to run a PHP/MySQL application using Amazon Elastic Beanstalk. In the settings I can define when it should launch new instances automatically (Auto-Scaling). However, as I understand this, this only creates new EC2-Instances and does…
David
  • 51
  • 1
  • 3
4
votes
0 answers

Amazon RDS: Sudden increase in Read IOPS and Throughput

I am using Amazon RDS to host the databases for my website. I am using the large instances for both my master and my read replica. Everything was running smoothly until suddenly the Read IOPS, Read Throughput and Queue Depth metrics in the AWS…
j0nes
  • 955
  • 1
  • 12
  • 27
4
votes
1 answer

What happens when RDS freeable memory runs out?

We have a rather large mysql instance on RDS and the freeable memory is starting to get low (<1GB) in the last 24 hours. What will happen if we reach 0 freeable memory? Does that mean all memory available is used? does that mean the database will…
U0001
  • 173
  • 1
  • 7
4
votes
1 answer

Amazon EC2 and Amazon RDS in Same Network

We have deployed our application in EC2 instance and our database is in RDS which is db.m2.2xlarge. I see some minor slowness in our application when compare to our QA environment where has both application and our DB server. Though Prod server has…
Selvakumar P
  • 305
  • 2
  • 8
  • 16
4
votes
4 answers

MySQL : Separate Log File for Each Database

I have a server with multiple databases on it. Its actually an instance on AmazonRDS so I do not have access to the my.cnf file. What I am trying to do is a create a log for each database separately that records the queries that were previously ran…
Devin Dixon
  • 161
  • 1
  • 5
4
votes
1 answer

How do I debug lock timeouts with MySQL / Amazon RDS?

We've got a web app hosted on Amazon Web services. Our database is a multi-az RDS MySQL server running 5.1.57 and 3-4 app servers talk to it. Today, we started seeing a lot of errors along the lines of "Lock wait timeout exceeded; try restarting…
Marc Hughes
  • 805
  • 1
  • 7
  • 10
4
votes
1 answer

Using Amazon RDS (or similar) as a slave

Officially, RDS instances can't be directly set up to slave non-RDS databases. My production master is MySQL running on Hetzner and I want an RDS instance to closely follow it for backup purposes, including for the ability to actually use the RDS as…
GJ.
  • 529
  • 1
  • 7
  • 21
4
votes
1 answer

Amazon AWS VPC Performance Advantages

We have a simple setup that consists of... 1 EC Instance for HTTP/PHP requests 1 RDS Instance for our Database requests Currently our two servers do not use VPC to communicate. I was wondering if there would be performance advantages to setting…
Greg B
  • 41
  • 1
4
votes
3 answers

Tool to test MySQL latency

I want to compare the latency of my web application against two different MySQL servers: one a local machine and one hosted via Amazon RDS. What would be a good, free, and (preferably) easy tool to use to test MySQL latency? I have both Windows and…
user35042
  • 2,681
  • 12
  • 34
  • 60
4
votes
1 answer

What is the best JDBC connection URI for AWS RDS instances?

When using an Amazon Web Services RDS instance from a Java application, what is the best JDBC connection string? It should tolerate the instance falling over to the standby. AWS handles flipping the CNAME to point from the primary to standby under…
Mike Fiedler
  • 2,162
  • 1
  • 17
  • 34
4
votes
2 answers

How can I setup a VPN for remote users to connect to a AWS RDS server?

I have remote developers that travel and have constantly changing IP addresses. I would like them to be able to connect to a VPN running on a instance on EC2. Once they are connected to the VPN with a key they then can use the VPN to relay traffic…
Morgan
  • 155
  • 1
  • 4
4
votes
1 answer

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 another question: mysql> GRANT ALL PRIVILEGES ON `%`.*…
Igor Q.
  • 141
  • 1
  • 2
4
votes
1 answer

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 upgrade the DB engine version of a database automatically, you…
Mark Amery
  • 727
  • 1
  • 8
  • 25
4
votes
1 answer

Cannot connect to Amazon RDS with TLSv1.2

I set up a new machine with Ubuntu 20, and found I wasn't able to connect to my RDS databases anymore. The spring-boot application that was supposed to connect to the development environment throws the following…
UncleBob
  • 247
  • 2
  • 13
1 2 3
…
36 37