amazon-rds

What are your experiences regarding performance with amazon-rds

Did you try amazon-rds? How is it, performance-wise? ...

How do I move data from Postgres to MySQL running on Amazon's RDS?

I need to move a database with a Django schema from Postgres to MySQL, running on Amazon's RDF. I can re-generate the tables using manage.py, but I'm still looking for a way to migrate over all of the row data. Does anyone know a clean way of moving it over? Are there any gotchas to watch out for with Amazon's RDF? ...

how to 'load data infile' on amazon RDS?

not sure if this is a question better suited for serverfault but I've been messing with amazon RDS lately and was having trouble getting 'file' privileges to my web host mysql user. I'd assume that a simple: grant file on *.* to 'webuser@'%'; would work but it does not and I can't seem to do it with my 'root' user as well. What gives...

Amazon RDS: can databases be setup in replicaton mode?

I am studying the new Amazon RDS product and it seems it can be scaled only vertically (i.e. put a stronger server). Did anyone see a possibility to configure multiple instances so that one is master and the other/s is/are replication slaves? ...

How to 'switch' from MySQL to Amazon RDS with minimal application impact?

Amazon officially states: "Amazon RDS gives you access to the full capabilities of a familiar MySQL database. This means the code, applications, and tools you already use today with your existing MySQL databases work seamlessly with Amazon RDS." I don't get this. Amazon RDS is accessible via web services and there a client libraries (li...

Are Amazon RDS instances upgradable?

Hello. Will I am able to switch (I mean upgrade or downgrade) Amazon RDS instance on need basis or do I have to create a new afresh and go through migration? ...

Is it better to have multiple databases vis-a-vis multiple instances on Amazon RDS?

Hello. I am planning to deploy my web application (ASP.Net based) on the Amazon EC2 and the persistence on Amazon RDS. I have a 'gut feeling' that at least my session store (again on RDS) should be separate from the rest of the application database. This is because I am expecting high activity in the session store. RDS supports the abili...

Best 'logging' option on Amazon Cloud. RDS or SimpleDB?

Hello. My site's architecture includes ASP.Net & MySQL. I am planning to deploy it on Amazon Cloud. This would mean EC2 instance(s) and RDS. My query is regarding logging. I'm ensuring that my application is stateless, so logging on application tier is ruled out. All state/persistence goes into RDS. When it comes to logging, I am not ...

Amazon EC2 High Availability Database Architecture

I'm currently spec'ing out a solution running on EC2. Setting up web servers, utilizing S3, Cloud Front, Cloud Watch, etc have been straightforward enough. Using Elastic Load Balancers for HA cross Availability Zone for our web servers has also been straightforward. I would really like to have cross Region Availability in addition to cr...

Can you use Cacti to monitor MySQL on Amazon's RDS?

I noticed that the instructions to setup cacti with mysql mention granting SUPER priveleges: Create a MySQL user with the SUPER and PROCESS privileges on each server you want to monitor However, it looks like using the Relational Database Service from Amazon (RDS), you cannot grant SUPER privileges. Does this mean I can't use cact...

Amazon RDS (Relational Data Store) and SSIS

Does anyone know if it is possibble to use SSIS with Amazon RDS? Since RDS is essentially MySQL - would this be possible using OLE DB or something...? ...

Basic Questions about Amazon RDS, S3 Storage, and Default RDS Tables

I just created my first database instance on the Amazon RDS service. I was wondering... 1) Is there a way to have Amazon automatically back up my data in a way that it persists even if the instance is deleted? 2) Is it possible to share tables across multiple instances? 3) When I first connected to the instance, I found there were thr...

Do I need Amazon's EC2, Cloudfront, RDS?

Hello, I want to publish a web site on Amazon's servers, that: Runs CakePHP Uses MySQL to store data Lets users upload audio through flash (currently using a hosted Flash Media Server), and listen to the files later Do I need Amazon's EC2 for the website, RDS for the MySQL database, and CloudFront for the FMS? I'd really like a walk...

Are default mysql parameters in RDS sane?

RDS uses the same set of parameters for all instance sizes and they don't seem to be that far from defaults (max_packet_size being too small etc.) Has anyone looked at them and reviewed them for how sensible they are, especially on relatively bigger instances? ...

Are there any less costly alternatives to Amazon's Relational Database Services (RDS)?

Hi All, I have the following requirement. I have with me a database containing the contact and address details of at least 2000 members of my school alumni organization. We want to store all that information in a relation model so that This data can be created and edited on demand. This data is always backed up and should be simple to...

Not able to get the amazon RDS instances using AWS .NET SDK.

I'm not able to connect to my database in RDS from local machine.... Here is my code: Amazon.RDS.AmazonRDSClient client = new Amazon.RDS.AmazonRDSClient(myPublicKey, myPrivateKey); Amazon.RDS.Model.DescribeDBInstancesRequest instanceRequest = new Amazon.RDS.Model.DescribeDBInstancesRequest(); Amazon.RDS.Model.DescribeDBInstancesRespo...

Reporting Service for Amazon RDS?

I'm curious if anyone has any leads for me on this: I have a business app that we're building, that could benefit from some out of the box reporting services. Looking for reports that can be created and customized by the end user, without (too much) developer support. Think crystal reports / MS Access reports, but better and all web b...

EC2 connection to RDS using Play framework

I have a small site I built using the Play framework that I'm trying to run on an EC2 server against an Amazon RDS instance. I can run the app on my machine against the RDS instance and everything works fine. But when I deploy it to my EC2 server it gets this error: The last packet successfully received from the server was 1,282,977,73...

How to copy a database using RDS

Hello, I have a database instance on RDS with 2 databases on it. Is there a good way using the RDS command line tools to copy the one database to the other? If not, what is the recommended way of doing it? Thanks in advanced. ...

Trouble connecting Heroku App with Amazon RDS Instance

I'm using Amazon RDS for the first time ever and I've been following the heroku docs to get my app using the RDS instance. So far I've created an instance and I have setup the addon using the format: $ heroku addons:add amazon_rds url=mysql://user:[email protected]/databasename After running heroku rake db:migrate I got ...