On one of my AWS instances, I have a .sql file that's a dump from an RDS DB. I would like to use that file to restore the DB on the RDS instance. I tried looking for info on AWS but could not locate ...

I have hosted my database (MySql) on Amazon RDS service and also created read-replica in the same availability zone. I have send my read queries on that read-replica. Now a days my database is become ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

Is there anything "special" about the Amazon RDS Automated Backup Window, or is the backup window merely an arbitrary timespan in which the backup is expected to complete?
That is to say, if I have ...

I am asked to restore a Rails application to a postgresql RDS instance. There are many functions in C but looks like only superuser can create functions in C and I could not get superuser access on ...

I am really curious about the infrastructure of Amazon. When I create a new instance of RDS, it gives me a host, username, password.. Everything. Behind the curtains, how do they do this? It´s some ...

I am trying to connect to an AWS RDS instance from an AWS EC2 instance. I ssh into the AWS EC2 instance, and then issue the following command:
mysql -h xxxxxx.ciy4oapkpytm.us-east-1.rds.amazonaws.com ...

My questions is quite similar to Mysqldump from the Amazon RDS. I have the same behavior. Everytime when I do a backup using mysqldump my entire RDS freezes and hence my application is not responding. ...

I have the master running Mysql 5.5.38 on Ubuntu 14.04 LTS. The timezone in the master is UTC+5:30. The slave is in AWS RDS which runs in UTC. The slave is primarily used for running for SQL queries ...

I would like to add some fields to a table in all testing and production DBs, all of which are stored in PostgreSQL 9.3 on Amazon RDS.
ALTER TABLE users DROP COLUMN IF EXISTS device_language;
ALTER ...

I am having performance issues with an AWS RDS instance (running MySQL 5.6).
This is the backend db to an XMPP server called Tigase. According to Tigase Inc. this type of db instance should be able ...

We have a Postgres RDS instance in the AWS Oregon Region. For some supposed legal reasons, we have to host our client's European data in the Ireland AWS Region, but we need that data synchronized to ...

I am having an Amazon setup for my application and I use RDS server which runs MySQL server(Not done by me.Company got it done from some freelance admin).
I have a root user created in there but it ...

We are using Amazon RDS(db.m2.2xlarge), CPU usage is suddenly increasing gradually even after we reboot the DB Server. This is happening just past 2 days and we didn't give any new build recently.
I ...