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
0answers
5 views

Restoring a DB on an RDS instance from a local file

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 ...
0
votes
0answers
4 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 ...
0
votes
0answers
7 views

Amazon rds read-replica, use as archive database

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 ...
2
votes
0answers
11 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 ...
2
votes
1answer
31 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 ...
0
votes
1answer
23 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
11 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 ...
1
vote
0answers
45 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
29 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
0answers
7 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
41 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
21 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 ...
2
votes
1answer
69 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
2answers
66 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 ...
2
votes
0answers
61 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 ...
0
votes
0answers
20 views

Does automated backup performance suffer if backup completion time exceeds the backup window?

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 ...
0
votes
2answers
112 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 ...
0
votes
1answer
181 views

AWS RDS PostgreSQL dump/restore - syntax error

I am trying to import a postgresql database from an EC2 instance to RDS on the same subnet, so far I am doing the following... 1) Dump EC2 DB: pg_dump --host localhost --port 5432 -Fc ...
0
votes
1answer
63 views

Amazon RDS non superuser create function in C

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 ...
0
votes
0answers
27 views

Performance/Maintenance Implications of a Write Heavy Table In An Otherwise Normal “CRUD” Database

We have a small-ish (<100,000 rows) MySQL database (on Amazon RDS). Its supporting a fairly simple read heavy CRUD web application. Currently we're building out a web analytics system. It will ...
1
vote
1answer
93 views

Amazon Redshift - The difference between Query Slots, Concurrency and Queues?

We are building a business intelligence system, and we have a huge PostgreSQL Database (DB) where we make all the info processing, and a Redshift Data Warehouse (DWH) where we store the data and ...
0
votes
1answer
68 views

How does Amazon create the RDS for Postgres? Some kind of Docker?

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 ...
3
votes
1answer
224 views

Monitoring Amazon RDS with pgtop

I recently migrated a Postgres database to Amazon RDS and I am lacking a good live monitoring tool. I tried pgtop, but I can't get it to work on Amazon. I can see the header with the DB statistics ...
1
vote
1answer
95 views

Is there a way to run mysqldumpslow against slow queries logged to a table?

AWS RDS by default logs slow queries to a database table. Is there a way to run mysqldumpslow against that table, without exporting it to a file first? Or is there a better way to get a report of ...
0
votes
1answer
46 views

Moving Local PostgreSQL 8.4.20 Database to Amazon EC2 or RDS

I'm running PostgresSQL 8.4.20 on a local server and plan to migrate the data to either Amazon EC2 or RDS. I have working knowledge of databases and need advice from experts. I've been researching ...
2
votes
2answers
70 views

Cannot ALTER TABLE

I have a particular table that I cannot add a key for: mysql> ALTER TABLE tasks ADD KEY `fruitful_user_count` (`user_id`, `is_fruitful`); ERROR 1034 (HY000): Incorrect key file for table 'tasks'; ...
2
votes
1answer
99 views

innodb_thread_concurrency vs slave_parallel_workers

I am new in rds, but I am facing server performance issue. I got these two variable but I am confused what exactly is difference between innodb_thread_concurrency and slave_parallel_workers.
0
votes
0answers
97 views

Problems with migration from Amazon RDS MySQL to MariaDB

We are trying to migrate from Amazon RDS MySQL to MariaDB for the performance benefits given by MariaDB. We have copied all the data from Amazon RDS MySQL to MariaDB and the database is up and ...
2
votes
2answers
173 views

Mysqldump throwing error 'Couldn't execute 'ROLLBACK TO SAVEPOINT sp':

Can any one please explain what is happening with our DB dumps? We are executing dump as below mysqldump -v --single-transaction --quick --lock-tables=false --skip-triggers -uXXX -pXXX ...
1
vote
1answer
67 views

optimizing query for slow queries

I have this query in my slowqueries table which essentially is taking about 5-8 seconds to complete the query time: SELECT s0_.id AS id0, s0_.updated AS updated1, s0_.created AS created2, ...
1
vote
1answer
270 views

How to migrate postgreSQL on EC2 instance to AWS RDS?

I have a large PostgreSQL DB (around 100GB) which is on EC2. I want to migrate it to RDS. How can I achieve this with minimal downtime?
0
votes
0answers
63 views

Trying to connect to AWS RDS from an AWS EC2 instance

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 ...
0
votes
1answer
82 views

Amazon RDS freezes on mysqldump

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. ...
0
votes
1answer
135 views

too many connection error mysql: how to calculate max_connections

how to calculate this values to get the best results to resolve this error "too many connection error mysql" and make my API faster in mysql wait_timeout = ?? max_connections = ?? ...
0
votes
1answer
157 views

How to connect to an Amazon PostgreSQL database using SSL

I'm trying to log into an Amazon PostgreSQL DBS using SSL. I have all credentials but my psql version doesn't seem to support SSL. I've tried searching Postgres docs but all I see is how it has ...
0
votes
0answers
129 views

Will I still benefit from provisioned IOPS in RDS on a smaller non-PIOPS-Optimized instance type?

Quote from the docs: If you are using Provisioned IOPS storage, we recommend that you use the db.m3.xlarge, db.m3.2xlarge, db.m1.large, db.m1.xlarge, db.m2.2xlarge, db.m2.4xlarge, ...
2
votes
1answer
447 views

Create t2 instance and connect via Wokrbench

I've created an t2 RDS instance inside a VPC. The instance is set to Publicly avaiable: No. I wasn't able to connect to the instance using MySQL Workbench. Is there an option to connect to the ...
2
votes
1answer
123 views

IOPS on Amazon RDS

I'm very very new to AWS. Is one insert record operation on an Amazon RDS table counted as 1 IOP? I have a use-case of inserting about 1 million records every day, and would like the job to finish ...
0
votes
2answers
267 views

Replicated timestamp column in different timezone

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 ...
1
vote
4answers
659 views

Amazon: How to change database name in Amazon RDS MySQL?

I want to change MYSQL database name of the DB instance of Amazon RDS. How it can be possible?
2
votes
2answers
111 views

Is it safe to delete the innodb schema on a new Amazon RDS instance?

As per the title, I'm struggling to find out if it's safe to delete the innodb schema that's created on a fresh Amazon RDS instance. mysql> SHOW DATABASES; +--------------------+ | Database ...
0
votes
0answers
11 views

Will deletion of an RDS db snapshot affect the running instance?

Will deletion of an rds db snapshot affect the running instance? (I assume not but I'm being a bit paranoid since it's an extremely important customer db.)
0
votes
0answers
57 views

PostgreSQL: How can I identify the connections which is blocking ALTER TABLE?

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 ...
3
votes
1answer
369 views

MySQL RDS Instance eating up memory and swapping

I have an issue with memory on a RDS instance which is of db.m2.4xlarge class. Below are the specifications of the RDS instance Instance Class: db.m2.4xlarge ( 68.4 GB of RAM ) Engine: ...
2
votes
1answer
1k views

Finding reason behind high write IOPS on MySQL (RDS) server

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 ...
1
vote
1answer
121 views

What does exec(text) do?

I just found the following function in two RDS PostgreSQL 9.3 DBs: -- -- Name: exec(text); Type: FUNCTION; Schema: public; Owner: adam -- CREATE FUNCTION exec(text) RETURNS text LANGUAGE plpgsql ...
2
votes
0answers
449 views

Is there a way to replicate Postgres databases in Amazon RDS between regions?

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 ...
0
votes
0answers
109 views

Granting file privilage for an user on amazon RDS(MySQL)

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 ...
0
votes
1answer
623 views

Amazon RDS CPU Usage keep increasing without any long running process in Show Processlist

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 ...
0
votes
2answers
50 views

Mysql replication with c

I have huge database on MySql and It's become more and more huge. So, Now I am facing performance issues with my database. Some of tables has millions of records in it. like my login detail table ...