Trafodion 安装教程

环境

• 操作系统：CentOS release 6.7 (Final)
• Hadoop版本：CDH 5.4.8
• 节点数：2
• 单节点内存：8G

安装包

• Trafodion 服务器安装包
• Trafodion 客户端安装包

• Trafodion 安装程序包
  下载链接： http://trafodion.incubator.apache.org/download.html

  

安装步骤

• 环境检查

  • Hadoop是否正常运行(CDH Manager or Ambari)
  • SSH 免密码是否配置
  • hostname是否配置(/etc/hosts)
  • JDK 1.7或更高版本
  • root权限或具有sudo权限的用户
  • 防火墙是否关闭(service iptables stop)
  • SeLinux是否disabled(setenforce 0)
  • ntp服务是否开启(service ntpd start)

• 开始安装

  • 解压installer-2.0.1.tar.gz

    [root@cent-1 opt]# tar -xzvf installer-2.0.1.tar.gz
    [root@cent-1 opt]# cd installer
    [root@cent-1 installer]# ls
    acceptKeys       DISCLAIMER         setup_known_hosts.exp  traf_authentication_conf_default  traf_createPasswordLessSSH  trafodion_install      traf_sqconfig
    bashrc_default   LICENSE            setup_ssh_key          traf_cloudera_mods                traf_getHadoopNodes         trafodion_license      traf_sqgen
    checkHBase       NOTICE             traf_add_sudoAccess    traf_config                       traf_getMultiHadoopNodes    trafodion_uninstaller  traf_start
    cloud_cli_setup  parseHBaseSite.py  traf_add_user          traf_config_check                 traf_hortonworks_mods       traf_package_setup     traf_user_prompt
    dcs_installer    rest_installer     traf_apache_mods       traf_config_setup                 trafodion_config_default    traf_setup             traf_user_prompt_check

  • 开始安装
    以下安装步骤可以总结为：
    （1）判断是否为云平台，默认为”否”
    （2）配置trafodion用户的密码，默认为”traf123”
    （3）判断是否有NameNode HA，默认为”否”
    （4）配置trafodion用户的home目录，默认为”/home”
    （5）配置JDK路径
    （6）配置trafodion数据库安装包(通过官网下载的Server部分)
    （7）配置用于备份/恢复的用户，默认为”trafodion”
    （8）选择Hadoop平台的版本(CDH /HDP / Apache，CDH与HDP兼容较好)
    （9）配置Hadoop admin的用户及密码，默认为admin/admin
    （10）配置Hadoop Web UI路径，CDH为ip:7180，HDP为ip:8080
    （11）配置HDFS/HBase/Zookeeper等用户
    （12）配置trafodion安装路径
    （13）安装完trafodion选择是否启动数据库
    （14）配置dcs最大连接数，即决定最多有多少个并发用户可同时连接trafodion
    （15）配置dcsMaster所在的机器ip
    （16）配置是否启用LDAP，LDAP结合trafodion可实现基于角色的权限管理

    [root@cent-1 installer]# ./trafodion_install
    
    ******************************
     TRAFODION INSTALLATION START
    ******************************
    
    ***INFO: testing sudo access
    ***INFO: Log file located at /var/log/trafodion/trafodion_install_2016-12-12-11-48-59.log
    ***INFO: Config directory: /etc/trafodion
    ***INFO: Working directory: /usr/lib/trafodion
    
    ************************************
     Trafodion Configuration File Setup
    ************************************
    
    ***INFO: Please press [Enter] to select defaults.
    
    Is this a cloud environment (Y/N), default is [N]: N
    Enter trafodion password, default is [traf123]:
    Enter list of data nodes (blank separated), default []: cent-1.novalocal cent-2.novalocal
    Do you have a set of management nodes (Y/N), default is N:
    Enter Trafodion userid's home directory prefix, default is [/home]:
    Specify location of Java 1.7.0_65 or higher (JDK), default is []: /usr/java/jdk1.7.0_67-cloudera
    Enter full path (including .tar or .tar.gz) of trafodion tar file []: /opt/apache-trafodion_server-2.0.1-incubating.tar.gz
    Enter Backup/Restore username (can be Trafodion), default is [trafodion]:
    Specify the Hadoop distribution installed (1: Cloudera, 2: Hortonworks, 3: Other): 1
    Enter Hadoop admin username, default is [admin]:
    Enter Hadoop admin password, default is [admin]:
    Enter full Hadoop external network URL:port (include 'http://' or 'https://), default is []: 192.168.0.16:7180
    Enter HDFS username or username running HDFS, default is [hdfs]:
    Enter HBase username or username running HBase, default is [hbase]:
    Enter HBase group, default is [hbase]:
    Enter Zookeeper username or username running Zookeeper, default is [zookeeper]:
    Enter directory to install trafodion to, default is [/home/trafodion/apache-trafodion_server-2.0.1-incubating]:
    Start Trafodion after install (Y/N), default is Y:
    Total number of client connections per cluster, default [16]: 4
    Enter the node of primary DcsMaster, default [cent-1.novalocal]:
    Enable High Availability (Y/N), default is N:
    Enable simple LDAP security (Y/N), default is N:
    ***INFO: Trafodion configuration setup complete
    ***INFO: Trafodion Configuration File Check
    ...
    Configured Primary DcsMaster: "cent-1.novalocal"
    Active DcsMaster            : "cent-1"
    
    Process         Configured      Actual          Down
    ---------       ----------      ------          ----
    DcsMaster       1               1
    DcsServer       2               2
    mxosrvr         4               4
    
    
    You can monitor the SQ shell log file : /home/trafodion/apache-trafodion_server-2.0.1-incubating/logs/sqmon.log
    ***INFO: Installation setup completed successfully.
    
    ******************************
     TRAFODION INSTALLATION END
    ******************************

• 检查安装

  • 检查数据库运行状态

    [trafodion@cent-1 ~]$ sqcheck
    Checking if processes are up.
    Checking attempt: 1; user specified max: 2. Execution time in seconds: 0.
    
    The SQ environment is up!
    
    
    Process         Configured      Actual      Down
    -------         ----------      ------      ----
    DTM             2               2
    RMS             4               4
    DcsMaster       1               1
    DcsServer       2               2
    mxosrvr         4               4
    

  • 检查基本sql命令，trafci/sqlci

    [trafodion@cent-1 ~]$ trafci
    
    Welcome to Apache Trafodion Command Interface
    Copyright (c) 2015-2016 Apache Software Foundation
    
    Host Name/IP Address: cent-1.novalocal:23400
    User Name: zz
    
    Connected to Trafodion
    
    SQL>get schemas;
    
    
    Schemas in Catalog TRAFODION
    ============================
    
    
    SEABASE
    _LIBMGR_
    _MD_
    _REPOS_
    
    --- SQL operation complete.
    
    SQL>show schema;
    
    SCHEMA SEABASE
    
    SQL>create table test1(a int, b varchar(10));
    
    --- SQL operation complete.
    
    SQL>insert into test1 values(1, 'ABC');
    
    --- 1 row(s) inserted.
    
    SQL>select * from test1;
    
    A           B
    ----------- ----------
              1 ABC
    
    --- 1 row(s) selected.
    
    SQL>
    
    SQL>drop table test1;
    
    --- SQL operation complete.