MySQL 3.x or MySQL 4.x ? Which one do you have installed?
Hello to all,
Following a customer complaint we've had, I'd like to ask the WHT community about which MySQL version is broadly supported by web hosts.
We have MySQL 3.23 running on all production servers. No customers had ever complained about not having MySQL 4.x. The reason behind the decision not to upgrade to MySQL 4.x is that it has not achieved a "conflict free" status, as there are problems reported about it the past months.
I know of all the nice features that are implemented on MySQL 4, but since no customer was in need of it, we decided to hold the upgrade until it has been more thoroughly tested and implemented on more than a few hosting providers.
What are your thoughts on this issue? Could you recommend some RELIABLE Internet resources (sites/articles/disscussions/etc.) which prove whether or not MySQL 4 is as reliable as MySQL 3? What are your experiences with running MySQL 4 on production servers?
I'm surprised that you haven't had more complaints about the version. We're running 4.0.X on all our servers as well, you should probably upgrade soon.
█ SHAW NETWORKSSimple. Professional. Reliable. Web Hosting Done Right. █Low Cost & Award-Winning:cPanel Reseller Plans24/7/365 Live Technical Support █ Website:www.shawnetworks.comFast Response E-mail: sales @ shawnetworks.com █Sick of downtime? Fed up with excuses? Drop your host! Switch to Shaw Networks.
Would want to upgrade to 4x because it's upto 3x faster on queries and more secure.
BTW, if you put up a phpinfo () page and it shows 3x it's because it needs to point to the /usr directory (or whatever directory you have mysql installed) to show the current version. In CPanel it'll show 3.23 even if 4x is installed without recompiling php manually and pointing to the mysql directory. Same glitches with the GD library.
Actually we have 3.23.58 installed on the production servers. I am well aware of all the new functionality that comes with 4.x, as I am an application developer. The project I am currently working on has a 4.x backend and I am more happy than using 3.x for developing applications.
But when it comes to running production servers for customer websites, you have to keep in mind of security, stability, reliability, resource usage, performance, etc. Taking only the new features of 4.x into account when deciding whether to upgrade or not, it is likely that I make the wrong decision.
It is within this context that I have posted this thread, which is primarily addressed to web hosting companies/employees. From what you guys have replied, I would opt for keeping the 3.23.58, as there is no credible information that it will not harm server performance, stabilty, etc.
Nothing personal here, it is just an important business decision which needs credible facts to be based upon.
MySQL 4.0 has a query cache that can give a huge speed boost to applications with repetitive queries. See Section 5.11, The MySQL Query Cache.
Version 4.0 further increases the speed of MySQL Server in a number of areas, such as bulk INSERT statements, searching on packed indexes, full-text searching (using FULLTEXT indexes), and COUNT(DISTINCT).