Aster Installation and Configuration

Aster Installation and Configuration Steps

  1. If you are upgrading from or reinstalling a previous release, follow the instructions in Upgrading from or Reinstalling a Previous Version before installing the in-database deployment package.
  2. Install the in-database deployment package.

Upgrading from or Reinstalling a Previous Version

Follow these steps to upgrade from or reinstall a previous release.
  1. Log on to the queen node.
    ssh -l root name-or-ip-of-queen-node
  2. Move to the partner directory.
    cd /home/beehive/partner
  3. If a SAS directory exists in the partner directory, enter this command to remove an existing installation from the queen.
    rm -rf SAS
    If you want to perform a clean install, enter these commands to remove the SAS directory from all the workers.
    location=/home/beehive/partner/SAS/
    for ip in `cat /home/beehive/cluster-management/hosts | grep node |
       awk '{print $3}'`; \
    do \
       echo $ip; \
       ssh $ip "rm -r $location"; \
    done
    rm -rf $location;

Installing the In-Database Deployment Package Binary Files for Aster

The in-database deployment package binary files for Aster are contained in a self-extracting archive file named tkindbsrv-9.43-n_lax.sh. n is a number that indicates the latest version of the file. If this is the initial installation, n has a value of 1. Each time you reinstall or upgrade, n is incremented by 1. The self-extracting archive file is located in the SAS-installation-directory/SASTKInDatabaseServer/9.4/AsternClusteronLinuxx64/ directory.
To install the in-database deployment package binary files for Aster, you need root privileges for the queen node. Once you are logged in to the queen node as root, you need to create a directory in which to put tkindbsrv-9.43-n_lax.sh, execute tkindbsrv-9.43-n_lax.sh, and install the SAS_SCORE( ) and the SAS_PUT( ) SQL/MR functions.
Enter these commands to install the SAS System Libraries and the binary files:
  1. Change the directory to the location of the self-extracting archive file.
    cd SAS-installation-directory/SASTKInDatabaseServer/9.4/AsternClusteronLinuxx64/
  2. Log on to the queen node.
    ssh -l root name-or-ip-of-queen-node
  3. Move to the parent of the partner directory.
    cd /home/beehive/
  4. Create a partner directory if it does not already exist.
    mkdir partner
  5. Move to the partner directory.
    cd partner
  6. From the SAS client machine, use Secure File Transfer Protocol (SFTP) to transfer the self-extracting archive file to the partner directory.
    1. Using a method of your choice, start the SFTP client.
      Here is an example of starting SFTP from a command line.
      sftp root@name-or-ip-of-queen-node:/home/beehive/partner
    2. At the SFTP prompt, enter this command to transfer the self-extracting archive file.
      put tkindbsrv-9.43-n_lax.sh
  7. (Optional) If your SFTP client does not copy the executable attribute from the client machine to the server, change the EXECUTE permission on the self-extracting archive file.
    chmod +x  tkindbsrv-9.43-n_lax.sh
  8. Unpack the self-extracting archive file in the partner directory.
    ./tkindbsrv-9.43-n_lax.sh
    Note: You might need to add permissions for execution on this file. If so, do a chmod +x command on this file.
    This installs the SAS Embedded Process on the queen node. When Aster synchronizes the beehive, the files are copied to all the nodes. This can take a long time.
  9. (Optional) There are two methods to copy the files to the nodes right away. You can do either of the following.
    • Run this code to manually move the files across all nodes on the beehive by using secure copy and SSH.
      location=/home/beehive/partner/
      cd $location
      for ip in `cat /home/beehive/cluster-management/hosts | 
         grep node | awk '{print $3}'`; \
      do \ 
      echo $ip; \ 
      scp -r SAS root@$ip":$location"; \ 
      done
    • Run this command to synchronize the beehive and restart the database.
      /home/beehive/bin/utils/primitives/UpgradeNCluster.py -u 
  10. Change to the directory where SAS is installed.
    cd /home/beehive/partner/SAS/SASTKInDatabaseServerForAster/9.43/sasexe
  11. Install the SAS_SCORE( ), SAS_PUT( ), and other SQL/MR functions.
    1. Start the ACT tool.
      /home/beehive/clients/act -U db_superuser -w db_superuser-password
      -d database-to-install-sas_score-into
    2. (Optional) If this is not the first time you have installed the in-database deployment package for Aster, it is recommended that you remove the existing SQL/MR functions before installing the new ones. To do so, enter the following commands.
      \remove sas_score.tk.so
      \remove sas_put.tk.so
      \remove sas_row.tk.so
      \remove sas_partition.tk.so
    3. Enter the following commands to install the new SQL/MR functions. The SQL/MR functions need to be installed under the PUBLIC schema.
      \install sas_score.tk.so
      \install sas_put.tk.so
      \install sas_row.tk.so
      \install sas_partition.tk.so
  12. Exit the ACT tool.
    \q
  13. Verify the existence and current date of the tkast-runInCluster and tkeastrmr.so files. These two binary files are needed by the SAS SQL/MR functions.
    for ip in \
    `cat /home/beehive/cluster-management/hosts | grep node | awk '{print $3}'`; \
       do \
       echo $ip; \
       ssh $ip "ls -al /home/beehive/partner/SAS/SASTKInDatabaseServerForAster/
          9.43/sasexe/tkeastmr.so"; \
       ssh $ip "ls -al /home/beehive/partner/SAS/SASTKInDatabaseServerForAster/
          9.43/utilities/bin/tkast-runInCluster"; \
    done