Welcome to the SAP HANA Academy. My name
is Bob and in this series of videos
we'll be looking at SAP Vora 2.0. In
this series of videos were going to be
looking at installation. In this fourth
video of the series we'll be looking at
installing Vora on a single node Ubuntu
server within the Google Cloud Platform
within a Docker container. To give some
background what we've done is we've
created an Ubuntu server within the
Google Cloud Platform. Then what we
looked at was connecting to service
marketplace and getting hold of SAP Vora
2.0. Because we're prepping an image
You'll need to run scripts. All of these
scripts are available to you in our
GitHub repository, as you can see here.
And we've used those scripts to do a few
things. One of them is to create a
Kubernetes cluster on a single node Minikube
virtual machine. And lastly what we
did is we looked at instantiating or
starting a local Docker registry on that
Ubuntu server where we're going to
install SAP Vora. So now what we need
to do is get the SAP Vora installation
file the, TGZ file on this server. What
I did is I placed it in a team Dropbox
and I'm using W get to bring the file
locally. That's what I found is the
quickest and easiest way. Of course this
would work if you've got a Google Drive
as well. Because you can access it with a
W get and the port should by
default the open and you're Ubuntu
server should be able to connect to it.
So it's going to take around two minutes
to get. It’s about one and a half gig in
size. And again the version I got was in
end of October 2017 of Vora 2.0. That's the
version I've got which I showed you how
to get in one of my earlier videos. Now
that we've got it. I can run a clear and
if I do an LS we can see we've got that
file here. So now that we've got the file
what we'll need to do is untar that
package to extract it. So I'm going to
run a tar xvf and then the name of the
file. It will extract it.
It'll take a few seconds to extract and
now that we've got it what we can do is
just to make sure that it's there, I'll
run a clear and if I do in LS we can see
we've got a folder SAP Vora
distributed runtime. I'll go in that
folder and if I do an LS here you can
see now we've got those installation
files. And of course going to run an
installation dot SH. There's a couple of
variables we need to set. Firstly we need
to export that the namespace is equal to
Vora and we're doing this for both
Kubernetes and also for Docker. And of
course we're using the Docker registry.
So we need to export the name of our
Docker registry as well. Which is running
on port 5,000 on this machine. And of
course this will be used during the Vora
installation. Again if I do an LS in this
folder we're going to execute that
installed dot SH. And I'm going to run it
with a few different parameters. So I'll
paste the command in and I'll explain
how these parameters work. Of course
we're doing a dot forward slash
install dot SH. We’re deploying to the
cloud. So I'm going to put bash DT equals
cloud. You've also got the option to do
an on-premise install. You can skip the
installation of various services. I'm
skipping this Vora Diagnostics service.
And with this option I'm basically
saying that we have no role based access
control. There's loads more other options
you can turn on and off when you run
this install dot SH and they're all
really well documented within the
installation guide. So now I'll select
return and the install starts. What
you'll see is we've done some pre-flight
checks. So we've checked that we can
connect to Docker. We check that we can
push to the Docker registry. We can pull
from the registry and also we can use
Kube CTL to connect to our Kubernetes
cluster. So obviously all that needs to
work before proceeding. The first thing
we'll need to do is decide whether or
not we want to accept the license. Of
course I'm going to say yes. We want to
enable authentication. Which means we'll
have to log in with a password and log
in when using Vora tools. So of course
here I'm gonna say yes we'll then need
to enter our administrator
for Vora tools which I'm entering as
the user Vora with a specific password.
So I'll type that password in and I'll
reenter the password. Here we're prompted
to decide if we want to configure
connectivity to our Hadoop or Spark
installation. This is not a mandatory
step and we don't need to do that and
we'll cover that in another video. So for
now I'm just gonna hit enter to skip
this step. We’ll be prompted to see if we
want to configure HANA connectivity for
Vora tools and for the Vora thrift
server. Again I'm going to select no here.
And again we'll be prompted if we wanted
to configure connectivity to HDFS. I'm
going to select no and the reason is is
because if you want to create a table
which connects to data in HDFS you can
actually do that on the fly within the
table creation command. And I'll show you
how to do that in another video. So once
we press return then the installation
will start. Of course what's going to
happen then, we're installing to that
Docker registry so all the files needed
will be pushed to the Docker registry.
Now it's going to take around 4 minutes
to install.
So what I'll just do is I'll speed up
the installation process with the magic
of video and we'll come back to it to
alter the verification stage.
[Music]
So the great thing about the install dot
SH file is that the last step is that
it runs a validation, that all your
servers are running within the
Kubernetes cluster and that you can
lower the sample table. So here you can
see that the validation is running. It’s
testing that each of your various
services are up within the Kubernetes
cluster and then what's going to happen
at the very end is that it's going to
connect to your Vora
installation and it's going to try and
create a simple table and load some data
into that table and again this is just
to verify that your Vora installation is
working correctly. So here you can
see everything's working and then the
last step is that it will give you the
various ports needed for external
connectivity. The main thing that we're
looking at is this HANA tools port. Now
of course remember within the firewall
rule we opened up ports 30,000 to 33,000.
Of course what you might want
to do now is open up port 30,000
for Kubernetes dashboard. And then
then obviously open up the various
ports you need here. For example I would
open up the Vora tools port. So if I go
back to my browser what will first do is
verify that the Kubernetes is configured.
All I'll do on this page is I'll refresh
the page and what we should see is a new
namespace for Vora. If I click on the
drop down and scroll down we have a
namespace for Vora and then these are
our various, what are called deployments.
Which are essentially like services
within that Kubernetes cluster. Again
these deployments are fully explained if
you Google a Kubernetes deployment. It’s
all explained out there within Google or
on YouTube. If you select a specific
deployment then you can see other
various options for that deployment and
also log files as well. So of course
ultimately we want to test we can
connect to Vora.
So what I'll do is I'll copy the IP
address, the external IP address. I'll put
it into a new tab and if you remember
what I'm going to simply do is
append the Vora tools port. So I'll copy
that 3 0 8 2 4 in my case. Yours probably
will obviously be different. I'll put a
semicolon and then I'll put the port and
press return. And here you've got your
SAP Vora tools. Which looks the same as
in Vora 1.3. Of course I'll login with
that user that we created during the
installation. This is what it'll look
like. You might need to put it again, here
in, because I'm using Chrome. And then
here you'll see your typical data
browser editor model and user management.
And what we're looking for on the
right-hand side is that we can see that
we've actually connected. Here you can
see we've connected to our thrift server
running on port 10,000. So that's how you
perform an installation of SAP Vora.
What we're going to cover in the next
video is how to, if you want to obviously
shutdown your Ubuntu instance in the
Google Cloud Platform. How you can ensure
that your Vora services or Vora
deployments come back up in your
Kubernetes cluster.