Hello and welcome to the SAP HANA Academy.
I am Denys van Kempen,
and the topic of this video tutorial series
is SAP HANA 2.0 new features.
In this video tutorial
we will discuss:
what’s new for administration.
In the previous two videos about administration
we talked about both system administration,
and database backup and recovery.
The topic of this video is high availability.
What’s New in the SAP HANA platform 2.0
is documented in the Release Notes,
the What’s New guide,
and for high availability
the three topics mentioned
all concern system replication.
First we got the read enabled,
active/active
operation mode
and because of this active/active mode
to setup replication
a new configuration step is required,
which involves the HANA safe
for internal communication,
the system PKI SSFS;
we will get to it in a minute,
and finally,
there is the new HANA cockpit, of course.
We have seen in the previous videos
that the whole architecture has changed,
but also, and this is relevant for replication,
we can now perform the initial setup,
monitor the status of system replication,
perform a takeover
and execute the failback again,
and finally, disable replication.
We can do all this using the HANA cockpit,
so there is no need to take out the command line tools
for this any more.
So, let’s take a look.
Here we have our cockpit.
I will connect first to the primary system.
This will be your main production box
and then here,
under monitoring and administration,
we have a tile for system replication.
As you can see,
system replication has already been setup.
All services are active and in sync.
We have our primary site in Amsterdam
The operation mode is log replay, read access.
That’s the new mode with HANA 2
that allows for read access to the secondary site,
great for reporting
and the replication mode we are using is synchmem,
no changes here.
Now for those not familiar with the different replication modes,
there is a playlist on the HANA Academy
about system replication,
and here you will find both the concepts and
how to configure system replication explained.
We will be adding new videos for HANA 2.0 pretty soon.
When I open the tile, we get a monitoring view.
Replicated services shows the status per service.
So if I click indexserver, for example,
we get all the statistics about this service:
log position,
savepoints,
full data replica,
delta data replica, if any,
and the backlog,
and then on the monitoring view
we also get some nice graphs about
log buffer write times
and the log replay on tier 2.
Here is the link to disable system replication.
Again, works the same as on the command line
but now it is web-enabled
and if we return to our home screen,
and select our secondary system,
we can see on the system replication tile
that Schiphol now is the green cube.
All services are active.
Select the tile
and from here you can perform the take over,
so you switch production from the primary
to the secondary system.
From the Amsterdam data center,
because there is too much smoke,
to Schiphol.
Again, we will cover this in a dedicated video on the topic,
here I am just showing you what’s new.
If we then return to the cockpit home page and open the database explorer,
you can see that we can connect to both systems.
But if we tried to create any objects or do any insert,
we get an error:
feature not supported,
writable statement not allowed in read-only replication.
OK,
let's return to our What’s New guide,
high availability,
we talked about active/active read enabled,
we looked at the cockpit:
monitoring,
disabling, take over - all straight forward.
Let’s briefly look at the setup.
When you just get started
connect to the cockpit and open the replication tile.
Now you can see that
replication has not been enabled yet.
Then select the link
‘Configure System Replication’.
Give the site a name
and select Configure,
and then in the background the hdbnsutil command line tool
will be executed with the flag
SR enable,
just like previously.
Then return to the cockpit
and connect to the secondary system.
Here, of course,
system replication has also not been enabled yet.
The secondary system must be stopped
and there are a couple of more prerequisites,
one of which is documented here in the What’s New guide
and in note 23 69 981
Required configuration steps for authentication with HANA System Replication.
You need to copy over the secure store and key file
from the primary
to the secondary system
and you can use the
scp, secure copy command,
for this,
and then just select
Register Secondary System.
Enter the site name,
this is the alias,
your data center location number 2, for example,
the replication mode,
the operation mode,
and the host of the source system.
Then select Configure
and we are done.
It is that simple.
OK, so much for
what’s new for administration
with SAP HANA 2.0,
part 3, high availability
and system replication.
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 we also have a page on Facebook
and Google+.
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.