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

learn more… | top users | synonyms (1)

4
votes
0answers
173 views

How can I seamlessly upgrade the major version of an AWS RDS postgres database?

This morning I was involved in upgrading a PostgreSQL database on AWS RDS. We wanted to move from version 9.3.3 to version 9.4.4. We had "tested" the upgrade on a staging database, but the staging ...
4
votes
0answers
380 views

RDS MYSQL instance rebooted and won't load INNODB table

So my production db in RDS apparently either crashed or was rebooted during a version update, and upon being restarted mysql couldn't load one of the innodb tables: as evidenced by the following error ...
3
votes
0answers
64 views

Why does replication with SSL fail on my MySQL database in AWS RDS?

I'm trying to replicate from AWS RDS to my own server. It works without SSL. Whenever I include the SSL property to the slave, it breaks with this error: error connecting to master ...
3
votes
0answers
605 views

How to get the best write throughput during a MySQL import with Amazon RDS?

tl;dr - How can we get the maximum EBS throughput for a db.r3.2xlarge instance? We're only seeing about half of what it can supposedly do. Apologies for the long length of this question. We've had ...
2
votes
0answers
113 views

Replication of specific tables using Postgres 9.4.4 and Amazon Web Services

I have currently setup a Postgres 9.4.4 RDS instance on Amazon Web Services. On this instance I hold 20 tables. In addition I also have Postgres 9.4.4 installed on my local server (OS: 64-bit Linux) ...
2
votes
0answers
170 views

mysqldump restore error

I am getting the error below, while restoring a dump to RDS MySQL 5.6. Dump is taken from MySQL 5.5 originally. I tried restoring twice but same error. Can anyone help ERROR 1064 (42000) at line ...
2
votes
0answers
217 views

Optimizing a single table, write-once, read-many PostgreSQL database

I've just finished constructing a table of ~835 million rows using Google's ngram dataset, aggregated on the years in which they occurred so that each 2-,3-,4-, and 5-gram is represented by a single ...
2
votes
0answers
153 views

Postgres: missing disk space after truncate and re-insert

We've got a IP address range dataset stored in a table that was truncated and then re-populated with a slightly modified version of the dataset (almost identical in size). However, after truncating ...
2
votes
0answers
3k views

'Access Denied' in MySQL on AWS RDS

I'm trying to use an ETL (in my current case, the free version of Talend). I've successfully set up a MySQL on Amazon RDS, logged in through the MySQL Workbench for Mac, and uploaded my company's ...
1
vote
0answers
18 views

Pgpool slave node limit

I've started a new database architecture using pgpool-II 3.4.5, I have 3 servers by now, 1 master and 2 slaves. They are configured to use Master/Slave conf and LoadBalancing. The problem is: When I ...
1
vote
0answers
25 views

Moving extensions in AWS RDS (Postgres)

Initially we installed all extensions in default "public" schema. Now we have more and more other schemas - thus we want to add extensions and common functions to the schema common. Unfortunately AWS ...
1
vote
0answers
30 views

Refreshing SQL Server DB on Amazon RDS

we have a SQL Server DB running on Amazon RDS, i need to refresh it. But in RDS there is no option to restore a backup. What other ways i can use to refresh this DB? It is 60 GB, and has 200 tables. ...
1
vote
0answers
35 views

Amazon Aurora CREATE_TIME in INFORMATION_SCHEMA.TABLES is NULL

We are running an Amazon Aurora database that emulates MySQL 5.6.10. The CREATE_TIME in SHOW TABLE STATUS and INFORMATION_SCHEMA.TABLES is consistently NULL for all our tables. Is this a bug, a ...
1
vote
0answers
58 views

Slony with Amazon's RDS service?

Is it actually possible to somehow use Slony with Amazon’s RDS service? I’m aware that there’s no such thing as a host that you can log into to make Slony’s configurations, but perhaps it can be done ...
1
vote
0answers
207 views

Random Spikes in DB Connections - Amazon RDS

I'm running an EC2 instance (c3.large) with an RDS instance (db.t2.small). I'm frequently having issues with DB Connections spikes all of a sudden. PROBLEM: As you can see, I'm getting huge ...
1
vote
0answers
83 views

Amazon RDS: Replacing file based workflows in Oracle RDS

Oracle RDS has limitations to how it supports different file workflows External tables are apparently not supported It is, to my knowledge not possible to mount a disk and use UTL_FILE to read/write ...
1
vote
0answers
188 views

Poor performance after switching from EC2 Percona to RDS MySQL. What am I missing?

Current RDS Setup: db.r3.2xlarge running in Multi-AZ, 8 VCPU, 61GB RAM, 1500GB EBS Volume with 5000PIOPS, Mysql5.6 Here are our current MySQL variable values: ...
1
vote
0answers
102 views

Single Redshift table vs several mysql/ pgsql (on RDS) tables for small (200 tables * 20 columns * 1 million) monthly aggregation data

We're providing SaaS Data Analytics Dashboard for around 200 clients. We're using Amazon Redshift for storing data in in around 5 tables. We're getting around 30 million hits per day. Currently our ...
1
vote
0answers
146 views

Having problems trying to back up a Postgres database from AWS RDS

I am trying to backup a Postgres database from RDS and I am getting this error message. pg_dump: [archiver (db)] query failed: SSL error: unexpected message pg_dump: [archiver (db)] query ...
1
vote
0answers
72 views

Keep selected tables synchronized across MySQL databases

I've a need that requires me to keep a number of tables from a database (db1) synchronized with another database (db2). db1 & db2 have different structures and a set of tables and their data from ...
1
vote
0answers
47 views

compound index not being used on simple query

I'm running this query, and it seems to be doing a table scan , rather than using the relevant index.. select count(*) from pages where charity_id=447 and provider_id=1 this is the explain: ...
1
vote
0answers
77 views

Can a AWS PostgresSQL RDS instance be provided with a stop words file?

I need to provide a custom list of stop words. From the manual section on dictionaries the way to do this is to put a stopwords file in $SHAREDIR/tsearch_data/. Is it possible to do this when using ...
1
vote
0answers
150 views

Writing audit trail funtionality in postgres, can I use pl/V8 instead of pl/pgSQL?

I'm using postgres 9.4 on Amazon RDS. This the fast and loose "application developer" definition of an audit trail. The audit trail isn't for security nor is it a legal requirement - I don't even ...
1
vote
0answers
26 views

Optimizing MySQL for write throughput ceiling

We have a large MySQL database on AWS RDS, with a huge table around ~1.8TB with massive write workload. We recently hit a write throughput bottleneck, which caps our provisioned IOPS way below the ...
1
vote
0answers
233 views

amazon rds logs all queries

I have enabled slow query log on Amazon RDS with following configuration. long_query_time = 0.5 general_log = 0 log_output = TABLE min_examined_row_limit = 1000 slow_query_log = 1 ...
1
vote
0answers
485 views

MySQL SSL using MariaDB JDBC Driver

We have the following setup: Ec2 instance running a jboss server with mariadb (1.1.7) datasources setup to connect to an rds instance running MySQL 5.6.21. We would like to turn on SSL on for this ...
1
vote
0answers
32 views

Does creating an empty table in MySql have any effect(downtime) on production?

Disclaimer: I am, in all probability, paranoid about pushing a patch on a production server. The patch alters the schema, by creating a new table (which is empty), and changes some stored procedures ...
1
vote
0answers
262 views

Need advice to improve current RDS

Currently I am running a m3.medium SQL Server RDS(20GB storage without IOPS). CPU utilization is under 50% for most of the time(~90%). However, during peak hours(~10%) CPU utilization will hit 100% ...
1
vote
0answers
2k views

Amazon RDS - Can't access MySQL DB from local machine

I read many questions/answers here but they are from a different interface from AWS Console. I created a DB Instance but can't create a rule in the security groups that's allows me to connect from my ...
1
vote
0answers
106 views

Amazon RDS for Oracle Offsite Backup

Am considering Amazon RDS to host our Oracle database. Ideally, I'd like to have my daily backup and as many of the transaction logs as possible since copied to an external location in case of Amazon ...
1
vote
0answers
321 views

MySql Very Slow Writes & Out of memory error

I am having a rds db instance in AWS which is used by Drupal 7 instatllation. I am getting the below error messages in the log: > 130912 11:57:39 [ERROR] /rdsdbbin/mysql/bin/mysqld: Out of memory ...
1
vote
0answers
157 views

Monitor For Disabled Queue On RDS SQL Server

I would like to somehow get notification of a queue being disabled due to poisoned messages. (The issue is occasional resource contention. Until we solve it, monitoring would help us be aware.) In my ...
1
vote
0answers
248 views

Enforce a hard limit on write execution time during Amazon RDS write stalls

I am trying to recover from the situation where Amazon RDS write operations stall (some discussion on why this is here). If I show full processlist, I will see something like this: 318263 myapp1 ...
0
votes
0answers
9 views

Is this work flow suitable for Amazon RDS?

I am considering to set up a MySQL database via amazon web services (AWS). Consider the following steps which characterize my workflow: There is a daily data inflow into several AWS EC2 instances On ...
0
votes
0answers
48 views

RDS MySQL memory usage question

I have an instance of RDS of MySQL 5.7.10 I am on a package: db.t2.micro which grants me 1vCPU and 1Gib of memory. I am using Monitoring window to monitor the CPU/Memory usage. I do not understand ...
0
votes
0answers
13 views

Change in mysql structure while backup is being created

I'm using amazon's RDS services and I wonder what happens if while a snapshot is being created I change the db structure? Will it corrupt the snapshot? Will it disallow me to make the change? I ...
0
votes
0answers
18 views

Downloading transactional logs for MS SQL from RDS

Is there a way we can download transactional logs of MS SQL on Amazon(AWS) RDS such that those logs can be used to recreate the database on premise? I am looking for a way to have an option of ...
0
votes
0answers
12 views

Temporary Point-in-Time recovery for Aurora/MySQL 5.6?

How can I restore a point-in-time copy of my Aurora/MySQL database to I new instance? I would like to verify that a data fix will be consistent at a particular point in time. I don't want to roll ...
0
votes
0answers
16 views

How can i delete an orphaned table from AWS RDS database?

Info: Database is an RDS instance (MySql) Yesterday i tried to add a field to a table and did an Alter table command. There is probably some millions of records in that table. After a while it just ...
0
votes
0answers
22 views

Rds snapshot restore time

As part of our blue greendeployment strategy we are snapshoting the prod RDS instance and then restoring this snapshot into a new instance applying db migrations after it and linking the Green ...
0
votes
0answers
11 views

Changing global variables in MySQL RDS instance

I have a MySQL RDS instance that I created. I need to set the net_write_timeout variable in the instance so it is available globally. Can this be done ?
0
votes
0answers
45 views

RDS Large SQL Server Instance high cpu low connections?

We are routinely getting high CPU usage with only 12 connections on our M3.large instance. I'm not particularly skilled with AWS RDS, please forgive any ignorance or obvious mistakes. But I don't ...
0
votes
0answers
26 views

Best approach to maintain a clone of a db in Postgres RDS

We'd like to maintain a separate database for our dev environment that closely resembles the current state of our production database. What is the best way to do this in RDS? Our current process is to ...
0
votes
0answers
45 views

Modify MySQL information_schema (specially create_time) on AWS RDS?

I am trying to modify the create_time of an entire database, tables, etc. I have found that information_schema tables stores the creation date of the tables on the column CREATE_TIME. Unfortunately ...
0
votes
0answers
32 views

RDS Data Loss after modify DB instance

I recently modified the size of one of our RDS instances in AWS, after this operation had completed overnight I came in to find that some of the jobs had dropped out of SQL Server Agent & the job ...
0
votes
0answers
20 views

AWS RDS Postgresql restricted user

When you create a RDS instance (Postgresql) on AmazonWebServices you create a user that is a part of rds_superuser role. This user is sort of an administrator and is therefore not appropriate to use ...
0
votes
0answers
10 views

RDS MySQL Storage and N/W Usage

have Single Schema and single MySQL Instance on RDS Where my website users are creating app and app data stored in MySQL database in my schema each app has Unique id. One user may have one or more ...
0
votes
0answers
80 views

rds db.m3.large unexplainable low performance

I'm really hoping someone could help me figure this out. We run mysql 5.6 on a db.m3.large instance, with Storage TypeStorage Provisioned IOPS (SSD), 300G/3000IOPS and encrypted storage. Our current ...
0
votes
0answers
34 views

Amazon RDS Mysql User/Host permissions

I have a new RDS Mysql instance. I can telnet to it so no firewall issues. Here is result of connection attempt with mysql client mysql -h xxxxx.xxxxxxxx.us-west-2.rds.amazonaws.com -u rdsmasteruser ...
0
votes
0answers
50 views

Improve performance of count(*) with two exists

I need some help improve performance of this query that runs in Postgresql 9.4 at Amazon RDS: SELECT count(*) AS total FROM people WHERE EXISTS ( SELECT 1 FROM person_values WHERE ...