Cloud Databases

[gemma-the-husky]

Anyone any experience of these.

I decided to have a try, and signed up to a 60 day free trial with Amazon RDS



I have a very small database just in developement which was convenient to use - about 16 tables, but probably fewer that 100 records in all these added together.


I upsized to MySql locally.


I created a database area in Amazon, and then transferred the local SQL copy to the Amazon


finally i connected my front end to the Amazon back end. A few uncertainties on the way (including for some reason that ODBC links created through control panel are different from those created through Access - and that the latter cannot be deleted - or can they?)


Anyway, having done all this relatively easily, I was then very disappointed with the performance.

A simple form with a handful of records took seconds to populate. my internet isn't the fastest, but it was painful.


Is this the general experience, or ma I doing something wrong?

 

[mdlueck]

I upsized to MySql locally.

How is the performance connecting to MySQL locally?

 

[gemma-the-husky]

on my own system, mysql is not on a server, it's just on my development pc for test purposes (with heidi as a sql manager), so no problems at all.

thinking about it again, i was testing on a wireless pc, rather than wired, so that may have reduced the performance a bit as well.

I am going to try a faster network to see if that helps

 

[Galaxiom]

Wireless (N) networks run at up to 150Mbps so it is unlikely to be anything to do with that. The latency will be the internet and/or the performance of the host.

Cloud is far more about hype than practicality. The promotion is all aimed at managers who are wooed by the promises of lower costs. Meanwhile the staff that actually work with it are confronted by the realities of bandwidth limitations.