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)

6
votes
0answers
241 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
406 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
91 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 'user@xxxxx....
3
votes
0answers
710 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 ...
3
votes
0answers
256 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
38 views

Mirror data on local SSD storage to conserve EBS I/O?

I have an AWS instance with local (ephemeral) SSD storage backed by a permanent EBS storage. Is it possible to configure the local storage to act as a mirror/cache for row data in MySQL? I do not wish ...
2
votes
0answers
15 views

What is the best way to keep track of 1000 RDS hosted databases?

I want to know what is 'best-practices' for managing an extreme number of RDS instances. I have no problem managing five. But managing dozens or hundreds, that's another task. I'm thinking use a ...
2
votes
0answers
136 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
186 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
568 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 ...
2
votes
0answers
165 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
4k 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
24 views

Postgresql/AWS RDS Problem with high write IOPS

I am currently hosting a ~10GB database in amazon RDS running postgresql. I have 100GB of space allocated using General Purpose SSDs which means that I get 300IOPS to be split between read and writes. ...
1
vote
0answers
11 views

Estimate amount of downtime from RDS backup

I have an Multi-AZ RDS instance. Due to some maintenance I want to create a consistent snapshot of the database during the day, but this means shutting down all our services. I noticed from the AWS ...
1
vote
0answers
29 views

How can i sync a table between two MySQL RDS insatance

I am trying to sync one table in two of mysql RDS instances in AWS something like a db link or FEDERATED engine.
1
vote
0answers
21 views

Debugging random slow query spikes on Index Only Scans

We have a query that for majority of requests (about 400rpm) executes in around 2ms but occasionally we have one request that will spike to 100ms+. My Googleing may be terrible but does anyone have ...
1
vote
0answers
11 views

Great slowdown of Django object list retrieval after moving from sqlite3 to mySQL on Amazon RDS

Be warned, there will be some Python programming stuff; my problem is tightly connected to database engine differences though - or at least I think so. tl;dr: Querying for list of items and all ...
1
vote
0answers
27 views

Can MyISAM tables affect the backup recovery of innodb tables on Amazon RDS?

I have an Amazon RDS instance containing several databases. All the tables are innnodb except from one, that is MyISAM and currently cannot be converted to innodb. I know that the recovery of MyISAM ...
1
vote
0answers
54 views

Replicate Postgres 9.2 to 9.4 with no downtime

My current set up has a database running on Postgres 9.2.4 and would like to move from AWS EC2 to RDS. However, AWS requires Postgres be running at least Postgres 9.4 in order to perform this ...
1
vote
0answers
22 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
87 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
32 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
59 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
45 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 ...
1
vote
0answers
97 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
259 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
128 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
249 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: https://gist.github.com/jonhatalla/...
1
vote
0answers
118 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
156 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 was:...
1
vote
0answers
84 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
98 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
202 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
27 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
306 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
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
269 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
115 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
334 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
162 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
253 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
22 views

How to move the logins from one SQL Server RDS to another?

Please tell us the way to move the Logins from one SQL Server RDS to another SQL Server RDS. This information will be very useful when moving the databases from one SQL Server RDS to a new SQL Server ...
0
votes
0answers
11 views

How can I identify errors in sync between two [master-slave] RDS instances?

In the context of building a cross region disaster recovery plan for RDS [MySQL] I read this article . It states : Configure alerts to identify errors in sync between the two regions. Amazon ...
0
votes
0answers
24 views

How to synch PostgreSQL databases on separate RDS instances everyday

I have two RDS instances: staging and production with two databases in each. I would like to sync the production instance on the staging instance everyday. Any suggestions?
0
votes
0answers
56 views

AWS DMS creates tables with no auto_increment

I am migrating my databases to Amazon's RDS using their DMS tool. Pretty much everything looks great except that columns that were marked as auto_increment on the source database did not get marked ...
0
votes
0answers
25 views

Loading Data from url

I am trying to create a plan for data load and wanted to bounce off best practice ideas and learn about amazon RDS. I have multiple url sources of data and a RDS MYSQL instance to store them. I want ...
0
votes
0answers
57 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
15 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 ...