Choosing a database product

From: Tom Peel (notreallytandp_at_freenet.de)
Date: 11/12/05 

Date: Sat, 12 Nov 2005 19:53:07 +0100

I am planning on developing a web application that should be deployable
on one or more as-yet undetermined hosting services. I'm thinking in
terms of a Linux basis with Apache2, PHP and MySQL, with development on
a FC3 platform. Where I need some advice is whether MySQL is good choice
in terms of having a large choice of web hosting services, or are other
Linux databases more appropriate? What about the MySQL versions, does
it make sense to stick with 3, or go for 4? Ditto PHP version 4 vs 5.

Note I'm not addressing this to a MySQL NG, because I suspect the answer
will be obvious. I also suspect that the FC3 out-of-the-box PHP and
MySQL versions will be ok as regards features and functionality. Any
comments?

TIA

Relevant Pages

  • Re: free database server for desktop application with ado.net driv
    ... > I've used MySQL on Windows since its 3.x days, ... If it works at all on linux, ... people who have problems compiling it post about it because they want their own optimizations. ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: FreeBSD 5.3 MySQL Performance
    ... versions of Linux and FreeBSD for most tests. ... > popular with the ATA disk drive manufacturers. ... > Many companies have used FreeBSD and MySQL for years and years. ... it is not often that you have such a small database and such a large ...
    (freebsd-questions)
  • Re: SMP performance degradation with sysbench
    ... Linux versions on that machine. ... I've reproduced this on a 8-socket/16-way dual core Opteron. ... I am seeing is that MySQL is having trouble putting enough load into the ... seems to be what the clients and server threads use to communicate with. ...
    (Linux-Kernel)
  • Re: Newbie and Debian.
    ... There is no "the Linux equivalent", ... you want to achieve you could use MySQL or PostgreSQL as I said earlier. ... of PostgreSQL and SQL Server. ...
    (alt.os.linux)
  • Re: FreeBSD MySQL still WAY slower than Linux
    ... is that the Mysql folks have agreed to setup ... >tests to profile mysql on identical hardware running FreeBSD and Linux ... I was seeing the same sort of super-smack numbers that everyone's been ...
    (freebsd-stable)