Mysql – Low Overhead Linux Server Install for MySQL

busyboxMySQL

My question is this:

Can anyone suggest a linux server that runs mysql really well with really low overhead (other than Ubuntu)?

And here's why I have this question:

I have a PE1950 III that has given me no end of trouble. This isn't my first PE1950 but it is my newest. I've attempted to install at least 6 different versions of Ubuntu on this server (including 9.10) but I always get the error after the installation completes and I reboot the system.

usb... device not accepting address2... BusyBox

I've tried troubleshooting the issue with limited success. Oddly, I can run any distro of Ubuntu on this box as long as I have ESXI 4 installed first.

But the error message and troubleshooting it are really beside the point now since I'm thinking I'd like to try another distro like Damn Small Linux or something like that.

The only other item that I'll be running on the box is sendmail. I'll probably config iptables as well.

Best Answer

"Really low overhead" is a non-requirement for a database server. As you will be using lots and lots of ram, you don't really care if the OS uses a few megs more (particularly as the page tables for reasonable sized memory typically take up loads more than your kernel on x86 architecture)

Use Centos, you know it will work. Ubuntu or Gentoo other hippy weirdness is great for the odd desktop, but I wouldn't let it near a server.

If you think you need "low overhead" then turn off a few things you don't need. You'll save a few 100kb of RAM, and feel happy (when the page tables take up 1G)

Just whatever you do, don't use a 32-bit OS. Databases do not work on 32-bit OS*, use 64.

* actually they do "work" but cannot use the ram properly on modern hardware, you may as well run it on an old 486 if you have a 32-bit OS.

Related Solutions

Debian MySQL User – What is the debian-sys-maint MySQL User?

What is debian-sys-maint used for?

One major thing it is used for is telling the server to roll the logs. It needs at least the reload and shutdown privilege.

See the file /etc/logrotate.d/mysql-server

It is used by the /etc/init.d/mysql script to get the status of the server. It is used to gracefully shutdown/reload the server.

Here is the quote from the README.Debian

* MYSQL WON'T START OR STOP?:
=============================
You may never ever delete the special mysql user "debian-sys-maint". This user
together with the credentials in /etc/mysql/debian.cnf are used by the init
scripts to stop the server as they would require knowledge of the mysql root
users password else.

What is the easiest way to restore it after I've lost it?

The best plan is to simply not lose it. If you really lose the password, reset it, using another account. If you have lost all admin privileges on the mysql server follow the guides to reset the root password, then repair the debian-sys-maint.

You could use a command like this to build a SQL file that you can use later to recreate the account.

mysqldump --complete-insert --extended-insert=0 -u root -p mysql | grep 'debian-sys-maint' > debian_user.sql

Is the password in /etc/mysql/debian.cnf already hashed

The password is not hashed/encrypted when installed, but new versions of mysql now have a way to encrypt the credentials (see: https://serverfault.com/a/750363).

MySQL Configuration – How to Bind MySQL Server to Multiple IP Addresses

No, there isn't (I just checked 1 hour ago). You can comment the bind-address in my.cnf:

Note: « 1 hour ago » is now more than 10 years ago.

#skip-networking
#bind-address                   = 127.0.0.1

If you want only 2 IPs, you will then have to use a firewall.

For MySql version 8.0.13 and above, you can specify a list of comma-separated IP addresses.

bind-address = 10.0.0.1,10.0.1.1,10.0.2.1

Relevant MySql documentation.

Remember to restart your MySQL instance after changing the config file.

Best Answer

Related Solutions

Debian MySQL User – What is the debian-sys-maint MySQL User?

MySQL Configuration – How to Bind MySQL Server to Multiple IP Addresses

Related Topic