4 ms·
Could anyone comment on the feasibility and speed of using this service as a database for a non-EC2 dedicated box?
by fuzzmeister 18y ago
Could anyone comment on the feasibility and speed of using this service as a database for a non-EC2 dedicated box?
- bk 18y agoI guess it would be the standard constraints for anything over a network, particularly a WAN: latency and throughput. If you have a lot of small queries latency might kill you, and if you have large result sets throughput might kill you. (Also, I don't know how safe the mysql connection is outside a firewalled LAN. Maybe that's not an issue.)
- lecha 18y agoTake a look at http://blog.rightscale.com/2007/11/13/mysql-performance-on-amazon-ec2/ http://blog.rightscale.com/2007/11/13/mysql-performance-on-a... - RightScale Blog MySQL performance on Amazon EC2
- modoc 18y agoThat will depend greatly on how you use your database (number of queries over time, type of queries, size of returned data, etc...). I worked on a large DB intensive eCommerce site, with a large number of writes and un-cachable data. While it worked great locally, trying to point a cluster at the DB in the backup data center (50 ms away on a dedicated backbone line) absolutely killed performance. Also, for another eCommerce site, the local dev instance on my laptop boots in about ~ 1 minute when running against a local database. It takes about ~10 minutes when running against the corporate dev db over the VPN connection (~50ms added latency). However, for an application with more cacheable data, and less queries per second, it would matter less.