Amazon Web Services.

learn more… | top users | synonyms

1
vote
0answers
19 views

psql in windows

I want to connect to Amazon Redshift and run scripts like exports to s3 and loads through command line. is psql the only way to go? If that is the case, is there a package that would install just ...
0
votes
0answers
20 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
21 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 ...
1
vote
0answers
20 views

Mongo is slow when the IOPS reaches 50%

We have an AWS-r3.large system. With 1.5TB data volume dedicated to Mongo. We are still using 2.6.3 (yes, upgrade pending for a while now). The data size is only 550GB. The volume that we have, has ...
0
votes
0answers
20 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
5 views

Is there an option to create a sub-table in AWS DynamoDB?

I have an AWS Account and a table named like in the DynamoDB service. I have wanted to know if there is any option to create a sub-table to a table in DynamoDB?
1
vote
1answer
30 views

How to set up Amazon RDS parameter group for Postgres?

I'm trying to create a parameter group in Amazon Web Services for an Postgres 9.5 RDS instance. I'm a little confused by the units being used for things such as shared_buffers and min_wal_size. ...
1
vote
1answer
13 views

Is this work flow suitable for Amazon RDS?

I am considering to set up a MySQL database via amazon web services (AWS). Consider the following steps which characterize my workflow: There is a daily data inflow into several AWS EC2 instances On ...
1
vote
1answer
51 views

How to skip the current 'Relay_Master_Log_File' in AWS MYSQL RDS?

Below is the status of my slave. The master log file is at position "mysql-bin-changelog.278337" but the slave log file is at position "mysql-bin-changelog.278008". How to skip the current executing ...
0
votes
0answers
37 views

Understanding MongoDB Log warning

In my MongoDB log, I am seeing these lines of messages: 2016-04-05T00:03:42.904+0000 I COMMAND [ftdc] serverStatus was very slow: { after basic: 200, after asserts: 240, after backgroundFlushing: ...
0
votes
1answer
9 views

In RDS digest function is undefined after creating pgcrypto extension

On an AWS RDS instance, we have run CREATE EXTENSION pgcrypto; The extension gets created. Both queries: SELECT digest('a', 'sha256') FROM table_name; SELECT public.digest('a', 'sha256') FROM ...
1
vote
1answer
142 views

Postgres sharding installation with citusdb

We are developing a prototype for a BIG data product. We have almost 2 billion records. We have used PostgresSQL 9.5 as a back-end and Python as front-end. We are using a 16*2.4 GHz processors with ...
0
votes
2answers
24 views

Give third-party access to AWS hosted MySQL

I have a production MySQL database hosted on AWS for an eCommerce store I work with. Employees in the firm are requesting access to our live SQL database to use with BI tools like Tableau/Qlikview. ...
0
votes
0answers
23 views

How can i delete an orphaned table from AWS RDS database?

Info: Database is an RDS instance (MySql) Yesterday i tried to add a field to a table and did an Alter table command. There is probably some millions of records in that table. After a while it just ...
0
votes
0answers
24 views

Database Authentication Security

I have issue with database authentication. We have a database on AWS database and application uses this database and we have different users who uses the application. There are several components on ...
1
vote
1answer
61 views

Change AWS's Read Replica's streaming replication to trigger based replication

We have a Postgres RDS instance for which we have created a read replica instance. The problem we are facing is that, that whenever there is a long running query(about 30-40 mins) on Read Replica, it ...
1
vote
0answers
35 views

AWS RDS: Running db dumps in to the server really slow

I am migrating data from out servers to AWS (from MySQL to Aurora) and inesrting the data is terribly slow. Is there a way to speed things up? Right now I'm creating gzipped dump files on our server ...
3
votes
1answer
153 views

RDS crosstab: ERROR: permission denied for language c

We're currently using PostgreSQL 9.2 in our production database, we want to migrate to a new RDS instance, using PostgreSQL 9.4. However, we need to have permission to create a function, but only ...
0
votes
0answers
58 views

RDS Large SQL Server Instance high cpu low connections?

We are routinely getting high CPU usage with only 12 connections on our M3.large instance. I'm not particularly skilled with AWS RDS, please forgive any ignorance or obvious mistakes. But I don't ...
1
vote
0answers
35 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 ...
5
votes
1answer
102 views

AWS RDS databases & SSIS

I have 2 AWS RDS databases (A & B) and need to create a datawarehouse with star scheme and slowly changing dimensions within AWS. From a MS background it makes sense to create a SSIS package to ...
0
votes
1answer
66 views

AWS EBS I/O Bottleneck

I'm hoping someone can help me understand some EBS Bottlenecks that we are experiencing with a new Windows SQL Server instance we're configuring. We're running some tests by conducting a full backup ...
3
votes
0answers
71 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 ...
0
votes
1answer
95 views

RDS innodb_flush_log_at_trx_commit problem

I use Amazon RDS as mysql db backend for highload project and try to optimize insert performance for innodb tables. According to information from different sources - good candidate to speed up inserts ...
1
vote
0answers
72 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
1answer
126 views

High data traffic from MySQL server to web server

I have one webserver running Magento : Community Edition 1.7.0.2 and a separate machine with MySQL 5.5.42 on it. Both machines are EC2 instances. I am seeing huge unexpected data traffic from the ...
2
votes
2answers
174 views

Deciding EC2 Instance type & Volume IOPS for Mongo DB

We have 500GB data in our Mongo(v2.6.3) including the indexes. We currently run this on AWS m3.large(8GB RAM) instance. Yes, Single machine. Our MongoDB Cloud Manager shows these stats: ...
2
votes
1answer
33 views

Mysql RDS migration problem

I'm trying to migrate my MySQL RDS to a different machine. The reason is that I need smaller disk, and you can't make disks smaller for RDS servers, only bigger. I'm trying to migrate with this ...
0
votes
0answers
39 views

RDS Data Loss after modify DB instance

I recently modified the size of one of our RDS instances in AWS, after this operation had completed overnight I came in to find that some of the jobs had dropped out of SQL Server Agent & the job ...
2
votes
0answers
24 views

how to convert mongodb(2.4.10) startup2 to primary

I have standalone bitnami mongodb(2.4.10). The output of rs.status() command is below : rs.status() { "set" : "test", "date" : ISODate("2015-11-13T08:07:41Z"), "myState" : 5, ...
0
votes
0answers
23 views

AWS RDS Postgresql restricted user

When you create a RDS instance (Postgresql) on AmazonWebServices you create a user that is a part of rds_superuser role. This user is sort of an administrator and is therefore not appropriate to use ...
0
votes
0answers
46 views

What would cause database CPU load to increase 5x+ during peak hours, when traffic only doubles?

I'll start with a screenshot of CPU load on my database server for the past three days. http://i.imgur.com/sSZJdCb.jpg As you can see, it spikes from 20% to 100% load every day (would be even higher ...
2
votes
2answers
49 views

Troubles connecting to a SQL Server Express instance on AWS

I'm trying to remote connect a SQL Server Express instance that is running on AWS on a db.t2.micro. I'm getting the following error: A network-related or instance-specific error occurred while ...
2
votes
1answer
99 views

AWS RDS - Changing Instance Class

So I'm fairly new to AWS and I'm hoping you guys can reassure me as I couldn't find anything in the AWS documentation either way. I actually have two questions, the first: I have an RDS MySql ...
1
vote
1answer
216 views

storing files on mongodb

I am developing an app where user will upload multiple images along with some other data like name address etc. I am using MEAN stack for development, So I have some questions regarding this: How ...
0
votes
0answers
84 views

rds db.m3.large unexplainable low performance

I'm really hoping someone could help me figure this out. We run mysql 5.6 on a db.m3.large instance, with Storage TypeStorage Provisioned IOPS (SSD), 300G/3000IOPS and encrypted storage. Our current ...
2
votes
1answer
68 views

Which AWS database services are designed for storing logging records like log4j or log4perl?

I have been using the file system for log4j and log4perl records and want to start using a database to store the information, especially to lookup records organized by pid. We are using MySQL RDS for ...
1
vote
1answer
42 views

Create a quick report for a client

I have an Amazon RDS (postgres) database and an client asked me to have access to certain data stored in this database preferably in the form of a comma separated file. If the data changes, the client ...
1
vote
0answers
96 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
1answer
35 views

Where to store data on AWS?

I'm using AWS to host my application, and I'm using mongodb as db. I have installed mongodb on amazon ec2, but now I have no idea about where I should store all of my data. Can I store all of my data ...
0
votes
0answers
17 views

Redshift schema access permissions not applied to new tables [duplicate]

I've granted privileges to a group in Redshift: GRANT USAGE ON SCHEMA public TO GROUP read_clients; GRANT SELECT ON ALL TABLES IN SCHEMA public TO GROUP read_clients; However when I create a new ...
0
votes
1answer
26 views

Copy postgis layer from S3 to Heroku

I have a dump of a postgis layer (layer.dump), which I am trying to add to my heroku database (mydatabase). The postgis layer is stored on S3 (https://s3.amazonaws.com/layer.dump). I would like to add ...
0
votes
1answer
1k views

Problem when connecting to SQL Server

I'm trying to connect to my SQL Server Express and I get this error. This happens both locally and on client. Connection Timeout Expired. The timeout period elapsed during the post-login phase. ...
3
votes
1answer
256 views

SQL Server Multi Tenancy Setup

What is the best way to use Multi Tenant Database Architecture when all of the "Tenants" will be from the same company? We are going to be using AWS and SQL Server for our backend system. We ...
0
votes
3answers
136 views

Increase SQL Server Performance

I have a fairly simple SQL Server 2014 Standard database with one main table. Here's the workload: I insert a row, do a few updates to it (up to 5 updates), and move on. I always update recent rows. ...
1
vote
2answers
805 views

MongoDB: Server sockets closed after a few minutes

I am working with multiple AWS intances connected to the same mongo database (inside Compose.io Elastic deployment) but I keep getting the error server <url>:<port> sockets closed after a ...
2
votes
1answer
174 views

How to have remote standby PostgreSQL server in different location (AWS)?

We have a primary PostgreSQL 9.4 server running multiple instances in our DC. It is using Continuous Archiving via WAL-E out to AWS S3. I would like to have a hot/warm standby server in our VPC within ...
1
vote
2answers
255 views

MySQL / DRBD / Pacemaker on EC2

I am trying to setup DRBD/MySQL/Corosync/Pacemaker on AWS EC2 instances, though I am not sure if it will work since how to integrate VIP is a problem for me. Anyone have any thoughts on what to do ? ...
3
votes
1answer
601 views

Domain Admin on AWS lacking user rights to edit the top 200 using the Management Studio interface

I setup an application + SQL Server on AWS. Everything works fine my SQL User can read/write to any table. Now I connected to the SQL Server using my domain admin account using windows authentication ...
0
votes
0answers
39 views

What options exist for replicating SQL Server over the public internet

Specifically, I'd like to set up a reporting copy of a SQL Server 2012 transactional database. This primary runs in a managed services provider, and I want a copy in an AWS EC2 SQL Server instance. ...