What a great news in „VoltDBRIEF January-February 2017“! New version of VoltDB is out. VoltDB is a one of brightest jewells in my „I-want-to-use-and-learn“ list of database solutions. With no doubt we will hear about this product in near future. Let’s have a look on Community edition.
\n
\nThere are lot of differencies between Enterprise and Community editions, anyway from „user“ perspective, the most important for Community is a need for compiling it from source. Sounds hard, right?! \ud83d\ude42 Hopefully, there is a good document describing few basic things. My way:<\/p>\n
1) Consolidate proper java(jdk) version in your computer. I have no reason to trust openjdk, so I’m using the one from Oracle:<\/p>\n
[crayon lang=“shell“]
\n[root@db2111 voltdb]# rpm -i \/home\/j\/jdk-8u121-linux-x64.rpm
\nUnpacking JAR files…
\ntools.jar…
\nplugin.jar…
\njavaws.jar…
\ndeploy.jar…
\nrt.jar…
\njsse.jar…
\ncharsets.jar…
\nlocaledata.jar…
\n[root@db2111 voltdb]#<\/p>\n
[\/crayon]
\nJava is installed in \/usr\/java („Indeed, Watson!“) and the only thing is to setup this one jdk as active one:<\/p>\n
[crayon lang=“shell“]
\n[root@db2111 java]# update-alternatives –config java<\/p>\n
[\/crayon]<\/p>\n
There are 4 programs which provide ‚java‘.<\/p>\n
[crayon lang=“shell“]<\/p>\n
Selection\u00a0\u00a0\u00a0 Command
\n———————————————–
\n1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/usr\/lib\/jvm\/jre-1.5.0-gcj\/bin\/java
\n*+ 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/usr\/lib\/jvm\/jre-1.8.0-openjdk.x86_64\/bin\/java
\n3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/usr\/lib\/jvm\/jre-1.6.0-openjdk.x86_64\/bin\/java
\n4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/usr\/java\/jdk1.8.0_121\/jre\/bin\/java<\/p>\n
Enter to keep the current selection[+], or type selection number: 4
\n[root@db2111 java]#<\/p>\n
[\/crayon]
\nKeeping on mind „don’t spend your time with garbage“, choosing proper one line is a matter of one second.<\/p>\n
2) Next phase is to install all required packages for building VoltDB Community.<\/p>\n
[crayon lang=“shell“]<\/p>\n
[root@db2111 ~]# wget https:\/\/dl.fedoraproject.org\/pub\/epel\/6\/x86_64\/epel-release-6-8.noarch.rpm
\n–2017-02-06 11:14:23–\u00a0 https:\/\/dl.fedoraproject.org\/pub\/epel\/6\/x86_64\/epel-release-6-8.noarch.rpm
\nResolving globalproxy.dhl.com… 165.72.0.21
\nConnecting to globalproxy.dhl.com|165.72.0.21|:8080… connected.
\nProxy request sent, awaiting response… 200 OK
\nLength: 14540 (14K) [application\/x-rpm]
\nSaving to: \u201cepel-release-6-8.noarch.rpm\u201d<\/p>\n
100%[====================================================================================>] 14,540\u00a0\u00a0\u00a0\u00a0\u00a0 –.-K\/s\u00a0\u00a0 in 0.002s<\/p>\n
2017-02-06 11:14:24 (5.97 MB\/s) – \u201cepel-release-6-8.noarch.rpm\u201d saved [14540\/14540]<\/p>\n
[root@db2111 ~]# rpm -Uvh epel*.rpm
\nwarning: epel-release-6-8.noarch.rpm: Header V3 RSA\/SHA256 Signature, key ID 0608b895: NOKEY
\nPreparing…\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ########################################### [100%]
\n1:epel-release\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ########################################### [100%]
\n[root@db2111 ~]# yum -y install ant ant-nodeps ant-junit ant-scripts ant-javadoc ant-trax gcc gcc-c++ python valgrind ntp python26 git-all python-httplib2 python-setuptools python-devel ccache cmake bzip2<\/p>\n
[\/crayon]<\/p>\n
The last command will install a lot of dependencies, which are essentials!<\/p>\n
[crayon lang=“shell“]<\/p>\n
…
\nInstalled:
\nant-javadoc.x86_64 0:1.7.1-15.el6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ant-scripts.x86_64 0:1.7.1-15.el6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ccache.x86_64 0:3.1.6-2.el6
\ncmake.x86_64 0:2.8.12.2-4.el6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 git-all.noarch 0:1.7.1-4.el6_7.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 python-httplib2.noarch 0:0.7.7-1.el6<\/p>\n
Dependency Installed:
\ncvsps.x86_64 0:2.2-0.6.b1.el6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 emacs-git.noarch 0:1.7.1-4.el6_7.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 git-cvs.noarch 0:1.7.1-4.el6_7.1
\ngit-email.noarch 0:1.7.1-4.el6_7.1\u00a0\u00a0\u00a0\u00a0 git-gui.noarch 0:1.7.1-4.el6_7.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 git-svn.noarch 0:1.7.1-4.el6_7.1
\ngitk.noarch 0:1.7.1-4.el6_7.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 perl-Authen-SASL.noarch 0:2.13-3.el6\u00a0\u00a0\u00a0\u00a0\u00a0 perl-Digest-HMAC.noarch 0:1.01-22.el6
\nperl-Digest-SHA1.x86_64 0:2.12-2.el6\u00a0\u00a0 perl-GSSAPI.x86_64 0:0.26-6.el6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 perl-IO-Socket-SSL.noarch 0:1.31-3.el6_8.2
\nperl-Net-LibIDN.x86_64 0:0.12-3.el6\u00a0\u00a0\u00a0 perl-Net-SMTP-SSL.noarch 0:1.01-4.el6\u00a0\u00a0\u00a0\u00a0 perl-Net-SSLeay.x86_64 0:1.35-10.el6_8.1
\nperl-TermReadKey.x86_64 0:2.30-13.el6\u00a0 subversion-perl.x86_64 0:1.6.11-15.el6_7\u00a0 tcl.x86_64 1:8.5.7-6.el6
\ntk.x86_64 1:8.5.7-5.el6<\/p>\n
Complete!
\n[root@db2111 ~]#<\/p>\n
[\/crayon]<\/p>\n
3) GIT time!<\/p>\n
[crayon lang=“shell“]<\/p>\n
[root@db2111 ~]# git clone https:\/\/github.com\/VoltDB\/voltdb.git
\nInitialized empty Git repository in \/root\/voltdb\/.git\/
\nremote: Counting objects: 333817, done.
\nremote: Compressing objects: 100% (210\/210), done.
\nremote: Total 333817 (delta 76), reused 0 (delta 0), pack-reused 333595
\nReceiving objects: 100% (333817\/333817), 440.07 MiB | 545 KiB\/s, done.
\nResolving deltas: 100% (226569\/226569), done.
\n[root@db2111 ~]#
\n[root@db2111 ~]# cd voltdb\/
\n[root@db2111 voltdb]# ant
\nBuildfile: build.xml<\/p>\n
catalog:<\/p>\n
dbbpool_gen_check:<\/p>\n
….<\/p>\n
buildbundles:<\/p>\n
default:<\/p>\n
BUILD SUCCESSFUL
\nTotal time: 17 minutes 14 seconds
\n[root@db2111 voltdb]#<\/p>\n
[\/crayon]<\/p>\n
4) Tiny kernel adjustment
\nTransparent huge pages are not supported by VoltDB, so we can disable this feature:<\/p>\n
[crayon lang=“shell“]<\/p>\n
[root@db2111 bin]# echo never > \/sys\/kernel\/mm\/transparent_hugepage\/enabled
\n[root@db2111 bin]# echo never > \/sys\/kernel\/mm\/transparent_hugepage\/defrag<\/p>\n
[\/crayon]<\/p>\n
for current session or disable THP on a kernel modules level (GRUB parameter), so my line in \/boot\/grub\/grub.conf looks like:<\/p>\n
[crayon lang=“shell“]<\/p>\n
title Oracle Linux Server Unbreakable Enterprise Kernel (4.1.12-61.1.25.el6uek.x86_64)
\nroot (hd0,1)
\nkernel \/boot\/vmlinuz-4.1.12-61.1.25.el6uek.x86_64 ro root=UUID=5c5bdb6d-4819-4793-9084-a569bfaa674b rd_NO_LUKS rd_NO_LVM LANG=en_US.UTF-8 rd_NO_MD SYSFONT=latarcyrheb-sun16 transparent_hugepage=never KEYBOARDTYPE=pc KEYTABLE=us rd_NO_DM rhgb quiet<\/p>\n
[\/crayon]<\/p>\n
That would be fine in case you are not using RHEL\/clone and its caveats.
\nThere should be still background services which turn THP on.
\nAdepts for service name = ktune, tuned – so you just need to disable these services from starting.<\/p>\n
4.5) Reboot your linux machine.<\/p>\n
5) Happy VoltDB user \ud83d\ude09<\/p>\n
[crayon lang=“shell“]<\/p>\n
[root@db2111 bin]# .\/voltdb init
\nnitializing VoltDB…<\/p>\n
_\u00a0\u00a0\u00a0 __\u00a0\u00a0\u00a0\u00a0\u00a0 ____\u00a0 ____\u00a0 ____
\n| |\u00a0 \/ \/___\u00a0 \/ \/ \/_\/ __ \\\/ __ )
\n| | \/ \/ __ \\\/ \/ __\/ \/ \/ \/ __\u00a0 |
\n| |\/ \/ \/_\/ \/ \/ \/_\/ \/_\/ \/ \/_\/ \/
\n|___\/\\____\/_\/\\__\/_____\/_____\/<\/p>\n
——————————–<\/p>\n
Build: 7.0 voltdb-7.0-39-g22231a2 Community Edition
\nWhen using the INIT command, some deployment file settings (hostcount, voltdbroot path, and admin-mode) are ignored
\nInitialized VoltDB root directory voltdbroot
\n[root@db2111 bin]# .\/voltdb start
\nWARNING: Unsupported release: oracle release 6.8
\nInitializing VoltDB…<\/p>\n
_\u00a0\u00a0\u00a0 __\u00a0\u00a0\u00a0\u00a0\u00a0 ____\u00a0 ____\u00a0 ____
\n| |\u00a0 \/ \/___\u00a0 \/ \/ \/_\/ __ \\\/ __ )
\n| | \/ \/ __ \\\/ \/ __\/ \/ \/ \/ __\u00a0 |
\n| |\/ \/ \/_\/ \/ \/ \/_\/ \/_\/ \/ \/_\/ \/
\n|___\/\\____\/_\/\\__\/_____\/_____\/<\/p>\n
——————————–<\/p>\n
Build: 7.0 voltdb-7.0-39-g22231a2 Community Edition
\nLoaded node-specific settings from voltdbroot\/config\/path.properties
\nConnecting to VoltDB cluster as the leader…
\nHost id of this node is: 0
\nStarting a new database cluster
\nInitializing the database. This may take a moment…
\nWARN: Strict java memory checking is enabled, don’t do release builds or performance runs with this enabled. Invoke „ant clean“ and „ant -Djmemcheck=NO_MEMCHECK“ to disable.
\nWARN: This is not a highly available cluster. K-Safety is set to 0.
\nWARN: Durability is turned off. Command logging is off.
\nServer Operational State is: NORMAL
\nServer completed initialization.<\/p>\n
[\/crayon]<\/p>\n
Server is up and running. Just two more notices:<\/p>\n
a) client resides also in bin directory and it’s called „sqlcmd“<\/p>\n
b) dashboard resides in http:\/\/<hostname>:8080, e.g.:<\/p>\n
-a-<\/p>\n","protected":false},"excerpt":{"rendered":" What a great news in „VoltDBRIEF January-February 2017“! New version of VoltDB is out. VoltDB is a one of brightest jewells in my „I-want-to-use-and-learn“ list of database solutions. With no doubt we will hear about this product in near future. … Continue reading ![\"\"](\"http:\/\/it.tuxie.eu\/wp-content\/uploads\/2017\/02\/vdb.png\")
<\/a>
\nFor further exploring this fantastic software I warmly recommend documentation section.<\/p>\n