Amazon Web Services.

learn more… | top users | synonyms

0
votes
0answers
17 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 ...
0
votes
0answers
15 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 ...
1
vote
0answers
25 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
41 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
49 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
46 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
22 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
99 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
54 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
30 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
19 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
14 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
12 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
37 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
33 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
54 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
55 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
65 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
45 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
32 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
61 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 ...
0
votes
0answers
14 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
13 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
20 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
390 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
138 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
1answer
98 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. ...
0
votes
2answers
602 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
115 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
147 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 ? ...
0
votes
0answers
38 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. ...
0
votes
0answers
14 views

Spreading out iops use at Aws

Is there a way to store event info, such as those triggered by a listened to Dom event, and feed that info into a database at a specific rate? Using Aws databases usually means provisioning a set ...
0
votes
1answer
75 views

AWS RDS query running extremely slowly

I am testing out AWS RDS to replace a local DB and in general I am finding the latency etc acceptable for most of our use-cases. There is one particular query that we run manually (i.e. in SQL Server ...
0
votes
2answers
38 views

EC2 and setting up MYSQL Replication

my database size is very big around 100gb and when I restore it takes 3 days to restore. I am using amazon ec2. My question is I want to setup a new slave to MYSQL master, can I take a snapshot of ...
2
votes
1answer
240 views

Amazon RDS t2.small as a production server

I currently have a m3.medium as production PostgreSQL server but I want to move it to RDS with the Multi-AZ feature. Since the CPU usage of our current server is never higher than 5% and the RAM ...
2
votes
0answers
85 views

MongoDB C# driver fails to reconnect after stepDown

I have an Elastic Beanstalk environment in AWS that constantly verifies the DB is accessible by querying the mongos for one document. We only speak to the DB routers and not to specific instances. ...
0
votes
1answer
80 views

How do I 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 ...
0
votes
1answer
32 views

database with same schema and same AWS instance type, but different performance

Hi I am getting a new set of production servers ready. I generated a DB script from SSMS using the schema from Server A to deploy to a new AWS instance of the same type as Server A. After populating ...
0
votes
2answers
89 views

AWS RDS Constant cpu (20%) utilisation

I have a RDS instance that has workload at specific time window, however, cpu utilisation is a constant 20% even outside this window. There is no replication configured. Can't find a solution for ...
0
votes
2answers
168 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 ...
2
votes
1answer
71 views

PostgreSQL query - works locally but not on AWS RDS

We have a large query that works fine locally but deadlocks on AWS RDS. According to cloudwatch we are not resource bound on CPU, disk or iops and nothing else should be accessing these tables. The ...
0
votes
0answers
125 views

How to backup huge Mysql db containing both InnoDB & MyISAM tables in Aws RDS?

I am running a Mysql RDS with 150GB+ data. The DB size is growing very fast(But normal considering the application's nature) Till now we were having only InnoDB storage engine, so we were using the ...
0
votes
2answers
49 views

Table JOIN and CREATE new table extremely slow

I'm using something like this to create a new table: CREATE TABLE result AS (SELECT calls.*, targ_with_planned_calls.* FROM calls INNER JOIN planned ON calls.first_id = ...
1
vote
1answer
175 views

SQL Server 2012 CPU usage spikes to 100%

I am using SQL Server 2014 in AWS and the AWS image configuration is 4 cores and 16GB RAM(m3.xlarge). I am running the following simple query, SELECT * FROM user_table WHERE user_id = '10' ...
0
votes
1answer
632 views

Does AWS Aurora suffer from the same limitations that MySQL suffer from? [closed]

Specifically, MySQL has a limitations max row size as 64kB. I would like to know if Amazon Aurora, which is supposedly a drop in replacement for MySQL suffer the same limitation.
0
votes
0answers
37 views

Amazon RDS backup space requirements

It's very unclear to me how much space an Amazon RDS DB backup actually needs. The pricing page says: For example, if you have an active DB Instance with 10GB-month of provisioned database ...
0
votes
0answers
273 views

Mongodb replica set across AWS regions or subnets or data centers

I seem to have run into a blocking problem. I want a certain collection to be replicated across multiple AWS regions/subnets/data centers (eg a global lookup table or a global user credentials table) ...
0
votes
0answers
95 views

Load Large data set SSIS AWS EBS

We have configuration of SQL 2012 std edition hosted in Amazon cloud that has data disk of 3 TB, Index disk of 3 TB, Log disk of 500 gb all raid 0 stripped. Am trying to load a table that has 8 ...
1
vote
1answer
200 views

Can't connect to EC2 Postgresql instance unless I change the default port 5432 [closed]

I just created a brand new EC2 instance with a default security group allowing All Traffic from Anywhere. My listen_address is set to * I can SSH to it but I can't connect to the pgsql instance ...
1
vote
1answer
385 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 ...