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

Can a replica to an RDS MySQL instance be setup outside RDS?

I have a running RDS Mysql 5.7 instance that I would like to replicate to a MySQL 8 instance running on a Linux server (not on RDS). Is this possible? I cannot find an option to do this from the dashboard.
EastsideDev
  • 333
  • 3
  • 13
0
votes
1 answer

AWS budget cannot do stop RDS action

I do not want to create an IAM user: I am logged in as root in AWS console. How can I create a role such that my RDS instance stops on budgeted amount? I do always get the error when I configure a budgeted RDS action: Budgets permission required to…
Leder
  • 101
  • 4
0
votes
0 answers

MariaDB on AWS RDS curiously takes up 60GB of storage occasionally in a very short span of time

I have a small MariaDB RDS Instance running on AWS. Every once in a while, the instance quickly starts to use the available storage (not the tablespace) and becomes 100% full, i.e. 100% storage full. Then it's locked by AWS, storage optimization…
remudada
  • 57
  • 8
0
votes
0 answers

What exactly does the AWS Pay For What You Use policy mean?

Well, I was fed up with the absurd host prices here in Brazil when I got to know AWS and the pay-as-you-go policy. I recently started a course for the solution architect certification (SAA2), that's when I saw in the EC2 module that machines must be…
Samuel Ives
  • 101
  • 1
0
votes
1 answer

Can't Connect to an RDS from my home computer in AWS

I need to connect to an RDS from my home computer. This is an established database, I'm migrating it to a new system. I can not connect to it from my home computer. I have set the security to Public Accessibility. I've set VPC the Security rules to…
Some Guy Trying To Do Math
  • 101
  • 1
0
votes
0 answers

Major difference in storage measured by Amazon Aurora vs Postgres

When I query postgres for the size of all databases, I'm getting 430 GB. select pg_size_pretty(sum(pg_database_size(d.datname) )) from pg_catalog.pg_database d; > 430 GB However, Amazon Aurora is reporting "Volume Bytes Used" as 824GB. This…
jaynp
  • 235
  • 3
  • 9
0
votes
1 answer

Why is my database restore failing with ConnectFailure exception?

I am trying to restore a SQL Server database to an AWS RDS instance from a full backup file created on a different non-RDS server. I am running the operation from an EC2 Windows Server instance in the same VPC (we'd like to keep the RDS instance…
Don R
  • 143
  • 2
  • 11
0
votes
1 answer

>150Million records insert select query canceled after 12 hours AWS RDS

I have a AWS RDS t2.micro storing over 150 million records in a table from which i need to make a select insert query to another table, the purpose of this select query is to make a percentage calculation into second table. I tested this query in a…
Christopher Martinez
  • 101
  • 2
0
votes
2 answers

Given an existing unencrypted AWS EFS volume, can somebody give me a path for encrypting it without data loss?

We have discovered that we really ought to have encrypted the MySql database and EFS volume on our application, at the time of creation. We are now attempting to correct the oversight. I've read the Amazon document about converting a database from…
hbquikcomjamesl
  • 259
  • 2
  • 16
0
votes
1 answer

Do I need 1 RDS Cluster for each DB or a single RDS Cluster for all my DBs?

Let's suppose I have 5 databases I'm going to use in my application. The application will be used by +100k users. I'm planning to use RDS Cluster with Aurora PostgreSQL. What would be best? Create 1 cluster for each DB, I'll end up with 5 clusters,…
Castro Roy
  • 285
  • 1
  • 8
  • 17
0
votes
1 answer

How to reduce size of my RDS mySql database of 5000 GB to 2000 GB, with all the triggers and functions intact?

I have a RDS MySql database of provisioned storage 5000 GiB. Out of 5000 GiB I am using only 1400 GiB and want to reduce size of provisioned storgae to 2000 GiB. All the tables are innoDb. I want to keep my triggers, indexes, keys and functions…
shreyanshu agarwal
  • 1
  • 1
0
votes
0 answers

Amazon RDS PostgreSQL: Sudden increase in Read IOPS

We are using Amazon RDS to host our PostgreSQL databases. Our production instance (db.t3.xlarge, Single-AZ) was running smoothly until suddenly Read IOPS, Read Latency, Read Throughput and Disk Queue Depth metrics in the AWS console increased…
berkerol
  • 1
  • 1
0
votes
0 answers

AWS Aurora/MySQL server crashes with spatial query

We are using AWS Aurora/MySQL, engine version 5.7.mysql_aurora.2.09.0 and we have a spatial index on a table with ~10,000,000 rows: CREATE TABLE `foo` ( ... `lat` decimal(10,6) DEFAULT NULL, `lng` decimal(10,6) DEFAULT NULL, ... …
Dave L
  • 1
0
votes
1 answer

Managing RDS Aurora MySQL connections per user or database

I have an RDS Aurora MySQL 5.7 and a number of independent applications connected to it. Some of them are real-time websites while others are batch services (connected mostly to the reader). A recent event resulted in a spike in sessions and took…
Leo
  • 435
  • 1
  • 4
  • 7
0
votes
2 answers

How do we install custom fonts on SSRS in AWS MS SQL hosted on RDS

We are using the new SSRS option on the AWS RDS, we have to install a custom font for a report that we are working on. I have checked the documentation and we notice that there is only option to enable and disable SSRS on MS-SQL RDS, but there is no…
user129615212
  • 11
  • 2
1 2 3
…
36 37