Changing MySQL Default location?

[disrael]

We are running out of room in /var and we are looking at moving the MySQL DB files and log files to a different location. Would this pose an issue down the road with a Nagios Patch/Upgrade? We are making all changes in the /etc/my.cnf.

-Doron

[slansing]

Well you can certainly offload your database:

http://assets.nagios.com/downloads/nagi ... Server.pdf

You will have to change quite a few more files than just my.cnf because of ndo and web interface access.

[disrael]

I forgot you guys don't have ESP ><

We are looking at putting it in a different location/partition on the same server.

[sreinhardt]

Ah esp, that would be nice!
Probably the easiest way would be to copy the existing files in/var/lib/mysql to tmp or somewhere else, mount the new partition under /var/lib/mysql and copy the existing files onto the new partition. This way you would not need to alter the mysql configs at all and could change drives at a later date again if needed.

edit: Don't forget to stop nagios, ndo2db, and mysql before making the move.

[abrist]

If symlinks are an option, they will most definitely be the easiest way to move the actual location of the tables.

[disrael]

We do have more limited control of the server on the hardware side. We could ask them to add additional space to the /var, though my manager might shoot that down as we do have a lot space in a /u01 partition. I was thinking that just putting it in a different location would be the best idea, I thought about sym links, though I am trying to figure out the best way to do this.

-Doron

[abrist]

Do understand that moving the db to a network share may adversely affect your install if the network storage cannot keep up.