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)

1
vote
0answers
83 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 ...
0
votes
1answer
41 views

restoring a EC2 snapshot on RDS

Is it possible to restore our database snapshot on ec2 directly on RDS as our database is very big ? If not can we restore using csv files. ?
2
votes
0answers
185 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
1answer
137 views

Synchronizing a RDS instance with another RDS instance

I have a database on an RDS Instance (master) that needs to be synchronized to another RDS instance (slave). I created a read-replica for the first one, but that is created as read_only so I cannot do ...
7
votes
1answer
113 views

Two servers, different execution plans. Several orders of magnitude difference in run time

Two servers, Development and Live. Live server is an Amazon RDS SQL Server Web instance. Both servers have identical schema and data. There is a good spatial index on the geometry column. On my ...
0
votes
1answer
274 views

SET sql_log_bin = 0 in RDS MYSQL 5.6

I have moved into RDS MYSQL 5.6 and now I have a problem. I have 5 read replicas and a/z master. I am trying to alter a table and want to change a column value and also on some tables I want to add a ...
12
votes
1answer
5k views

ERROR: no schema has been selected to create in

I am working on an amazon RDS postgresql database where I know there had been some issue with the public schema (maybe it was dropped). But apparently the schema exists, and anyway the problem is not ...
5
votes
1answer
172 views

Exporting SQL Server DB from my laptop to AWS RDS

I am following this tutorial from AWS to export a SQL Server database that currently sits on my laptop to Amazon Web Services RDS. In particular I am trying the Generate and Publish script wizard ...
1
vote
1answer
95 views

RDS Replication Error (Apply Error 1406 / Truncation)

I have a MySQL RDS instance as a master, created a Read Replica from it, and ran some schema change operations on it. To be specific, I changed the charset and collation of all the tables and columns ...
0
votes
1answer
151 views

How to Upgrade Master Slave MySQL on AWS RDS?

I already have Master Slave configuration on AWS RDS. We want to upgrade 5.5 to 5.6.23. ..What should be correct sequence to Upgrade ? 1. Upgrade Master ( Using Modify Instance ) --> Upgrade Slave 2. ...
3
votes
1answer
256 views

MySQL 5.5 to RDS 5.6 Replication Error

I am facing following error and unable to fix it. So far I have disabled binlog checksum on the RDS. [Warning] Slave I/O: Notifying master by SET @master_binlog_checksum= @@global.binlog_checksum ...
1
vote
1answer
431 views

MySQL RDS Error 1062

Normally we can skip 1062 duplicate error but in rds can we skip multiple 1062 errors in one go. For example we define slave skip error =1062 in my.cnf and restart slave. but in RDS MYSQL how can we ...
0
votes
1answer
84 views

Moving MySQL data from RDS to RDS

We have an RDS instance with about 200G of data in it. A few issues cropped up on our end, and we need to both change the collation and charset of all our tables, as well as have all the data ...
0
votes
0answers
32 views

Amazon RDS Read Replica

I would like to know, is the Read Replica is nothing but the slave server, where only reads are there. I created two mysql instances in amazon RDS, one is Read Master, and another is Read Replica. ...
0
votes
0answers
36 views

mysql 5.5 statement based to rds mysql mixed replication

I am moving to rds mysql 5.6 that has by default mixed replication. I am moving from 5.5 where I have statement based replication. I was wondering if i enable replication between them i.e make rds ...
2
votes
1answer
627 views

Amazon RDS t2.small as a production server

I currently have a m3.medium as production PostgreSQL server but I want to move it to RDS with the Multi-AZ feature. Since the CPU usage of our current server is never higher than 5% and the RAM ...
2
votes
3answers
211 views

Updating/Inserting 2000 entries takes over 12 hours to complete

I have three tables of around 10 million rows each in MySQL on Amazon RDS and I am finding the insert/update performance to be VERY slow. Each table contains unrelated data. Each table is regularly ...
0
votes
0answers
126 views

Query EXPLAINed differently on MySQL 5.6 (or Amazon RDS) and is very slow

I have the following query: SELECT ld.idDataAttribute AS idDataAttribute, ld.instance AS instance FROM logs l INNER JOIN logData ld ON l.idLog = ld.idLog INNER JOIN dataAttributes da ON ld....
0
votes
1answer
303 views

Table partition in aws MYSQL RDS master slave setup

we are looking to do a table partition in MYSQL RDS running 5.6, table size is large and takes around 6 hours to partition. Can we partition on rds slave and then later promote it to master. is this ...
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
1answer
91 views

RDS Postgres Peformance

I have recently set up a new RDS instance to test out working with a AWS postgres instance vs a heroku postgres instance. What I've found is that when I load an instance of 1000 entries in RDS its ...
4
votes
1answer
1k views

Local Backup from Amazon RDS PostgreSQL database

I have a PostgreSQL database on an Amazon RDS instance. I want to have a local dump of this instance. So far, I've tried with this: PGPASSWORD="Password" pg_dump -h mydb.xxxxxx.us-east-1.rds....
1
vote
0answers
92 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 ...
0
votes
2answers
115 views

AWS RDS Constant cpu (20%) utilisation

I have a RDS instance that has workload at specific time window, however, cpu utilisation is a constant 20% even outside this window. There is no replication configured. Can't find a solution for ...
2
votes
1answer
96 views

PostgreSQL query - works locally but not on AWS RDS

We have a large query that works fine locally but deadlocks on AWS RDS. According to cloudwatch we are not resource bound on CPU, disk or iops and nothing else should be accessing these tables. The ...
1
vote
0answers
189 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 ...
3
votes
1answer
505 views

How to change database encoding in an Amazon RDS Postgresql instance?

I need to create a database with SQL_ASCII encoding in Amazon RDS PostgreSql database instance. Since template0 and template1 are both with utf8 encoding, I get the following error $ createdb -h ...
0
votes
1answer
1k views

Import big CSV on Oracle

I have big CSV files and placed it on Linux (Amazon AMI). I have installed instant client on Amazon Linux AMI and I can connect to my Oracle database using SQL Plus. How can I import all the CSVs to ...
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 ...
2
votes
1answer
813 views

How to temporarily disable foreign keys in Amazon RDS PostgreSQL?

I'm migrating existing test environment to Amazon RDS PostgreSQL. The test framework has a feature of reloading data in certain tables to an earlier state. For this it disables foreign keys, deletes ...
4
votes
2answers
267 views

How to create INOUT assignment cast on Amazon RDS PostgreSQL? If not possible, then why?

I'm migrating existing application to Amazon RDS PostgreSQL. The application has cross-database support and for compatibility reasons it includes the following SQL: CREATE CAST (varchar AS numeric) ...
1
vote
1answer
271 views

PostgreSQL on RDS: How to bulk import data with FK constraints?

Is there an efficient way to bulk import data into a PostgreSQL 9.4 database on RDS that makes extensive use of foreign key constraints? The standard method of using pg_restore fails because RDS does ...
0
votes
0answers
99 views

CPU jumps massively and stays high, under very light load

We had two separate RDS instances exhibit the same pattern today. This was both during low load times, one during the lowest load time for that server. They both started at almost the same time. No ...
1
vote
0answers
284 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 ...
6
votes
1answer
820 views

GRANT USAGE on all schemas in a database? postgres

I want to GRANT USAGE to a user/role for a given database. The database has many schemas. I know there's an ON ALL TABLES IN SCHEMA, but I want "all schemas". I tried GRANT USAGE .. ON DATABASE, but ...
5
votes
2answers
294 views

Guid vs. integer ID for unique fields

This is really a generic question. Suppose I have a replication pattern of a single write DB and multiple read DB replication slaves - I do not have to have GUID's as my unique IDs fields. Is that a ...
1
vote
1answer
367 views

Configuring slave from EC2 master to Amazon RDS slave

I am configuring replication from EC2 master to Amazon RDS instance. After starting the slave, I don't see any errors but I see slave_IO: _thread is connecting. Master version:5.6.23 Slave ...
0
votes
2answers
341 views

Can we disable binary logging for one specific session or user in AWS RDS

Currently we have a situation to disable binary logging for one set of queries on AWS RDS. We thought to set log-bin=0 for that specific session. As per Amazon, this is not possible. Is there any work ...
0
votes
0answers
43 views

Will breaking down a bulky insert reduce the number of IOPS on MySQL?

Our RDS instance is setup to handle 1000 Provisioned IOPS. This number is fine for most of the time. But at some point we need to run several insert operations (each inserting 2K records), our IOPS ...
2
votes
0answers
548 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 ...
0
votes
1answer
198 views

mySQL running on 100% CPU both on RDS and EC2

How do we troubleshoot an issue with Amazon wherein my database queries (PHP/MySQL) are eating 100% CPU most of the day? Traffic=200 connections average mySQL version = 5.5.40 The ...
0
votes
1answer
157 views

What does “Latest Restore Time” says in AWS RDS(Mysql) instances page

I have two RDS MySQL instances and when I look at the instances page, I have seen a field named "Latest Restore Time" and the value for it is some time stamp in IST time zone. I would like to know ...
3
votes
0answers
675 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 ...
0
votes
0answers
28 views

Prevent Reconnections During Application Cluster Restart

I have a large cluster of application processes (>5000) spread out over multiple EC2 servers. When I attempt to restart them or deploy new code (with a restart), they all attempt to reconnect to the ...
3
votes
2answers
1k views

How to speed up select distinct?

I have a simple select distinct on some time series data: SELECT DISTINCT user_id FROM events WHERE project_id = 6 AND time > '2015-01-11 8:00:00' AND time < '2015-02-10 8:00:00'; And it ...
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 ...
3
votes
2answers
394 views

How to setup Oracle at Amazon RDS

I created a Relational Database Service (RDS) with Oracle database at Amazon Web Services (aws.amazon.com). However, when I attempt to connect to the database (with SQLDeveloper or Navicat), I am ...
3
votes
0answers
245 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
2answers
1k views

Why is Postgres on RDS maxing out on CPU every few hours?

Using Amazon RDS, we are running ETL scripts to migrate our data. However, every few hours there is a huge CPU spike. Here are the ETL specs (per ETL): 50 records inserted / second pool of 1000 ...
1
vote
1answer
2k views

Optimizing Amazon RDS - MySQLTuner Recommendations / Feedback & Suggestions

I'm currently trying to optimize a database I've inherited for speed. The server is an Amazon RDS db.m3.large instance: 2 VCPUs 7.5 GB Memory 500 GB HDD My current strategy is to do the following:...