快速MySQL 5渗透调查

In a previous post about the MySQL triggers, I mentioned that inexpensive web hosts are now offering MySQL 5. This was based on ICDsoft's hosting plan, this is a (highly recommended, awesome support!) company I've been using for years and I was thinking that it represents the avegarge $50-60/year web hosting solutions offered worldwide, which is what most people use when they start a web site.

在先前有关MySQL触发器的帖子中，我提到廉价的Web主机现在正在提供MySQL5 。这是基于ICDsoft的托管计划的，这是我多年来一直在使用的(强烈建议，提供出色的支持！)公司。我当时以为这代表着全世界每年平均提供50-60美元的网络托管解决方案，这是大多数人在启动网站时所使用的解决方案。

I decided to do a quick check what is the status of the MySQL 5 penetration today. Turns out, not so bright. Here are the results:

我决定快速检查一下今天MySQL 5渗透的状态是什么。 事实证明，不是那么明亮。 结果如下：

• bluehost - 4
  bluehost-4
• hostgator - 4
  hostgator-4

• lunarpages - 5

  月球-5

• ipowerweb - 4, on demand 5

  ipowerweb-4，按需5

• anhosting - 4
  托管-4
• hostmonster - 4
  主机怪物-4
• ixwebhosting - 4
  ixwebhosting-4
• startlogic - 4
  startlogic-4
• powweb - 4
  powweb-4

• dreamhost - "slowly upgrading" to 5

  dreamhost-“缓慢升级”到5

• site5 - 4, no specific plans for a 5 date
  site5-4，5天没有具体计划
• yahoo - 4
  雅虎-4
• laughingsquid - 4
  乌贼-4

How was the survey conducted? Googling I found webhostingjury.com, than this webhostingjungle.com review site, and I checked the top ten hosts, all of them happened to be less than $10 a month. Then I added those that I know - site5 and dreamhost and finally those that are listed on wordpress.org/hosting. I can only hope that most hosts don't update their FAQ pages, but they do update their MySQL.

调查如何进行？ 谷歌搜索，我找到的是webhostingjury.com ，而不是这个webhostingjungle.com的评论网站，我检查了排名前十位的主机，所有这些主机每月的费用都不到10美元。 然后我添加了我知道的站点5和dreamhost ，最后添加了在wordpress.org/hosting上列出的那些。 我只能希望大多数主机不更新其FAQ页面，但可以更新MySQL。

Interesting reads while doing the survey:

进行调查时有趣的读物：

• "We will upgrade ... when cPanel upgrades" (source). I sent an email to cPanel® support to ask for their plans, waiting.

  “我们将在cPanel升级时进行升级...”(源)。 我发送了一封电子邮件给cPanel®支持人员，要求他们等待计划。

• "We strongly recommend that you use the MySQL 5 database engine for your applications... better supported ... more features" (ICDSoft's support)

  “我们强烈建议您为应用程序使用MySQL 5数据库引擎...更好的支持...更多的功能”( ICDSoft的支持)

• "upgrade could cause some breakage of your application" (Dreamhost's wiki)

  “升级可能会导致您的应用程序损坏”( Dreamhost的Wiki )

I guess that last one explains it best. Basically the same as what happened with hosts unwilling to upgrade to PHP5, because some older and popular free apps would be broken. I hope more hosts start offering both 4 and 5, like ICDSoft do, as a transition. And maybe the break-through will be when cPanel® upgrades, since this is probably what most hosts are using.

我想最后一个最好的解释了。 基本上与不愿升级到PHP5的主机的情况相同，因为某些较旧且流行的免费应用程序将被破坏。 我希望更多的主机像ICDSoft一样开始提供4和5作为过渡。 突破可能是在cPanel®升级时，因为这可能是大多数主机所使用的。

Anyway, the good news is that if you want good and cheap web host with MySQL 5 support, you have options, however limited.

无论如何，好消息是，如果您希望获得价格低廉且具有MySQL 5支持的Web主机，则可以选择，但有很多限制。

Update: I got a promising response from cPanel® support:

更新：我得到了cPanel®支持的有希望的回应：

cPanel and WHM already supports MySQL 5 and in fact we recommend it for all new installations of our product.

cPanel和WHM已经支持MySQL 5，实际上我们建议在产品的所有新安装中使用它。

However, the problem with MySQL 5 and why most web hosting companies hesitate to implement it has to do with PHP Scripts. Many PHP scripts have a habit of breaking under MySQL 5 and rather than having many angry customers, they'd rather stick with MySQL 4.1.

但是，MySQL 5的问题以及大多数网络托管公司为何不愿实施它与PHP脚本有关。 许多PHP脚本都有打破MySQL 5的习惯，而不是拥有许多生气的客户，他们宁愿坚持使用MySQL 4.1。

Tell your friends about this post on Facebook and Twitter

在Facebook和Twitter上告诉您的朋友有关此帖子的信息

翻译自: https://www.phpied.com/quick-mysql-5-penetration-survey/