This project has retired. For details please refer to its Attic page.
Apache Trafodion Install
Apache Trafodion

This page describes how to install the Trafodion end-user environment. Refer to the Trafodion Contributor Guide for information how to build the Trafodion source and run the Trafodion developer test environment.

The Trafodion end-user environment is installed using the Trafodion Installer, which operates on Trafodion binaries only. Refer to the Download page for instructions about how you download/create the Trafodion binaries.

Preparation

The Trafodion Installer assumes that you’ve performed the following steps before a Trafodion install:

  1. Cluster Requirements: Ensure that your cluster meets the Trafodion requirements.
  2. Security Requirements: Create the user ID that is used to run the Trafodion Installer. Review and configure LDAP, if desired.
  3. PC Tools: Install software used when installing Trafodion on your PC.
  4. Install Hadoop: Install Hadoop software supported by Trafodion.
  5. Validate Hadoop: Validate that required Hadoop services are running.

Please refer to Install Preparation for information about how to perform the steps above.

Security Considerations

You use the following user IDs and passwords during the Trafodion installation.

Logon User ID Password Description
Cloudera Manager Web GUI logon admin (default) admin (default) Cloudera only. After installing Cloudera, you will be instructed to log on to the Cloudera Manager Web GUI. Use the default user ID and password (admin, admin). If you already had Cloudera installed, please use your previously defined user ID and password.
Ambari Web GUI logon admin (default) admin (default) Hortonworks only. After downloading and setting up the Ambari repository, you will be instructed to log on to the Ambari Web GUI. Use the default user ID and password (admin, admin). If you already had Ambari installed, please use your previously defined user ID and password.
User ID with sudo Access <sudo-username> <password> In the installation steps, you may be instructed to use sudo or sudo userid access. You will be using your user ID, which has been enabled with sudo access and passwordless ssh to all nodes of the cluster.
Trafodion Logon trafodion traf123 (default) The Trafodion installer automatically creates this user ID when Trafodion is installed. Do not create this user ID manually.
VNC Server Logon trafodion traf123 (default) After installing Trafodion, you will be instructed to log on to the VNC server at port 1. Use the trafodion user ID and password.

Install Procedure

Upgrade

Follow these steps if you have an older version of Trafodion that you want to upgrade:

  1. Shutdown Trafodion: Please refer to Manage Trafodion.
  2. Backup Data: Backup metadata and user objects. Please refer to Backup/Restore.

  3. Install Trafodion: The trafodion_install script automatically detects the previous version of Trafodion and performs an upgrade operation, including initializing Trafodion, upgrading the metadata, and restarting all processes. Please refer to Installation below for more information about trafodion_install.

    If something goes wrong during the installation, restore your data from the backed up objects and repeat the previous step.

NOTE

If you are doing an upgrade outside of the installation environment, then you will need to restart your services and processes, such as sqlci, the DCS server, and the qms servers. If you do not restart those services and processes, your system will not work properly.

Installation

At a high level, the following instructions consist of a single step:

Command User ID Comments
trafodion_install <sudo-username> Installs necessary RPMs, creates the trafodion user ID, sets up passwordless ssh for the trafodion user ID, copies the Trafodion distribution files across the cluster, generates startup files, and starts Trafodion, including Database Connectivity Services (DCS) (the ODBC/JDBC server), among other things.
IMPORTANT

The Trafodion commands should all be done from the first node of the cluster. Do not run them from a machine that is not part of the Trafodion cluster. Trafodion must be installed on all nodes that host an HBase RegionServer (that is, where a supported Hadoop distribution is installed).

For example, if Cloudera or Hortonworks is installed on nodes n001, n002, and n003, then you must install Trafodion on those same nodes (--nodes "n001 n002 n003").
Step Description Commands
Download If you haven't done so already, then please download the Trafodion software. Please refer to Download.
Upgrade

If you are upgrading to a newer version of Trafodion, copy the installation files for the previous version to a directory outside of $HOME/trafodion_downloads.

For example:

mkdir $HOME/trafodion_downloads_v1.0
 
cp –r $HOME/trafodion_downloads/* $HOME/trafodion_downloads_v1.0
rm –rf $HOME/trafodion_downloads/*
Create trafodion_downloads Create the trafodion_downloads directory if you have not done so already and place the downloaded trafodion-1.1.<n>.tar.gz and installer-1.1.<n>_v<num>.tar.gz tar files into it. 
mkdir $HOME/trafodion_downloads
mv <your-download-path>/trafodion-1.1.<n>.tar.gz $HOME/trafodion_downloads
mv <your-download-path>/installer-1.1.<n>_v<num>.tar.gz $HOME/trafodion_downloads
cd $HOME/trafodion_downloads
Unpack tar File Untar the downloaded installer file. 
tar -xzf installer-1.1.<n>_v<num>.tar.gz
Run trafodion_install

The scripts is run without parameters. Instead, you'll be prompted for information.

NOTE

The trafodion_install script automatically checks the cluster for attributes that commonly cause installation issues, runtime performance problems, and so on. Also, various system information is collected for future reference, such as to aid with troubleshooting. The installation will abort if any configuration errors are discovered. You will need to correct such errors before re-running the trafodion_install script.

 
cd installer
./trafodion_install

Type "accept" to accept the license agreement when prompted.

Provide the requested information according to the prompts.

NOTE

If you choose not to start Trafodion after the installation (that is, if you enter N for Start Trafodion after install (Y/N)), you will need to manually start and initialize Trafodion after trafodion_install completes.
trafodion_install Completion Wait for trafodion_install to complete.

You will see the following message:

***INFO: Installation completed successfully.
Connect Once trafodion_install completes without error, your Trafodion system should be up and running.

Start a new VNC session using port :1.

Log in as the trafodion user with the password for the VNC, which is traf123 by default unless you changed it.

Start and Initialize

If you chose not to start Trafodion after the installation, start and initialize Trafodion as follows:

cds
sqstart

[trafodion@n001 ~]$ sqlci
Trafodion Conversational Interface 1.1.0
(c) Copyright 2015 Apache Software Foundation
>>initialize trafodion ;
.
.
.

Validate Installation

Perform a quick sanity check using the Trafodion Conversational Interface (sqlci). Create a table with a couple of records.

Example

[trafodion@n001 ~]$ sqlci
Trafodion Conversational Interface 1.1.0
(c) Copyright 2015 Apache Software Foundation
>> create table test1 (f1 int, f2 int);

--- SQL operation complete.
>> insert into test1 values(1,1);

--- 1 row(s) inserted.
>> insert into test1 values(2,2);

--- 1 row(s) inserted.
>> select * from test1;

F1            F2
-----------   -----------
          1             1
          2             2

--- 2 row(s) selected.
>> get tables;

Tables in Schema TRAFODION.SEABASE
==================================

TEST1

--- SQL operation complete.
>> drop table test1;
>> exit;

The SQL commands above should run successfully.

Install Client Software

Download and install the Trafodion JDBC and/or ODBC drivers on your client workstation to be able to connect to Trafodion from a client application. Please refer to the Trafodion Client Installation Guide, which describes how to install the JDBC and ODBC drivers, how to connect to Trafodion, and how to run sample programs to test the connection.

Troubleshooting

Please refer to Troubleshoot Trafodion Installation.

Uninstall

Please refer to Unistall Trafodion.

Back to top

Copyright ©2015-2016 Apache Software Foundation. All Rights Reserved.

Disclaimer: Apache Trafodion is an effort undergoing incubation at the Apache Software Foundation (ASF), sponsored by the Apache Incubator PMC. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.

Apache, Apache Maven, Apache Maven Fluido Skin, the Apache feather logo, the Apache Maven project logo and the Apache Incubator project logo are trademarks of The Apache Software Foundation.