This is the new beginning for the tutorials about vFabric SQLFire where you are going to learn how to work with this powerful in-memory distributed SQL database.
vFabric SQLFire is a valuable software for your consideration if you need an enterprise application with a dynamic scalability and high performance working with intensive data.
Before to start the tutorial be sure to create an account in VMWare Home Page
Figure 01: The Log In VMware Home Page
For this tutorial I am going to work with the follow software:
- Linux Fedora Core 17
- Oracle Java JDK 7 update 04
- VMware vFabric SQLFire 1.0.2 Enterprise Edition
Step 01: Getting The vFabric SQLFire 1.0.2 Enterprise Edition
To make this step instruction easier, be sure to be already logged in VMware and just do click in All Downloads. Once done this, you must see the follow page.
Figure 02: The VMware’s All Downloads Page
In the same page, the section of your interest is Product Download Index how you can see below.
Figure 03: The Product Download Index Page
Now locate the sub section Application Platform and do click in the item or option named VMware vFabric SQLFire. Once done this, you must arrive to the follow page.
Figure 04: The Download VMware vFabric SQLFire 1.0 Page (Top Part)
In the same page go below and you must see the follow.
Figure 05: The Download VMware vFabric SQLFire 1.0 Page (Bottom Part)
Now, we have two sections of our interest, these are:
- VMware vFabric SQLFire Professional Edition
- VMware vFabric SQLFire Enterprise Edition
I am going to work with the second option, therefore, for the item VMware vFabric SQLFire 1.0.2 Enterprise Edition, do click in View Download button. Therefore you must arrive to the follow page, I am including two images to complete the main page.
Figure 06: The Download VMware vFabric SQLFire 1.0.2 E… Page (Top Part)
Figure 07: The Download VMware vFabric SQLFire 1.0.2 E… Page (Bottom Part)
We are able to download the installer in just one presentation, a jar file, therefore not matter the architecture of the Operating System of our preference. This file is:
The other file listed, it is vFabric_SQLFire_102_INSTALL.txt, is only for installation guidance purpose. Anyway you are reading and
learning from my tutorial.
But we have a warning message (See Figure 06), we must do a registration process before, therefore do click in Download Free Trial (See Figure 06). Once done this, you must arrive to.
Figure 08: The VMware vFabric SQLFire Product Evaluation Center Page
Just do click in the Register button, you must arrive to the Accept End-User License Agreement page
Figure 09: The Accept End-User License Agreement Page (Top Part)
Proceed to fill the mandatory fields requested and accept the VMware vFabric SQLFire End User License Agreement and press the Continue button.
Figure 10: The Accept End-User License Agreement Page (Bottom Part)
Once done this, you must arrive again into the page VMware vFabric SQLFire Product Evaluation Center but now located in the tab pane named License & Download, for a better understanding see the follow image.
Figure 11: The VMware vFabric SQLFire Product Evaluation Center Page – (License & Download Part)
In the section Download Packages We only have one section to work, this is:
Check the follow image for a better understanding
Figure 12: The VMware vFabric SQLFire Product Evaluation Center Page – (Download Packages Part)
Note: Now with the Figure 12 where we have the software already registered, we must now ignore the Figure 06 and Figure 07, because in such point, we had not the software registered.
Since we have a unique option and the installer is a jar file, therefore do click in Manually Download, you must get the vFabric_SQLFire_102_Installer.jar file. Just how precaution, I am downloading the vFabric_SQLFire_102_INSTALL.txt file too. I downloaded these files into my Desktop directory.
Figure 13: The vFabric_SQLFire_102_Installer.jar File Installer And The vFabric_SQLFire_102_INSTALL.txt Text File Downloaded Into The Desktop Directory
Note: Be sure to do a checksum for theses files, it is a wise practice.
Step 02: Creating The Installation Directory
I am going to create and work in the follow path directory whiteroom/vmware/vfabricsqlfire/1.0.2/enterprise.
Then, open the terminal 01 to create the path directory suggested above, but before, be sure to be located in your home user directory, I mean, /home/username. Bear in mind, when you open a new terminal by default it is already located in your home user directory. If you want confirm explicitly where you are located in some terminal, you can use the command pwd.
[section1@localhost ~]$ pwd /home/section1 [section1@localhost ~]$
Listing 01: Terminal 01 – Knowing The Current Location Within A Terminal
My username is section1. Then we can now create the path directory. In the current terminal 01 execute the command mkdir -p whiteroom/vmware/vfabricsqlfire/1.0.2/enterprise.
[section1@localhost ~]$ mkdir -p whiteroom/vmware/vfabricsqlfire/1.0.2/enterprise [section1@localhost ~]$
Listing 02: Terminal 01 – Creating The whiteroom/vmware/vfabricsqlfire/1.0.2/enterprise Path Directory
Below the new directory created after of the command execution.
Figure 14: The whiteroom/vmware/vfabricsqlfire/1.0.2/enterprise Path Directory Empty
Step 03: Copying The File Installer To Our Customized Installation Directory
Proceed to copy (or move if you want it) the vFabric_SQLFire_102_Installer.jar installer to our path directory whiteroom/vmware/vfabricsqlfire/1.0.2/enterprise. You must see the follow.
Figure 15: The whiteroom/vmware/vfabricsqlfire/1.0.2/enterprise Path Directory With The vFabric_SQLFire_102_Installer.jar File Installer
Step 04: Moving Us To Our Customized Installation Directory
In the terminal 01 execute the command cd whiteroom/vmware/vfabricsqlfire/1.0.2/enterprise
[section1@localhost ~]$ cd whiteroom/vmware/vfabricsqlfire/1.0.2/enterprise [section1@localhost enterprise]$
Listing 03: Terminal 01 – Moving Us To The whiteroom/vmware/vfabricsqlfire/1.0.2/enterprise Path Directory
You can know our new location executing again the command pwd in the terminal 01.
[section1@localhost enterprise]$ pwd /home/section1/whiteroom/vmware/vfabricsqlfire/1.0.2/enterprise [section1@localhost enterprise]$
Listing 04: Terminal 01 – Knowing The Current Location Within A Terminal
Step 05: Executing The .jar File
Now is the turn to work around with the .jar file, we only need to execute it. Therefore again in the terminal 01 execute the command java -jar vFabric_SQLFire_102_Installer.jar
[section1@localhost enterprise]$ java -jar vFabric_SQLFire_102_Installer.jar Beginning installation. VMWARE END USER LICENSE AGREEMENT PLEASE NOTE THAT THE TERMS OF THIS END USER LICENSE AGREEMENT SHALL GOVERN YOUR USE OF THE SOFTWARE, REGARDLESS OF ANY TERMS THAT MAY APPEAR DURING THE INSTALLATION OF THE SOFTWARE. IMPORTANT-READ CAREFULLY: BY DOWNLOADING, INSTALLING, OR USING THE SOFTWARE, YOU (THE INDIVIDUAL OR LEGAL ENTITY) AGREE TO BE BOUND BY THE TERMS OF THIS END USER LICENSE AGREEMENT ("EULA"). IF YOU DO NOT AGREE TO THE TERMS OF THIS EULA, YOU MUST NOT DOWNLOAD, INSTALL, OR USE THE SOFTWARE, AND YOU MUST DELETE OR RETURN THE UNUSED SOFTWARE TO THE VENDOR FROM WHICH YOU ACQUIRED IT WITHIN THIRTY (30) DAYS AND REQUEST A REFUND OF THE LICENSE FEE, IF ANY, THAT YOU PAID FOR THE SOFTWARE. EVALUATION LICENSE. If You are licensing the Software for evaluation purposes, your use of the Software is only permitted in a non-production environment and for the period limited by the Software License Key. Notwithstanding any other provision in this EULA, an Evaluation License of the Software is provided "AS- IS" without support or warranty of any kind, expressed or implied. <Press enter to continue>
Listing 05: Terminal 01 – Executing The vFabric_SQLFire_102_Installer.jar Installer File – (Part I)
When you execute the jar file, you can see firstly the Vmware End User License Agreement. Be aware that the terminal’s cursor is located below of <Press enter to continue>. Then, proceed to press the intro key. Next you must see the follow
1. DEFINITIONS 1.1 "Documentation" means, collectively, the operation instructions, release notes, user manuals and/or help files for the Software in electronic or written form. 1.2 "Guest Operating Systems" means instances of third-party operating systems licensed separately by You and installed in a Virtual Machine. 1.3 "Software" means software products that are licensed to You under this EULA, including, but not limited to, any related components purchased or provided with the Software, Documentation, and any maintenance releases thereto. 1.4 "Software License Key" means a valid serial number issued to You to activate and use the Software. 1.5 "Open Source Software" means various software components including open source software, that may be part of the Software, each licensed to You under its own applicable license terms and conditions, which can be found in the <Press enter to continue>
Listing 06: Terminal 01 – Executing The vFabric_SQLFire_102_Installer.jar Installer File – (Part II)
Practically we got some explanation for some terms or definitions that be going to be used in the process. Again, proceed to press the intro key.
Note: practically we are going to see a lot of points about the rest of the license, it is from the point 2 until point 8. Be aware that many of these points has inner points, I mean like 2.2, 7.4, etc.
Note: To advance through these points, you going to press many times the intro key, always below the line <Press enter to continue>
Below I am resuming these points with the pattern … … …
2. GRANT AND USE RIGHTS FOR SOFTWARE ... ... ... 8.7 VMware vFabric SQLFire Enterprise Edition If You license VMware vFabric SQLFire Enterprise Edition, the following definitions and license terms apply. "Processor" means a single physical chip that houses no more than six (6) processor cores that executes the instructions of the Software. "Server" means a single hardware system capable of running the Software. For purposes of this Agreement, a hardware partition or blade is considered a separate hardware system. <Press enter to continue> Additional License Terms You may install and use the Software on Servers that contain up to the maximum aggregate number of Processors for which You have paid the applicable license fees. Subject to the foregoing, You may link clusters of Servers running the Software; each cluster may contain an unlimited number of linked Servers running the Software. You may also use the data-aware stored procedures capability of the Software and enable the Wide Area Network (WAN) communicationfeature of the Software for any nodes in Your network. Apr18-2012 Enter "agree" to accept the terms of the license or "disagree" to abort the installation.
Listing 07: Terminal 01 – Executing The vFabric_SQLFire_102_Installer.jar Installer File – (Part III)
To proceed and complete we must write the word agree and press the intro key.
Enter "agree" to accept the terms of the license or "disagree" to abort the installation. agree Please specify the vFabric_SQLFire installation directory. [/home/section1/whiteroom/vmware/vfabricsqlfire/1.0.2/enterprise]
Listing 08: Terminal 01 – Executing The vFabric_SQLFire_102_Installer.jar Installer File – (Part IV)
Now we are asked for to indicate the installation directory. Since I am going to use my current location (/home/section1/whiteroom/vmware/vfabricsqlfire/1.0.2/enterprise), I am going to just to press the intro key. Later be going to be mandatory write the word yes and again press the intro key.
Verify this directory is correct: /home/section1/whiteroom/vmware/vfabricsqlfire/1.0.2/enterprise [yes] yes Unzipping files......................................... Installation has finished. [section1@localhost enterprise]$
Listing 09: Terminal 01 – Executing The vFabric_SQLFire_102_Installer.jar Installer File – (Part V)
After of the execution of the jar file a new directory named vFabric_SQLFire_102 must appear, like shown below.
Figure 16: The New vFabric_SQLFire_102 Directory Created After To Execute The vFabric_SQLFire_102_Installer.jar Installer File
How you can see above, we have a new file available too, it is EULA.txt. If you open the file, you are going to find the complete license content. Remember that It was shown before by parts through the terminal 01 while the installation process.
Step 06: Knowing The vFabric_SQLFire_102 Directory (Optional)
Let’s see what directories exists within the vFabric_SQLFire_102 directory
Figure 17: The vFabric_SQLFire_102 Directory Content
How you can see we have the bin directory. Lets see what files we have available within the bin directory
Figure 18: The vFabric_SQLFire_102/bin Directory Content
Step 07: Connect The SQLFire
You would consider this step like startup the server, but with vFabric SQLFire it is not required or mandatory. For a better understanding consider the follow analogy, it is how when you get access with MySQL within a terminal and therefore you are able to execute its own commands. The same happen with vFabric SQLFire
Note: Instead of MySQL, vFabric SQLFire not require a login access approach.
Therefore firstly, in the terminal 01 execute the command cd vFabric_SQLFire_102/bin
[section1@localhost enterprise]$ cd vFabric_SQLFire_102/bin [section1@localhost bin]$
Listing 10: Terminal 01 – Moving Us To The vFabric_SQLFire_102/bin Path Directory
Now execute the command (really the script) ./sqlf
[section1@localhost bin]$ ./sqlf sqlf version 10.4 sqlf>
Listing 11: Terminal 01 – Executing The sqlf File Script – (Connect Mode)
In others tutorials, I am going to explain many commands.
Step 08: Disconnect The SQLFire
Again, you would consider this step like shutdown the server, but with vFabric SQLFire it is not required or mandatory.
In the terminal 01 execute the command exit;
sqlf> exit; [section1@localhost bin]$
Listing 12: Terminal 01 – Executing The sqlf File Script – (Disconnect Mode)
Congratulations!!!. You have learned how adquire, install, connect, disconnect VMware vFabric SQLFire 1.0.2 Enterprise Edition.
In future tutorials we are going to learn some commands and work with some simple databases.