The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
1answer
94 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 ...
1
vote
1answer
38 views

How to decide whether to enable MySQL query cache using InnoDB

How should the decision to enable / disable the MySQL query cache be made, on a server that uses just InnoDB tables. Say for example, if the cache is enabled, then how should the output of: SHOW ...
2
votes
0answers
657 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 ...
0
votes
0answers
13 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
11 views

Managing code and deployments to Amazon Redshift

I am finding it difficult to manage and deploy schema changes to my Amazon Redshift database. Ideally, I would like is to have the code for my database under source control and use a schema ...
0
votes
0answers
34 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
33 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
33 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
91 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
51 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 ...
0
votes
0answers
99 views

Having trouble connecting tungsten replicator from EC2 to RDS

I am testing using Tungsten Replicator to help migrate large databases to RDS. I have no trouble setting up the service on the EC2 "master". I am using a second EC2 instance as a kind of relay server ...