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

Reset slow_log tables in RDS of AWS

I enabled the slow_log_query in RDS in AWS. I want to reset the table but i am getting Access denied in PhpMyadmin while truncating . Any Idea to make it possible .
suresh
  • 301
  • 2
  • 9
3
votes
1 answer

Reducing AWS EC2 Instance and RDS - Is 'low' Network Performance acceptable?

I launched my site on AWS a few weeks ago. I have a m3.medium EC2 instance and a db.m3.medium RDS instance (MySQL database). I've looked at the monitoring for each and this is the average usage for each: RDS 6% CPU Utilization EC2 10% CPU…
Luke
  • 549
  • 1
  • 6
  • 18
3
votes
2 answers

Can I access the failover server on AWS RDS?

I am trying to create a working proof-of-concept in AWS for our web application which suddenly needs to scale out very quickly. Currently it is hosted on a local VMware server and we are migrating to AWS. I am working on configuring an MS SQL…
LegendaryDude
  • 244
  • 4
  • 11
3
votes
1 answer

20% CPU usage by RDS instance when idle

I have brought up a db.t1.micro PostgreSQL instance in us-east-1 region. It's single availability zone no backups not in a security group that's reachable from the outside world For some reason the CPU usage is at 20% CPU while I'm doing…
Alex B
  • 1,714
  • 2
  • 18
  • 30
3
votes
0 answers

AWS: RDS + CloudFormation – VPC peering

So here's my situation: We are a young startup scaling up and we decided to give Mesosphere DCOS Community edition a try. The community edition deploys a stack of Masters, Slaves and LB's over AWS CloudFormation using a template. (our…
Ashesh
  • 233
  • 2
  • 13
3
votes
1 answer

What is the best way to share an AWS RDS instance across multiple Stacks?

I'd like to create one larger RDS instance and share it across OpsWorks stacks so I can pool the database resources across multiple applications. Here is a reference to the OpsWorks docs for configuring the data sources for an…
TomDavies
  • 141
  • 6
3
votes
2 answers

Clone database or copy data from RDS MSSQL DB to local database

Is there anyway I can clone an amazon RDS MSSQL DB to my ec2 instance local DB? And this has to be done through powershell also. Basically I need backup of RDS MSSQL DB in sql or bak extension, but that's not achievable in a direct attempt. I was…
serverstackqns
  • 764
  • 3
  • 16
  • 42
3
votes
1 answer

Custom domain name for AWS RDS

What possible ways to translate entry point like my-name.ck4k21dvamqbq9.eu-west-1.rds.amazonaws.com:5432 to db.domain.com? For own instances we use map in /etc/hosts based on private ip. Storing long entry point name a little bit confusing, and…
Nikolay Fominyh
  • 286
  • 4
  • 11
3
votes
2 answers

How to implement table security without SUPER privilege?

A MAJOR provider of cloud-based MySQL does not grant the SUPER privilege to the master user. The provider is Amazon RDS, but my question isn't about Amazon RDS specifically, it's for the general case of the database owner/administrator not having…
Alex R
  • 1,063
  • 3
  • 14
  • 29
3
votes
1 answer

Is it unusual for a database client to install the server's SSL certificate?

We use Amazon RDS for our databases at work. Recently we got an automated email from Amazon stating they'd be updating the SSL certificates and that if we didn't upgrade our database instances within X amount of time, they would cease to function.…
soapergem
  • 719
  • 4
  • 13
  • 29
3
votes
1 answer

How can I get Puppet generated configuration to include internal hostnames of other ec2 instances in my CloudFormation stack?

I have a stack generated by AWS CloudFormation that includes an EC2 instance (running Ubuntu 14.04) and an RDS (database) instance. They are both inside a VPC, which includes a puppet master (not as part of the cloud formation…
cubabit
  • 45
  • 1
  • 7
3
votes
1 answer

Oracle Database suddenly fills storage device in about 20 minutes

My Oracle instance up on Amazon's RDS filled a 20GB storage in the space of about 20 minutes. I checked all the applications that use this DB and nothing looks out of the ordinary - I can't figure out why this would have happened. See the graph from…
wwarren
  • 264
  • 1
  • 2
  • 10
3
votes
1 answer

How to calculate the size of an AWS RDS instance from a MySQL dump?

We are importing a large historical database into RDS from a mysqldump The gziped sql file was 3GB, the uncompressed sql file is 18GB. We created a 30GB AWS RDS instance and imported the file... the RDS instance ran out of space. We created a 50GB…
Dogsbody
  • 656
  • 4
  • 15
3
votes
1 answer

Connecting RDS database from out side of VPC

My RDS database located in VPC. It's a Multi AZ database so that it's located on two VPC subnet. How could I connect it from outside of VPC?
zontragon
  • 275
  • 1
  • 4
  • 14
3
votes
3 answers

AWS RDS (SQL Server): SSL Connection - The target principal name is incorrect

I have a Amazon Web Services (AWS) Relational Database Service (RDS) instance running SQL Server 2012 Express. I've installed Amazon's aws.amazon.com/rds certificate in the client machine's Trusted Root Certification Authorities store. However,…
AX1
  • 1,289
  • 4
  • 24
  • 39
1 2 3
…
36 37