InfiniDB® Windows Installation and Administrator’s Guide
Windows Installation and
Document Version: 4.5-2
InfiniDB Windows Installation and Administrator’s Guide
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.
This guide contains information needed to perform installation of InfiniDB on Windows and the subsequent administration.
This guide is written for IT administrators who are responsible for implementing the windows version of the InfiniDB System.
The InfiniDB Database Platform documentation consists of several guides intended for different audiences. The documentation is described in the following table:
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.
We encourage feedback, comments, and suggestions so that we can improve our documentation. Send comments to email@example.com along with the document name, version, comments, and page numbers.
If you need help installing, tuning, or querying your data with InfiniDB, you can contact firstname.lastname@example.org.
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.
InfiniDB for Windows has the following differences from InfiniDB for Linux:
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.
InfiniDB for Windows has been certified to run on the following operating systems:
· Windows Server 2008
· Windows Server 2012
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:
For Enterprise Customers:
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.
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.
/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.
The following command will perform a no-prompt InfiniDB installation into the default C:\Calpont directory of the server:
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
The following command will launch a GUI InfiniDB installation with the myinfinidb directory on the secondary hard drive (E) defaulted as the destination folder:
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.
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.
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:
Note: If you have a previously created database, you may specify the database name when logging in:
Once in, standard procedures for syntax may be followed. Please reference the InfiniDB SQL Syntax Guide for further information.
Please see “Granting Access for Users” in the InfiniDB Administrator’s Guide on setting initial permissions for user accounts.
To start/stop/restart InfiniDB, the Services window may be used:
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:
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 mytable “mytable 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”
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):
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:
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:
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
Use the following steps if you wish to completely remove InfiniDB for Windows from your server: