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

Recreate encryption Keys in MS-SQL RDS instance on AWS

We are running Microsoft SQL server Standard edition running on AWS RDS, We had recently upgraded from sqlserver-se version 14.00.3223.3.v1 to version 14.00.3281.6.v1 as per the recommendation. We had recently enabled SSRS on the RDS instance , a…
user129615212
  • 11
  • 2
0
votes
1 answer

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 contains the Database locally on the server…
Amin Al-Ali Al-Darwish
  • 1
0
votes
0 answers

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 as my original server (another hoster - not…
Tyralcori
  • 125
  • 1
  • 11
0
votes
0 answers

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' => [ 'driver' => 'mysql', 'host' =>…
Sijan Bhattarai
  • 101
  • 1
0
votes
1 answer

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 python script 1 day ago and these are the stats…
Dennis
  • 75
  • 1
  • 7
0
votes
0 answers

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.(approx 17Gb) Also Under monitoring tab in rds panel it…
NewGeek
  • 1
0
votes
1 answer

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's security group (ticked Publicly Accessible) to…
Rony Armon
  • 9
  • 1
0
votes
1 answer

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.
Tim
  • 31,888
  • 7
  • 52
  • 78
0
votes
2 answers

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 documentation is that I need to make the RDS…
user
  • 103
  • 1
  • 5
0
votes
0 answers

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 Tomcat server (Apache Tomcat/9.0.26). Here is…
tiamat
  • 103
  • 1
  • 4
0
votes
1 answer

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 performance_schema tables, but they all seem to have data…
jlasarte
  • 101
  • 3
0
votes
1 answer

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 the information from the orders / clients I have. I…
Jonathan
  • 111
  • 4
-1
votes
3 answers

Impact of Amazon RDS location on speed?

I have web server on local box(at India) which connects to Amazon RDS(at US location). In this case response is too slow as web server at India fetching data from US Amazon RDS. But when i travel to US and access the same RDS from same local box. It…
user3198603
  • 129
  • 5
-1
votes
1 answer

What are my options to run MS SQL 2012 on Amazon RDS for development if I only have MSDN license?

I want to run MS SQL 2012 SE BYOL on Amazon RDS under my own MSDN license but it looks like MSDN license doesn't allow me to run MS SQL unless I host it on the dedicated hardware Microsoft Volume Licensing Product Use Rights (July 2014) states,…
kirill_l
  • 237
  • 3
  • 11
-1
votes
1 answer

Why the latency increases on highload?

We have a system built on AWS. We use Beanstalk, we have autoscaling, our database (mysql) is hosted on RDS. We use apache and php. We wanted to test our system on highload. So, we chose large instances for backend (4 CPUs, 15Gb of RAM - 20…
Volodymyr
  • 139
  • 5
1 2 3
…
36
37