阅读背景:

是否可以将云计算和MYSQL结合起来?

来源:互联网 

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

Web服务器的主瓶颈通常位于数据库中,在我的例子中是MYSQL。

More specifically,fulltext search and master-slave replication.

更具体地说,全文搜索和主从复制。

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

而sphinx是全文搜索的可能解决方案,因此主从复制就是

final pain in ass.

屁股最后的痛苦。

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

使用Cloud Coumputing技术可以显着提升性能,

for instance,by services offered by Amazon?

例如,通过亚马逊提供的服务?

Just a wild guess!

只是猜测!

EDIT:what about MySQL and Google App Engine?

编辑:MySQL和Google App Engine怎么样?

3 个解决方案

#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.

当然。适用于Amazon EC2的MySQL Enterprise是Amazon EC2的一个MySQL包。另请参阅在EC2 AMI上设置MySQL以及本教程/博客文章。

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.

编辑:App Engine比EC2更高级别,并且仅适用于BigTable / GQL。但是,请查看approcket,它允许在AppEngine和MySQL之间进行复制。

#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.

您可能需要小心只需将Web应用程序切换为使用外部数据库(例如amazon,et.al。),您想要了解您的瓶颈究竟在哪里,或者您最终可能会引入更多性能问题...记住通过转到外部数据库,与本地(盒子或网络)查询相比,您在每个查询中引入了更多延迟。

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.

如果您的问题是性能问题,请尝试找出问题的确切位置,然后您可能希望探索其他选项,如查询优化,缓存等。

#3


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.

可能 - 当然。例如,参见xeround,rightscale,Amazon和phpfog。可能至少还会有更多的未来。它们有不同程度的“自由度”(对于一个组成单词来说,这是怎么回事?)。

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

在我看来,问题在于性能和可靠性。

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

谁知道,localhost可能会成为过去发展的事情。


分享到: