InfiniDB®

Windows Installation and

Administrator’s Guide

 

 

 

 

 

 

 

 

 

 

                             

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Release:  4.6

Document Version:  4.6-1


 

 

 

 

 

 

 

 

 

 

 

 

 

               

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

InfiniDB Windows Installation and Administrator’s Guide

July 2014

Copyright © 2014 InfiniDB Corporation. All Rights Reserved.

 

InfiniDB, the InfiniDB logo and any other product or service names or slogans contained in this document are trademarks of InfiniDB and its suppliers or licensors, and may not be copied, imitated or used, in whole or in part, without the prior written permission of InfiniDB or the applicable trademark holder.

 

Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of InfiniDB.

 

InfiniDB may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering  subject matter in this document. Except as expressly provided in any written license agreement from InfiniDB, the furnishing of this document does not give you any license to these patents, trademarks copyrights, or other intellectual property. The information in this document is subject to change without notice. InfiniDB shall not be liable for any damages resulting from technical errors or omissions which may be present in this document, or from use of this document.


Contents

1       Introduction. 4

1.1         Audience. 4

1.2         List of documentation. 4

1.3         Obtaining documentation. 4

1.4         Documentation feedback. 4

1.5         Additional resources. 4

2       Overview. 5

3       Key Differences from Linux based InfiniDB. 5

4       Installation of InfiniDB for Windows. 6

4.1         Preparing for Installation. 6

4.2         OS Information. 6

4.3         Installation Overview. 6

4.4         Custom InfiniDB configuration file. 6

4.5         Command Prompt Installation. 7

4.6         InfiniDB Windows GUI Installation. 8

5       Administrative. 10

5.1         Logging into InfiniDB for Windows. 10

5.2         Using InfiniDB for Windows. 10

5.3         Setting Permissions For Users. 10

5.4         Starting/Stopping the InfiniDB Service. 11

5.5         Using InnoDB in InfiniDB for Windows. 11

5.6         Importing Data into InfiniDB for Windows. 11

6       Upgrade of InfiniDB for Windows. 13

6.1         Command Prompt update. 13

6.2         InfiniDB for Windows GUI update. 14

7       Removing InfiniDB for Windows. 16

 

 


1         Introduction

This guide contains information needed to perform installation of InfiniDB on Windows and the subsequent administration.

1.1      Audience

This guide is written for IT administrators who are responsible for implementing the windows version of the InfiniDB System.

1.2      List of documentation

The InfiniDB Database Platform documentation consists of several guides intended for different audiences. The documentation is described in the following table:

 

Document

Description

InfiniDB Administrator’s Guide

Provides detailed steps for maintaining InfiniDB.

InfiniDB Apache HadoopTM Configuration Guide

Installation and Administration of an InfiniDB for Apache Hadoop system.

InfiniDB Concepts Guide

Introduction to the InfiniDB analytic database.

InfiniDB Minimum Recommended Technical Specifications

Lists the minimum recommended hardware and software specifications for implementing InfiniDB.

InfiniDB Installation Guide

Contains a summary of steps needed to perform an install of InfiniDB.

InfiniDB Multiple UM Configuration Guide

Provides information for configuring multiple User Modules.

InfiniDB SQL Syntax Guide

Provides syntax native to InfiniDB.

Performance Tuning for the InfiniDB Analytics Database

Provides help for tuning the InfiniDB analytic database for parallelization and scalability.

 

1.3      Obtaining documentation

These guides reside on our http://www.infinidb.co website.  Contact support@infinidb.co for any additional assistance.

1.4      Documentation feedback

We encourage feedback, comments, and suggestions so that we can improve our documentation. Send comments to support@infinidb.co along with the document name, version, comments, and page numbers.

1.5      Additional resources

If you need help installing, tuning, or querying your data with InfiniDB, you can contact support@infinidb.co.


2         Overview

InfiniDB is available on a Linux or a 64-bit Windows package.  This guide describes the installation and administration of InfiniDB in a Windows environment.

3         Key Differences from Linux based InfiniDB

InfiniDB for Windows has the following differences from InfiniDB for Linux:

 


4         Installation of InfiniDB for Windows

4.1      Preparing for Installation

Similar to the Linux version of InfiniDB, you should determine how much disk space your system will need before loading InfiniDB to ensure the required space is available.

 

4.2      OS Information

InfiniDB for Windows has been certified to run on the following operating systems:

·         Windows Server 2008

·         Windows Server 2012

 

4.3      Installation Overview

Notes: InfiniDB for Windows requires administrator privileges to install.  Please contact your systems administrator if you do not have the required privileges.

 

You should disable any anti-virus protection software before running the InfiniDB for Windows installer.

 

InfiniDB for Windows may be installed by using either the command prompt or by one of the following methods:

·         Command prompt – used when prompting is not desired.

·         InfiniDB Installer GUI – standard windows installation with prompts.

 

The Windows Installer has the following naming convention:

 

InfiniDB64-release#.exe

 

For Enterprise Customers:

InfiniDB64-ent-release#.exe

 

4.4      Custom InfiniDB configuration file

If you wish to use a custom InfiniDB configuration file (Calpont.xml) with your installation, you may place the Calpont.xml file in the \etc directory (i.e., C:\Calpont) of your destination folder before running the installation. 

 


4.5      Command Prompt Installation

InfiniDB may be installed using a command prompt.  If you are not in an Administrator Command Prompt, you will receive a User Account Control popup to continue the execution of the installer.

 

InfiniDB64-release#.exe

Options:

/S – Silent, no-prompt mode

/D= – Destination folder where InfiniDB will be installed.  If omitted, the default is C:\Calpont.  NOTE: Quotes placed around the destination folder are not supported.

 

Example 1:

The following command will perform a no-prompt InfiniDB installation into the default C:\Calpont directory of the server:

 

InfiniDB64-release#.exe /S

 

Example 2:

The following command will perform a no-prompt InfiniDB installation into the myinfinidb directory on the secondary hard drive (E) of the server:

 

InfiniDB64-release#.exe /S /D=E:\myinfinidb

 

 

Example 3:

The following command will launch a GUI InfiniDB installation with the myinfinidb directory on the secondary hard drive (E) defaulted as the destination folder:

 

InfiniDB64-release#.exe /D=E:\myinfinidb

 

4.6      InfiniDB Windows GUI Installation

You may launch the GUI Installer by running the InfiniDB64-release#.exe file from Windows Explorer.  If you have not chosen the “Run as Administrator” option, you will receive a User Account Control popup to continue the execution of the installer.

 

 

Once through the User Account Control popup, the InfniDB Setup: Installation Folder window will display with Destination Folder defaulted to C:\Calpont:

 

 

 

 

You may select the Browse button to choose different Destination Folder or simply type in the destination.


Select Next> to continue and the InfiniDB Setup window will display with the following defaults:

 

 

·         mysqld port number - The InfiniDB MySQL service utilizes port 3306. If another MySQL service is running, you must change the port.

·         Start InfiniDB automatically – uncheck this if you want to manually start the InfiniDB service at system boot.

·         Append InfiniDB to system PATH – uncheck this if you want to manually update the system PATH

 

Once you are satisfied with the options, select Install to continue the installation.  InfiniDB will be installed into the destination folder once completed.

 


5         Administrative

Please reference the InfiniDB Administrator’s Guide for detailed administrative tasks/options for setting up and maintaining InfiniDB.  Some items below have been included in this document that are specific to InfiniDB for Windows.

5.1      Logging into InfiniDB for Windows

If you are running InfiniDB under a Windows platform, the default command window for some Windows OS versions may not run with enough permissions to write to InfiniDB files. You should start a privileged command window by right-clicking on the command window item in the Start menu and choose the “Run as Administrator” option.

 

 

Logging into InfiniDB is simply typing the following at a command prompt:

 

idbmysql

 

Note: If you have a previously created database, you may specify the database name when logging in:

idbmysql mydb

 

5.2      Using InfiniDB for Windows

Once in, standard procedures for syntax may be followed. Please reference the InfiniDB SQL Syntax Guide for further information.

 

5.3      Setting Permissions For Users

Please see “Granting Access for Users” in the InfiniDB Administrator’s Guide on setting initial permissions for user accounts.

 


5.4      Starting/Stopping the InfiniDB Service

To start/stop/restart InfiniDB, the Services window may be used:

 

 

 

5.5      Using InnoDB in InfiniDB for Windows

InfiniDB for Windows comes with the InnoDB plugin already installed but the InnoDB engine itself is disabled to conserve memory and space utilization.  If you have a need to use the InnoDB engine within InfiniDB, comment out the skip-innodb line in the my.ini file.  A restart of the InfiniDB service (see above) is needed once the modification has been made:

 

# skip-innodb

5.6      Importing Data into InfiniDB for Windows

Importing data into InfiniDB for Windows is similar to loading data into InfiniDB on a Linux system.  Please see “Importing Data” in the InfiniDB Administrator’s Guide for more details.  There is a slight difference in using options for the colxml and cpimport commands, however.  In order to have the options recognized, they must be placed immediately after the colxml or cpimport command and before any required values.

 

Example colxml command:

This command is to have a different job id of today’s date (other than the default of 299):

 

colxml –j20130331 mydb

 

 

Example cpimport command:

These commands are used to read the source file from a different directory:

 

cpimport -fc:\source\mydb mydb mytable mytable.tbl

 

cpimport mydb mytable c:\source\mydb\mytable.tbl

 

 

Example cpimport command with spaces in file name or directory path:

Use double quotation marks (“) when the directory path or file name contains spaces:

 

cpimport mydb mytablemytable source.tbl

 

cpimport mydb mytable “c:\source data\mytable.tbl

 

 

Example cpimport command with multiple files used as source data:

Use a comma with no spaces when importing from multiple files.  If spaces exist in the file names, then use double quotation marks around the file name :

 

cpimport mydb mytable mytable mytable1.tbl,mytable2.tbl

 

cpimport mydb mytable mytable mytable1.tbl,”mytable two.tbl

 

 


6         Upgrade of InfiniDB for Windows

 

The recommended way to upgrade InfiniDB for Windows is as follows (this will keep any customizations you may have made to Calpont.xml and my.ini):

 

6.1      Command Prompt update

Example 1:

From an Administrator Command Prompt, the following command will perform a no-prompt InfiniDB for Windows software update into the existing InfiniDB directory (i.e., C:\Calpont) of the server:

 

InfiniDB64-release#.exe /S

 


Example 2:

From an Administrator Command Prompt, the following command will launch a GUI InfiniDB upgrade with the existing InfiniDB directory (i.e., c:\Calpont) defaulted as the destination folder:

InfiniDB64-release#.exe

 

 

6.2      InfiniDB for Windows GUI update

You may launch the GUI Installer by running the InfiniDB64-release#.exe file from Windows Explorer.  If you have not chosen the “Run as Administrator” option, you will receive a User Account Control popup to continue the execution of the upgrade.

 

 


Once through the User Account Control popup, the InfniDB Setup: Installation Folder window will display with the existing InfiniDB folder populated.  Continue thru the GUI Installer to complete the InfiniDB for Windows upgrade.

 

 

 

 

·         Re-enable your anti-virus protection software


7         Removing InfiniDB for Windows

 

Use the following steps if you wish to completely remove InfiniDB for Windows from your server: