CODEWITHSUNDEEP
mysqlcloud
omg
omg

Reputation: 139862

Is it possible to combine Cloud Computing and MYSQL?

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?

Upvotes: 2

Views: 582

Answers (3)

Tac
Tac

Reputation: 177

Possible - for sure. See for example, xeround, rightscale, Amazon and phpfog. There are probably at least a few more with more to come. They come in varying degrees of "freeness" (How's that for a made up word?) too.

The question, it seems to me, will be performance and reliability.

Who knows, localhost may become a thing of the past for development.

Upvotes: 0

Jaime
Jaime

Reputation: 6814

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.

Upvotes: 1

Matthew Flaschen
Matthew Flaschen

Reputation: 284796

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.

Upvotes: 4

Related Questions