Notes on Calpont InfiniDB

Calpont InfiniDB Enterprise

Calpont InfiniDB Community Edition

(Below I assume Calpont InfiniDB Enterprise version 3.6.1, whose MySQL frontend is version 5.1.39)

Configuration

Suppose it is to be run by non-root user foobar and it is already installed under /opt/Calpont
  1. Create an entry in /etc/sudoer by root: 
    foobar ALL = NOPASSWD: ALL
  2. Set up environment variables 
    export INFINIDB_INSTALL_DIR=/opt/Calpont
export LD_LIBRARY_PATH=$INFINIDB_INSTALL_DIR/lib:$INFINIDB_INSTALL_DIR/mysql/lib/mysql:$LD_LIBRARY_PATH
source /opt/Calpont/bin/calpontAlias
  3. Under /opt/Calpont/lib, make sure symbolic links such as libbatchloader.so (linked to libbatchloader.so.1.0.0) are created.

    To check, execute ldd /opt/Calpont/bin/PrimProc

  4. Edit /opt/Calpont/mysql/my.cnf file.

    Set up socket file location, port number, datadir, max_allowed_packet, etc.

  5. Execute /opt/Calpont/bin/postConfigure

Start/Shutdown Server

  1. Set up environment variables 
    export INFINIDB_INSTALL_DIR=/opt/Calpont
export LD_LIBRARY_PATH=$INFINIDB_INSTALL_DIR/lib:$INFINIDB_INSTALL_DIR/mysql/lib/mysql:$LD_LIBRARY_PATH
  2. Start server: /opt/Calpont/bin/calpontConsole startSystem
  3. Stop server: /opt/Calpont/bin/calpontConsole shutdownSystem y

Command-line tools, log files

  • (MySQL) client

    /opt/Calpont/mysql/bin/mysql --defaults-file=/opt/Calpont/mysql/my.cnf -u root

  • Console

    /opt/Calpont/bin/calpontConsole

  • Debug logs

    tail -f /var/log/Calpont/debug.log

  • Info logs

    tail -f /var/log/Calpont/info.log

Process tree

Once Calpont InfiniDB is running (single-node mode), one should see the following process tree: 
/bin/bash /opt/Calpont/bin/run.sh /opt/Calpont/bin/ProcMon
 \_ /opt/Calpont/bin/ProcMon
     \_ [ProcMgr]
     \_ /opt/Calpont/bin/controllernode fg
     \_ /opt/Calpont/bin/ServerMonitor
     \_ /opt/Calpont/bin/workernode DBRM_Worker1 fg
     \_ [PrimProc]
     \_ [ExeMgr]
     \_ [WriteEngineServ]
     \_ [DMLProc]
     \_ [DDLProc]
/bin/sh /opt/Calpont/mysql//bin/mysqld_safe --defaults-file=/opt/Calpont/mysql/my.cnf --datadir=....
 \_ /opt/Calpont/mysql/libexec/mysqld --defaults-file=/opt/Calpont/mysql//my.cnf --basedir=/opt/Calpont ...