How to Install MySQL Cluster Software

1. Create user and group on both nodes.
   1. Create the group dba in the global zone and in the local zone.

      phys-schost-1:/ # groupadd -g 200 dba
      phys-schost-2:/ # groupadd -g 200 dba
      phys-schost-1:/ # zlogin zone1 groupadd -g 200 dba
      phys-schost-2:/ # zlogin zone2 groupadd -g 200 dba

   2. Create the user mysql in the global zone and in the local zone.

      phys-schost-1:/ # useradd -u 1000 -g dba -d /export/mysql -s /usr/bin/bash mysql 
      phys-schost-1:/ # zlogin zone1 
      zone1:/ # useradd -u 1000 -g dba -d /export/mysql -s /usr/bin/bash mysql 
      phys-schost-2:/ # useradd -u 1000 -g dba -d /export/mysql -s /usr/bin/bash mysql 
      phys-schost-2:/ # zlogin zone2 
      zone2:/ # useradd -u 1000 -g dba -d /export/mysql -s /usr/bin/bash mysql

2. Install the tar file on both nodes.

   phys-schost-1:/ # mkdir /usr/local
   phys-schost-2:/ # mkdir /usr/local
   phys-schost-1:/ # cd /usr/local
   phys-schost-2:/ # cd /usr/local
   phys-schost-1:/usr/local # /usr/sfw/bin/gtar xzf \
   >/temp/mysql-7.0.7-solaris10-sparc.tar.gz
   phys-schost-2:/usr/local # /usr/sfw/bin/gtar xzf \
   >/temp/mysql-7.0.7-solaris10-sparc.tar.gz
   phys-schost-1:/usr/local # ln -s ./mysql-7.0.7-solaris10-sparc ./mysql
   phys-schost-2:/usr/local # ln -s ./mysql-7.0.7-solaris10-sparc ./mysql

3. Set the ownership.

   phys-schost-1:/usr/local # chown -RL mysql:dba ./mysql
   phys-schost-2:/usr/local # chown -RL mysql:dba ./mysql

Setting Up the MySQL Cluster Control

This section contains the following example procedures:

• How to Configure the Management Server on Both Nodes

• How to Configure the Data Nodes on Both Nodes