Posted: 24 Aug 2005
Abstract: This document describes how to configure MySQL server to
use the NSS file system on Novell® Open Enterprise Server for Linux.
1. Introduction
The MySQL database server is one of the world's
most popular open source database and is available on OES NetWare and OES Linux
servers.
Novell Open Enterprise Server provides Novell Storage Services™ (NSS) File
System for both Linux and NetWare® kernels. Its many features and capabilities
include visibility, a trustee access control model, multiple simultaneous
namespace support, native Unicode*, user and directory quotas, rich file
attributes, multiple data stream support, event file lists, and a file salvage
subsystem.
This document explains in six simple steps how a MySQL adminstrator or user
can leverage NSS file system available on Novell Open Enterprise Linux Server
(OES Linux server) to store the database.
2. System Requirements
- OES Linux server must be installed with EVMS as the default volume
manager.
- During the installation process of Linux server, select "Novell NSS"
package. This will install NSS on the OES Linux server.
3. Configuring MySQL
- Stop existing MySQL service on the server:
shell> /etc/init.d/mysql stop
- Create an NSS volume using the nssmu utility.
For example, let
the volume name be NSSVOL.
By default, this volume is mounted for use under
/media/nss/NSSVOL
- Edit the file /etc/passwd, and comment
the entry for "mysql" user.
- Create an eDirectory user named "mysql"
shell> namuseradd -x <user_context> -g <primary_groupFDN> mysql
For
example,
shell> namuseradd -x o=testorg -g cn=admingroup,o=testorg mysql
- Create MySQL data directory in NSS volume, assign appropriate
rights. For example,
shell> mkdir /media/nss/NSSVOL/mysql
shell> mkdir /media/nss/NSSVOL/mysql/data
shell> rights -f /media/nss/NSSVOL/mysql -r rwcf trustee mysql.<user_context>.<treename>
where NSSVOL= NSS volume
- Create new privilege tables and start MySQL service.
shell> mysql_install_db --user=mysql --datadir=/media/nss/NSSVOL/mysql/data/
shell> mysqld_safe --user=mysql --datadir=/media/nss/NSSVOL/mysql/data/ &
The MySQL server is now configured to use the NSS file system on Novell Open
Enterprise Linux Server.
|