Amazon Web Services.

learn more… | top users | synonyms

0
votes
0answers
10 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 ...
1
vote
2answers
254 views

SQL Server hangs during backup on EC2

Once and then our SQL Server will "hang" during its weekly full backup. When this happens, external connections start to timeout. The symptoms are: Connections timeout The sqlservr.exe process sits ...
0
votes
0answers
12 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
17 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
votes
0answers
32 views

MongoDB Pricing [closed]

I can't find a good article with MongoDB pricings and I am trying to estimate how much it would cost for my company if we would use it in production environment. Could you help me to estimate/provide ...
1
vote
0answers
19 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. ...
2
votes
2answers
169 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: ...
1
vote
2answers
101 views

Recreate a table that was deleted during an ALTER statement (errno: -1)?

For the third time in the past 2-3 weeks I've gotten the following message during an ALTER statement: Error 2013: Lost connection to MySQL server during query SQL Statement: ALTER TABLE ...
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 ...
0
votes
1answer
205 views

Issue using COPY command with AWS Redshift

I am trying to copy a CSV file from my PC, which has SSH running, to AWS Redshift. I have copied the Redshfit public key to authorized_keys for the appropriate user. copy contact (id,name) from ...
0
votes
0answers
10 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
2answers
804 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 ...
1
vote
1answer
50 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
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 ...
0
votes
0answers
33 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: ...
1
vote
1answer
138 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
3answers
135 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. ...
3
votes
1answer
593 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
1answer
23 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. ...
1
vote
1answer
264 views

Multi Session Mirroring using 1 witness server, cannot find certificate

I am trying to use 1 witness server for 2 mirrored databases that reside on different servers. For example: db1 on server(A) mirrored to server(B) using witness server(1), and db2 on ...
5
votes
1answer
101 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
2answers
325 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
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
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 ...
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
149 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 ...
1
vote
1answer
631 views

Replication Lag on Postgres AWS RDS Service

We have a single master/single streaming replica Postgres 9.3 db on AWS. The load is not terribly high - this is a development/staging environment. (The production shows similar metrics). Point is the ...
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. ...
0
votes
0answers
54 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
1answer
357 views

Amazon RDS replication with external slave

I've recently configured a replication with an external MySQL master and RDS as slave but now I need to reverse that config and use RDS as master and the other instance as slave. Actually I use a vpn ...
0
votes
0answers
32 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 ...
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
70 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
93 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
2answers
249 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 ? ...
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 ...
1
vote
0answers
69 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 ...
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
23 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, ...
2
votes
1answer
97 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 ...
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 ...
1
vote
1answer
204 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 ...
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 ...
0
votes
3answers
2k views

SQL Server replication service in Amazon RDS

I have a local infrastructure with multiple SQL Servers. Some of the servers have replications services to copy some data to a master database. Is it possible to have the replication services to work ...
0
votes
0answers
45 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 ...