The tag has no wiki summary.

learn more… | top users | synonyms

3
votes
1answer
131 views

Active/ Active SQL Server Clustering on AWS

I need to design and implement a highly available SQL Server 2012 clustering on Amazon AWS. In the white paper presented by Amazon, they provided an example of Active/ Passive SQL Cluster. Do you know ...
2
votes
0answers
25 views

Using AWS DynamoDB Geospatial index with Python

Amazon's AWS DynamoDB features Geospatial Indexing, which facilitates geo queries: Query Support: Box queries return items that fall within a pair of geo points that define a rectangle as ...
2
votes
0answers
772 views

MySQL Server hitting 100% unexpectedly (Amazon AWS RDS)

We've been struggling with this issue for months. This week we upped our RDS instance to the highest performing instance and although the occurrences have reduced, we're still seeing our database ...
1
vote
0answers
64 views

PostgreSQL continuous archiving - use snapshot for base backup on AWS?

I'm new to AWS and PostgreSQL admin and have been poring over the docs trying to come up with a good backup strategy for a fairly simple setup. I have a single Amazon Web Services EC2 instance that ...
0
votes
0answers
13 views

How to replicate an Oracle 11g DB on AWS

Our client gave us an RMAN back for Oracle Enterprise 11.2.0.3 and we wanted to replicate it on AWS We are unable to do so because the default AWS server runs 11.2.0.1 and we do not have a licensee ...
0
votes
0answers
15 views

No privileges on the admin

I am using MySQL on AWS, and I came to horrific realization that privileges were flushed shut N across the board today. I was able to view this from an other user has very few privileges, but one of ...
0
votes
0answers
54 views

how to archive old entries from mysql on rds

I have an AWS RDS MySQL DB. I have ec2 instances and an s3. What I would like to do is only retain 60days old data and archive the rest. I'm still new at this so I'm not really sure what to do. What ...
0
votes
0answers
47 views

AWS + Heroku db

I have my environment on Amazon cloud (AWS-Ireland), and I'm planning on having my postgres DB hosted in Heroku. I have couple of questions regarding this setup: I know I can choose to have my ...
0
votes
0answers
37 views

AWS - Only Use IOPS as Needed?

We are running an EC2 Instance with MySQL and and IOPS Volume. (We will eventually be upgrading to RDS but this is what we have for now) We have peak times where the IOPS really helps, but the rest ...
0
votes
0answers
118 views

Booted by MYSQL Error (2003) 10060 mid way through work

I was working on some queries and then my HeidiSQL froze, I tried to reboot the connection and I get good old MYSQL Error (2003) (10060). It worked just fine before that. I haven't made any firewall ...
0
votes
0answers
66 views

Merging Large Database Tables Quickly

So I found this other post; Merge multiple tables in a database And that's the general idea, but at an insanely large scale. Anyway -- Over the years, Our site has adapted and three different things ...