I am building a "data warehouse" right now, a server with eleven 2TB
hard drives in a RAID 6 configuration.

I will have a few tables, one the largest and a few smaller ones.

This data warehouse will be ONLY used for batch queries, with no real
time access (like from websites) allowed, by design.

My question is, what do you think about MySQL 5.1.41, stock mysql
from Ubuntu Lucid 10.04?

Is there anything in the later versions that I would need?

thanks

i

On 03-09-2011 18:52, Ignoramus19057 wrote:
If you are only doing queries, than it should be fine....

Why are you involving the OS in this descicion? Ubuntu has NOTHING to do
with MySQL.

If you are building it right now, i would choose the latest stable
version (5.5.15).

There is not enough info, but if you are only doing queries, (and not
updates) than any version of MySQL should do OK.


--
Luuk

Luuk wrote:
Ubuntu scores as a desktop because it has more media stuff. Debian is
the stable base..

On 04-09-2011 21:02, The Natural Philosopher wrote:
http://www.ubuntu.com/business/server/overview



--
Luuk

Ubuntu server is a generally great product.

This is what I tried to install on this data warehouse.

Unfortunately, it does not support the 3Ware 9750 RAID card, and all
hard drives MUST be connected to it.

So, I had to install CentOS 6.0, which works great.

i

On 2011-09-04, Luuk <Luuk (AT) invalid (DOT) lan> wrote: