89524

SQL nodes. On each of the machines designated to host SQL nodes, perform the

following steps

as the system root user:

1.    Check your /etc/passwdand /etc/group files (or use whatever tools are provided by your

operating system for managing users and groups) to see whether there is already a mysąlgroup

and mysqluser on the system. Some OS distributions create these as part of the operating system

installation process. If they are not already present, create a newmysąluser group, and then add

a mysąluser to this group:

3hel l>groupaddrry sql

shel 1> user add -g mysqlrrysql

The syntax for useraddand groupaddmay differ slightly on different versions of Unix, or they

may have different names such as adduserand addgroup.

2.    Change location to the directory containing the downloaded file, unpack the archive, and create a

symbolic link named mysqlto the mysqldirectory. Notę that the actual file and directory names

vary according to the MySOL Cluster version number.

shell>cd /var/tmp

3hell>tar -C /usr/local -xzvf nysql-cluster-gpl-7.3.3-linux2.6.tar.gz 3hell>ln -* /usr/local/mysql-cluster-gpl-7.3.3-linux2.6-i686 /usr/local/mysql

3.    Change location to the mysqldirectory and run the supplied scriptfor creating the system

databases:

3hell>cd mysql

3hell>scripts/rrysql_install_db --user=rrysql

4.    Set the necessary permissions for the MySOL server and data directories:

shell>chown -R root .

3hell>chown -R mysql data shell>chgrp -R mysql .

5.    Copy the MySOL startup scriptto the appropriate directory, make it executable, and set it to start

when the operating system is booted up:

shell>cp support-files/mysql.server /otc/rc.d/init.d/

3hell>chmod +x /etc/rc.d/init.d/mysql. server shell>chkconfig —add mysql.server

(The startup Scripts directory may vary depending on your operating system and version—for

example, in some Linux distributions, it is /etc/init .d.)

Here we use Red Hat's chkconf igfor creating links to the startup Scripts; use whatever means is

appropriate for this purpose on your platform, such as update-rc.don Debian. Remember that the preceding steps must be repeated on each machinę where an SQL node is to reside.