Light Linux server for MySQL

[VinylxScratches]

What would be the best distro to use as a MySQL server? It will be in a virtual machine running under Windows XP.

 

[Crusty]

I prefer Debian for servers, or at least one of Ubuntu's LTS releases. During the install process you can simply select to install mysql server and once you boot up you'll be up and running. If you want a full LAMP stack you can simply run 'apt-get install phpmyadmin' as root and that will install all packages you need.

 

[Brazen]

Originally posted by: Crusty
I prefer Debian for servers, or at least one of Ubuntu's LTS releases. During the install process you can simply select to install mysql server and once you boot up you'll be up and running. If you want a full LAMP stack you can simply run 'apt-get install phpmyadmin' as root and that will install all packages you need.

I prefer Ubuntu Server LTS. Ubuntu Server tunes the kernel for server applications, as opposed to desktop gui applications, and they strip out just about everything but the bare essentials to keep the storage, processor, and ram overhead to a minimum.

 

[n0cmonkey]

I generally use Centos.

 

[Nothinman]

I prefer Ubuntu Server LTS. Ubuntu Server tunes the kernel for server applications, as opposed to desktop gui applications, and they strip out just about everything but the bare essentials to keep the storage, processor, and ram overhead to a minimum.

I don't have an Ubuntu installation handy to check but I can't believe they do any more than build everything as a module like every other distribution.

 

[Brazen]

Originally posted by: Nothinman

I prefer Ubuntu Server LTS. Ubuntu Server tunes the kernel for server applications, as opposed to desktop gui applications, and they strip out just about everything but the bare essentials to keep the storage, processor, and ram overhead to a minimum.

I don't have an Ubuntu installation handy to check but I can't believe they do any more than build everything as a module like every other distribution.

they do.

 

[Nothinman]

they do.

Like?

 

[Brazen]

high level overview of differences:
https://help.ubuntu.com/commun...esktop%20and%20server?


Details on what the kernel differences mean:
http://www.enterprisenetworkin...os/article.php/3710641

 

[Crusty]

Debian turns off preempting, uses cfq for it's default I/O scheduler(but has all others available with a kernel parameter), and doesn't change the interrupt hz from 250.

That's not much of a difference between Debian's kernel and Ubuntu's 'server' kernel, and honestly I'm sure in order to figure out what's best for your server you'll need to run benchmarks and change settings yourself.

 

[Nothinman]

According to http://www.ubuntu.com/products...dition/features/kernel the changes are pretty minor. DKMS and maybe the deadline I/O schedular are probably the only things that people might actually notice.

 

[Scarpozzi]

CentOS is usually pretty safe for server applications because it's easy to find RedHat/CentOS applications. I'm a huge fan of yum too and it's standard on CentOS 5/RHEL5.

 

[Nothinman]

Working with CentOS/yum is pretty frustrating after you get used to Debian/apt.

 

[n0cmonkey]

Originally posted by: Nothinman
Working with CentOS/yum is pretty frustrating after you get used to Debian/apt.

meh

6 of one, half dozen of the other.

 

[Nothinman]

6 of one, half dozen of the other.

If only that were true. Yum is annoyingly slow cause it's all python and the repositories for CentOS are miniscule compared to what's available for Debian and Ubuntu.