Hello and welcome to the SAP HANA Academy.
The topic of this video tutorial series is SAP HANA on Google Cloud Platform
and in this video we are going to execute a single-node deployment.
This video has been recorded on release SAP HANA 2.0 SPS 03 from April 2018.
For earlier or later releases, please check the playlist on the SAP HANA Academy.
Hi, I am Denys van Kempen.
OK — in the previous videos, we looked into the prepar ation aspects and uploaded the installation
files to a Cloud Storage bucket.
We also edited the configuration file for our deployment, template.yaml.
In this video, we are going to execute a single-node deployment and the good news is that once
you have set everything up properly, it is actually quite easy.
Here is the command
gcloud deployment-manager deployments create deploymentName --config templateName.yaml
You can run it from Google Cloud Shell, if you want.
Make sure to change deploymentName and templateName
I will run it from my local gcloud environment
As a reminder, here is my template.
The instance name for the compute engine is hana; the image, SUSE Linux; the SID, ABC;
and the password Initial1
Here is my deployment command
gcloud deployment-manager deployments create hanaacademy --config hanaacademy.yaml
OK, let’s run this.
The deployment is created.
Note the Python command in the header - gcloud.py
It’s all python in the background with google cloud.
If we switch to the console and select Deployment Manager from the menu we see that the hanaacademy
deployment is being created and after 30 seconds or so, we get the message ‘Create operation
… completed successfully’
With a compute instance hana and two disks.
We get the same information if we click our deployment.
OK — Lets take a look at the compute engine, at the VM.
Lets connect with SSH
Very well.
SUSE Linux Enterprise Server 12 SP3
We will probably get disconnected soon as one of the first actions taken is an update
of system parameters followed by a reboot.
To see what’s going on exactly, we can take a look at the logs, here from the menu.
Stackdriver Logging
Load newer logs
There we have it Setting boot parameters.
We should have lost our connection now.
Yep, SSH connection lost.
Let’s return to our logs.
Rebooting.
While the system reboots, let’s scroll up the log file a bit.
Prior to this deployment, I did another one.
Here we have ‘setting boot parameters’ and ‘Rebooting’
Next is kernel parameters, installing operating system packages.
These are all operating system prerequisites that need to be filled before we can start
to install SAP HANA.
The startup script is read from the template and downloaded.
Disk volume sizes are calculated.
No need for any manual sizing, this is all automated.
Then, the volume groups and file systems are created: /hana/shared/, /hana/data and log.
A file system for hanabackup
Sapinit and tuned are configured,
and the installation configuration file created.
We can take a brief look at that file gcloud compute ssh hana (hana is the name of VM) switch
user to root: sudo su -
cat name of hana install cfg
Here we have the installation parameters needed by the installer, the SID, instance number
and passwords.
Note that the password for the SAP host agent user, sapadm, is set to the same value as
the SIDadm user (the template file did not ask us for this parameter) and that autostart
is set to yes, so HANA starts automatically when the system starts.
There are tutorial videos in the SAP HANA platform installation playlist that explain
how automated installations work, so if you are new to this topic, you could take a look.
OK - Let’s see where we are with our current deployment.
OK — making progress.
Downloading HANA Media.
When we run ‘top’, we can see that a python process is doing the download.
Here we have the file systems.
If we ls /hana/shared/media — we can see this in progress.
OK — fast-forward.
Takes about 4 minutes, the download - at least in my zone.
Here we have our files, the script is now extracting the media.
When we run ‘top’, we can see the unrar command being busy.
OK — fast-forward again
Next, we have started the installation of SAP HANA
‘top’ will show us the sdbrun process, the installer.
This will take some time, but eventually, we will start to see the sapstartsrv appear,
starting up the daemon and the hdbnameserver process, the process that hosts the system
database, followed by hdbindexserver, xsengine, compileserver and preprocessor.
Couple of more minutes.
Fast-forward.
Let’s refresh our logs again.
Installation done.
Backup folder is created and the path is set in the HANA ini files.
Instance deployment complete.
Very good.
The hdbpreprocessor may still be very busy at this stage, compiling stuff - but that’s fine.
Let’s exit ‘top’.
Switch user to the SIDadm user, abcadm in my case.
Run the ‘HDB info’ command.
Very good, all the processes are up.
We are done.
Next steps would be to update the passwords for the SAP host agent, the operating system
administration account SIDadm, and for the SYSTEM database users in both the system database
and the tenant database
You probably also want to make the first backup of the database, and so on.
We will look into this in a subsequent video in this series.
Should there have been any issue, maybe a typo in the bucket name of the configuration
file, you can very easily remove the deployment and start again.
Just go to the Deployment Manager and select your deployment and then select Delete.
This will remove all the objects created by this deployment, the VM, the disks, everything.
OK, so much for this single-node deployment.
With a single command,
we have prepared the SUSE Linux operating system, created file systems, downloaded the
installation media, performed an automated installation and post-installation tasks like
backup configuration.
Before, this would take you a whole day.
Not bad.
Not bad, at all.
In the next video, we will do an "under-the-hood", to see how this works.
Thanks for watching.
You can find more video tutorials on our YouTube channel.
If you would like to be informed about new video tutorials, please subscribe to our channel.
You can connect with us on LinkedIn or follow us on Twitter, as well for updates, and if
you are watching this video on YouTube, do not hesitate to leave your comments to the
video page and, if you like, give us your vote on this video.
Thank you for watching.