Aster Installation and Configuration

Aster Installation and Configuration Steps

Upgrading from or Reinstalling a Previous Version

Installing the In-Database Deployment Package Binary Files for Aster

Aster Installation and Configuration Steps

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.
Install the in-database deployment package.

For more information, see Installing the In-Database Deployment Package Binary Files for Aster.

Upgrading from or Reinstalling a Previous Version

Follow these steps to upgrade from or reinstall a previous release.

Log on to the queen node.
```
ssh -l root name-or-ip-of-queen-node
```
Move to the partner directory.
```
cd /home/beehive/partner
```
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:

Change the directory to the location of the self-extracting archive file.
```
cd SAS-installation-directory/SASTKInDatabaseServer/9.4/AsternClusteronLinuxx64/
```
Log on to the queen node.
```
ssh -l root name-or-ip-of-queen-node
```
Move to the parent of the partner directory.
```
cd /home/beehive/
```
Create a partner directory if it does not already exist.
```
mkdir partner
```
Move to the partner directory.
```
cd partner
```
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
(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
```
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.
(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
Change to the directory where SAS is installed.
```
cd /home/beehive/partner/SAS/SASTKInDatabaseServerForAster/9.43/sasexe
```
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
Exit the ACT tool.
```
\q
```

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