Is it possible to combine Cloud Computing and MYSQL?

Question

The main bottle neck of a web server locates usually in the database,in my case,MYSQL.

More specifically,fulltext search and master-slave replication.

And sphinx is a probable solution for fulltext-search,so master-slave replication is the

final pain in ass.

Is it possible to boost the performance significantly with the technology of Cloud Coumputing,

for instance,by services offered by Amazon?

Just a wild guess!

EDIT:what about MySQL and Google App Engine?

Answer 1

Of course. MySQL Enterprise for Amazon EC2 is one MySQL package for Amazon EC2. See also Setting Up MySQL on an EC2 AMI and this tutorial/blog post.

EDIT: App Engine is higher-level than EC2 and is really designed for BigTable/GQL only. However, look at approcket, which allows replicating between AppEngine and MySQL.

Answer 2

You may want to be careful with just switching your web app to use an external data base (ie amazon, et.al.), you want to understand where exactly is your bottleneck or you may end up introducing more performance problems... Remember that by going to an external DB, you're introducing more latency into each query compared to a local (box or net) query.

If your problem is performance, try to find out exactly where the problem lies first, and then you may want to explore other options like query optimization, caching, etc.