hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Web Hosting : MySQL 3.x or MySQL 4.x ? Which one do you have installed?
Reply

Forum Jump

MySQL 3.x or MySQL 4.x ? Which one do you have installed?

Reply Post New Thread In Web Hosting Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 03-24-2005, 12:51 PM
artzweb artzweb is offline
WHT Addict
 
Join Date: Nov 2004
Location: London UK - Athens Greece
Posts: 102

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?

Thanks in advance for your replies.

Reply With Quote


Sponsored Links
  #2  
Old 03-24-2005, 12:52 PM
drhamad@t0host drhamad@t0host is offline
Web Hosting Guru
 
Join Date: Dec 2004
Location: Southbury, CT
Posts: 278
We run 4, haven't had any problems. But then, I have little to no experience with 3, so can't do much of a comparison.

__________________
TrapZero Hosting
Web, Forum, E-mail hosting and more for business and personal users. Accepting PayPal.

FMVperformance Automotive Communities

Reply With Quote
  #3  
Old 03-24-2005, 01:19 PM
ereloaded ereloaded is offline
Disabled
 
Join Date: Mar 2005
Posts: 6
Quote:
Originally posted by drhamad@t0host
We run 4, haven't had any problems. But then, I have little to no experience with 3, so can't do much of a comparison.
I also have MySQL 4. I have no experience with 3.
Try searching google, there should be couple of websites that compare the two.

Reply With Quote
Sponsored Links
  #4  
Old 03-24-2005, 01:21 PM
MTSpace at WHT MTSpace at WHT is offline
Disabled
 
Join Date: Jan 2005
Location: Milton Keynes, UK
Posts: 255
4.1.10a here - lovely with PHP 5.0.3

Reply With Quote
  #5  
Old 03-24-2005, 01:23 PM
artzweb artzweb is offline
WHT Addict
 
Join Date: Nov 2004
Location: London UK - Athens Greece
Posts: 102
Quote:
Originally posted by ereloaded
Try searching google, there should be couple of websites that compare the two.
I have been searching around for specific information on this issue with no luck unfortunately. That is why I opted for asking the WHT community.

Anyone who could point me to some credible information/resources ?

Reply With Quote
  #6  
Old 03-24-2005, 02:01 PM
RRWH RRWH is offline
Web Hosting Master
 
Join Date: Mar 2005
Location: Ten1/0/2
Posts: 2,306
Last time I needed to find out about MySQL I went to their website.....

And Yes, Version 4.0.x has not given me any problems running a busy phpBB forum

If you specifically don't need the features and your customers are not asking, then as long as you have the latest 3.23.x (55?) then you should be just fine.

__________________
CPanel Shared and Reseller Hosting, OpenVZ VPS Hosting. West Coast (LA) Servers and Nodes
Running Linux since 1.0.8 Kernel!
Providing Internet Services since 1995 and Hosting Since 2004


Reply With Quote
  #7  
Old 03-24-2005, 04:58 PM
offshores offshores is offline
New Member
 
Join Date: Mar 2005
Posts: 4
I personally have mySql 3

Reply With Quote
  #8  
Old 03-24-2005, 05:12 PM
LP-Trel LP-Trel is offline
Web Hosting Master
 
Join Date: Jul 2003
Location: Nothing but, net
Posts: 2,062
MySQL 4.1.10a with PHP4 and PHP5 here.

I love the MySQLi interface in PHP5.

Reply With Quote
  #9  
Old 03-24-2005, 05:52 PM
Captian_Spike Captian_Spike is offline
Web Hosting Master
 
Join Date: Nov 2003
Location: Canada
Posts: 881
I've used a few different versions. Haven't had trouble with any of them yet. I also haven't noticed any performance advantages in any version, although I haven't done any real testing.

Reply With Quote
  #10  
Old 03-24-2005, 08:09 PM
JTY JTY is offline
Community Guide
 
Join Date: Jun 2000
Location: Washington, USA
Posts: 5,991
Running 4.0.X on production servers, not a single problem.

Reply With Quote
  #11  
Old 03-24-2005, 08:22 PM
Shaw Networks Shaw Networks is offline
Hosting Specialist
 
Join Date: Sep 2003
Location: Washington, USA
Posts: 3,219
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 NETWORKS›› Simple. Professional. Reliable. Web Hosting Done Right.
Low Cost & Award-Winning: cPanel Reseller Plans ›› 24/7/365 Live Technical Support ‹‹
Website: www.shawnetworks.com Fast Response E-mail: sales @ shawnetworks.com
Sick of downtime? Fed up with excuses? Drop your host! Switch to Shaw Networks.

Reply With Quote
  #12  
Old 03-24-2005, 09:07 PM
ChrisLM2001a ChrisLM2001a is offline
Web Hosting Master
 
Join Date: Nov 2001
Location: USA
Posts: 584
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.

Chris

Reply With Quote
  #13  
Old 03-24-2005, 09:31 PM
artzweb artzweb is offline
WHT Addict
 
Join Date: Nov 2004
Location: London UK - Athens Greece
Posts: 102
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.


Last edited by artzweb; 03-24-2005 at 09:35 PM.
Reply With Quote
  #14  
Old 03-24-2005, 10:16 PM
ChrisLM2001a ChrisLM2001a is offline
Web Hosting Master
 
Join Date: Nov 2001
Location: USA
Posts: 584
Read the entire online manual from the source to see it's not fluff, but facts....

http://dev.mysql.com/doc/mysql/en/nu...-features.html
Speed enhancements

An even more detailed list...

http://dev.mysql.com/doc/mysql/en/news-4-0-x.html

Quote:
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).
Speed...
http://dev.mysql.com/doc/mysql/en/query-cache.html

Security...

http://dev.mysql.com/doc/mysql/en/grant.html

With Mysql 4.1 here and 5.0 is being worked on, 3.23 is getting long on the tooth now. Just the fact it's less secure is a reason to upgrade.

Chris

Reply With Quote
  #15  
Old 03-24-2005, 10:57 PM
Archbob Archbob is offline
Web Hosting Master
 
Join Date: Sep 2001
Posts: 755
I will probably upgrade to mysql 4.1 sometime soon.

Reply With Quote
Reply

Related posts from TheWhir.com
Title Type Date Posted
Tesora's OpenStack DBaaS Supports MongoDB, Cassandra, Redis, and MySQL Web Hosting News 2014-05-23 14:53:11
Google Releases Hosted Database Service Cloud SQL to General Availability Web Hosting News 2014-02-12 13:46:02
Google Cloud Provides Support For Native MySQL Connections Web Hosting News 2013-11-01 14:36:06
PHP And MySQL Scaling: Preparing A Startup For Growth Blog 2014-04-24 13:27:35
Web Host SingleHop Launches Automated Security Service for Dedicated, Cloud Servers Web Hosting News 2013-01-07 14:20:53


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?