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

0
votes
1answer
29 views

How to decide whether to enable MySQL query cache using InnoDB

How should the decision to enable / disable the MySQL query cache be made, on a server that uses just InnoDB tables. Say for example, if the cache is enabled, then how should the output of: SHOW ...
0
votes
0answers
12 views

Amazon rds MySql -> concurrent connections deadlocks

I normally hang around in StackOverflow but I think this issue is better suited here. I've built an application in C#.NET that uses MySql as a database. My application inserts and updates data in the ...
0
votes
0answers
23 views

While impoting 150 GB file on Amazon RDS, why connection is failing?

I am having Postgres database dump file of 150 GB on Amazon EC2 instance. While dumping the data on RDS from EC2 server I am getting error. The output of the command is as given below. It's giving ...
1
vote
1answer
55 views
+50

Replication from EC2 Master to RDS Slave - Connecting to master

I am migrating my company's database from an EC2 instance to an RDS instance. I have already migrated a snapshot of data and am now trying to set up replication to get the data that has been added ...
0
votes
1answer
18 views

Should I create a new instance of amazon rds or just a new schema inside of it?

I'm fairly new to Amazon Web Services and one of my customers asked me to install several things for them on EC2. I would normally use the same box as webserver and database server, mainly for ...
0
votes
1answer
16 views

Is it possible to recover from a LOST_EVENTS incident from an RDS read replica?

I was setting up a read replica of an RDS database for a reporting project, and issued an incorrect GRANT statement when configuring a user. My RDS read replica stopped, with an error message on the ...
3
votes
2answers
77 views

Privileges for database owner; application user

Quick version: What command should I issue to enable a database owner to allow it to access tables in this database and can this be done from that owner's account? Longer Version: I am creating ...
1
vote
1answer
38 views

Amazon RDS mysqbinlog “Could not find first log file name in binary log index file”

Preamble: We use RDS at AWS to manage our MySQL database. I know that RDS creates binary logs used for replication.. I want to harvest these binary logs and store them on S3, so that at any time, i ...
1
vote
0answers
40 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 ...
1
vote
0answers
44 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% ...
0
votes
0answers
15 views

RDS did not restore to a specific point-of-time on my MySQL instance. Why did that happen?

I'm using a MySQL 5.6.13 instance on RDS and accidentally wiped all the data in it (something like 2.5GB). I used the restore to point-in-time feature to recover all the data and it only recovered the ...
1
vote
0answers
47 views

Get postgres snapshot from Amazon RDS

I can not find a simple way to get a copy of the nightly backup I take of my Amazon RDS postgres instance so I can restore it on my local machine to play with. Right now I'm doing a pg_dump when I ...
0
votes
0answers
31 views

how to archive old entries from mysql on rds

I have an AWS RDS MySQL DB. I have ec2 instances and an s3. What I would like to do is only retain 60days old data and archive the rest. I'm still new at this so I'm not really sure what to do. What ...
0
votes
0answers
36 views

Querying Amazon DynamoDB vs Relational DB

I have never worked on Amazon DynamoDB and was wondering if someone with some experience could provide me with some insight. We have a massive table in our MSSQL database that we currently use to ...
0
votes
1answer
23 views

Managing deleted entries in large database table

Currently we are using Mysql 5.6 with Amazon RDS. We have table tracking uploads and we have a deleted flag in this table, we don't delete rows when a user subsequently deletes an upload. We do this ...
1
vote
2answers
80 views

Amazon RDS - and binary log rotation

New to RDS (used to having my own server in my own data center). We are on MySQL 5.6 on RDS. when a slave gets behind in replication lag, the master ceases to rotate out its binary logs. It is, ...
1
vote
1answer
100 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 ...
0
votes
1answer
56 views

I have delete database from mysql but storage is not freed

I have deleted multiple databases (schema) from mysql on amazon RDS but the storage is not freed, is there anything else I should do to free up the storage? I have a mysql database that the total ...
0
votes
0answers
63 views

SQL Server timeout expired in amazon RDS

Recently after i switch my db from amazon EC2 instance to RDS instance, my web application keep receiving timeout error for every 5 - 10 minutes. Timeout expired. The timeout period elapsed prior to ...
1
vote
0answers
20 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 ...
0
votes
2answers
142 views

Why is my RDS mysql slow query log full of server restarts?

One of my RDS mysql databases is giving me warnings about the slow query logs taking up significant space. The logs are rotated once an hour, and contain a dozen repetitions of: ...
2
votes
1answer
81 views

AWS RDS showing large growth in Write Ops/sec, despite low # DB connections?

I have a Multi-AZ AWS RDS instance running MYSQL 5.5 I've noticed that my write ops/sec are growing fairly rapidly, despite low (and sometimes zero) DB connections - see charts for Avg write ops/sec ...
1
vote
1answer
56 views

New users not working on MySQL 5.6 in Amazon RDS

I'm using the CREATE USER and GRANT commands as mentioned here http://dev.n0ise.net/2012/09/amazon-rds-mysql-add-additional-users-with-limited-previledges/ When I try to connect I get this in MySQL ...
2
votes
1answer
255 views

What is the optimal way to upgrade production RDS instance?

I have MySQL small RDS instance as part of my production system and I want to upgrade it to medium instance with provided IOPS. As old-school DBA I'm aware about "add slave; promote to master; ...
0
votes
1answer
87 views

What happens when the index size of my Mysql instance exceeds the innodb_buffer_pool_size?

I am using Amazon's RDS db.m1.small. innodb_buffer_pool_size is set to 1125.00 MB. Current index size is 1110.00 MB and growing slowly but steadily. I do not need more hard drive space. I want ...
0
votes
0answers
122 views

How do a I edit .conf file for a postgres AWS RDS?

I would like to alter pg_hba.conf in my postgres RDS instance so that I can require ssl. I have found the Parameters Group manager in the RDS which allows me to alter parameters but it just references ...
0
votes
0answers
92 views

INSERTS in a loop: Better to use NOW() for each row or PHP date() function once?

Consider a PHP application which inserts about 200-800 records in a loop via prepared queries and parametrized values. The PHP application is on Amazon Web Services, and the database server is in ...
0
votes
1answer
75 views

Can I see the status of a “repair by sorting” in mysql?

I am running an alter statement on a very large table. show processlist shows the state as "Repair by sorting". Is there a way to see the status, or get an estimate of how much work has been ...
0
votes
1answer
167 views

What performance should I expect from MySQL (Using Amazon RDS)

I'm trying to understand whether I'm doing something wrong, or expecting too much. I have an InnoDB table on a db.m1.large RDS (MySQL 5.6.13. 7.5 GB RAM) with ~1M rows. The primary key is a ...
0
votes
1answer
579 views

Not able to login on MySQL in AWS RDS using root

I am trying to connect my MySQL RDS from EC2. Under security groups I have made sure permissions are in place. $ mysql -h xxx.xyz.ap-southeast-1.rds.amazonaws.com -P 3306 -p Enter password: I am ...
3
votes
2answers
398 views

Stored procedures, binlog and SUPER privilege

I tried to create this function on Amazon RDS for MySQL: CREATE FUNCTION GetRootZoneId (zoneId INT) RETURNS INT READS SQL DATA BEGIN DECLARE _id, _parentId INT; SELECT zoneId INTO _parentId; ...
1
vote
2answers
1k views

How can I synchronize data between two RDS MySQL databases

I have 2 Amazon RDS MySQL instances, one is MySql v5.5 and the new one is 5.6. I want to upgrade the 5.5 to the 5.6 but you cannot do upgrades at this time, so we are trying to migrate the data. I ...
0
votes
1answer
105 views

Looking for suggestions to Migrate Amazon RDS Large Instance to non-amazon host - Live

We have an Amazon RDS Large instance with a database of about 20GB that needs to be migrated without having to take our website down or minimize downtime to less than a couple of hours. And I am ...
2
votes
1answer
105 views

Is there a way to achieve Workload Management in MySQL?

Is there a way to set up Workload Management in MySQL (in particular v5.5 on AWS RDS)? By Workload Management I mean the functionality implemented in e.g. Teradata, RedShift that allows ...
1
vote
1answer
48 views

Choose security group for restore-db-instance-to-point-in-time

When using the AWS CLI restore-db-instance-to-point-in-time command, I can't figure out how to set the security group. The doc on this page says: The target database is created from the source ...
0
votes
0answers
14 views

Is it possible to disable replication for a specific database in RDS?

My application uses a mechanism of SQL patches as part of the upgrade to a new version. Before running an upgrade, I need to try to run the SQL patches on a copy of the database to ensure they ...
1
vote
0answers
42 views

MySQL hang during “show collation” on Amazon RDS

MySQL is hanging when I try to do SHOW COLLATION on my Amazon RDS instance. I can use SHOW COLLATION fine with my local database, and other SQL commands work fine on my RDS instance. But Amazon SHOW ...
1
vote
0answers
124 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 ...
0
votes
2answers
858 views

MySQL : Extract SQL statements from binlog

I am trying the following command to extract SQL statements from binlog for using it in another database (Amazon RDS) mysqlbinlog /var/lib/mysql/binlog.000027 --start-position=54375264 ...
0
votes
2answers
170 views

Is an AWS SQL Server RDS “log capture” the same as a transaction log backup?

When an SQL Server RDS instance provided by Amazon is configured for a recovery model using Full transaction logging, will the transaction log be trimmed by the "transaction log capture" that Amazon ...
0
votes
0answers
137 views

Amazon rds lock wait timeout after restart

I have bunch of rails application servers which run a particular update query on every pageload on centralised amazon rds mysql (v5.1.63). Recently due to heavy load rds instance got restarted and ...
3
votes
2answers
2k views

How can I determine how many IOPs I need for my AWS RDS database?

I am migrating part of a mysql database into AWS. The data in question is 99% write, and each row has about 1k of varchar fields, a datetime and 4 ints. I estimate that we will need between 20-25k ...
2
votes
1answer
2k views

Why is my Amazon RDS instance so slow?

I currently run a Windows Server with SQL Server Express. I'd like follow best practice and separate the application from the database, so I've created an RDS instance and exported my database. ...
2
votes
1answer
393 views

Example of loading into RDS from S3 using SQL*Loader

Does anyone have a working sample of loading data into an Amazon AWS RDS Oracle database using SQL*Loader where the source file is on S3? In principle it's clearly possible. The Amazon RDS Data ...
0
votes
3answers
233 views

MySQL Large DELETE with JOINs

I have a large table players with ~20MM rows which joins to a table stats with ~300MM rows, among others (photos, ...). I want to DELETE all records for players that were born_on before 1950. I ...
3
votes
1answer
1k views

Create Table If Not Exists Hanging

I am still new to using databases, but currently I am using a mysql database and attempting to make my bash script unbreakable because it might be used in several different environments (dev, qa, ...
0
votes
0answers
97 views

Having trouble connecting tungsten replicator from EC2 to RDS

I am testing using Tungsten Replicator to help migrate large databases to RDS. I have no trouble setting up the service on the EC2 "master". I am using a second EC2 instance as a kind of relay server ...
0
votes
2answers
1k views

Too Many database connections on Amazon RDS

We are having problems with users running queries/views in Drupal that occasionally cause our site to freeze. The freeze occurs because the query causes the number of database connections to go up to ...
0
votes
1answer
1k views

Unable to connect to Amazon RDS instance [closed]

I recently created an oracle instance on Amazon RDS. Unfortunately, I'm not able to connect to the instance using Oracle SQL Developer. The (relevant) information I have from Amazon; Endpoint - The ...
5
votes
1answer
525 views

Best strategies to have a backup of an RDS MySQL database

I have an AWS RDS MySQL database. I'm not a DBA, so my knowledge is limited. I wish to design strategies to have zero data loss in case of a failure, in terms of replication or data backup. I know ...