Hi, my name is Manoj Muthukrishnan
and I am a specialist solutions architect at Amazon Web Services.
Today I’m going to show you how to backup
an SAP HANA database on AWS
using AWS Backint Agent.
During this lab you will see we can complete this
in less than 30 minutes.
Before we begin the installation,
there are three pre-requisites that need to be completed.
The first is to create an S3 bucket where we store the backups.
The second is to make sure we add the necessary permissions
for the SSM Agent and the S3 bucket.
The third is to ensure the EC2 Systems Manager Agent
is running the proper version.
Start by going to S3 and creating a new bucket.
We will call this bucket, ‘hanabackintdemobucket’,
then click ‘Next’.
This is where we can define lifecycle policies to change storage classes.
Once we have finished creating our bucket we can move on.
The second step is to assign the necessary permissions
for the SSM Agent and the S3 bucket setup.
Copy AmazonSSMManagedInstanceCore policy, then go to your console.
Go to the EC2 instance for HANA under running instances.
Select the HANA instance and moved to the IAM role
that is attached to this particular instance.
Under the permissions policies, click ‘Attach policies’.
Filter for AWS SSM Instance Managed Core.
Once it comes up, we can attach it.
Then we want to provide inline policy to access the S3 bucket.
I previously created the JSON talk to provide
the necessary access to this S3 bucket.
Copy and paste this,
review policy.
Go ahead and give this policy a name.
We will name this as HANABACKINT3POLICY and then create the policy.
The third pre-requisite is to make sure the systems manager
is running at, at least version 2.3.274.0.
If your agent is not running at this level,
there are two methods to update the agent.
We can update at Linux level or use AWS
Systems Manager run command.
Go back to your AWS console and go to Systems Manager.
Before you change the agent, check the version level
by looking at the HANA instance.
You can see this run is running at a higher level
than what is necessary to run Backint Agent,
but if you need to update it, go to systems manager,
scroll down, choose ‘run command’.
Select ‘AWS-UpdateSSMAgent’, select the instance you want to update.
Select the instance you want to update.
Here we will click the HANA instance, then go ahead and run that command.
Now we have completed the pre-requisites,
we can move on to install Backint Agent.
There are a few ways to install it,
but the most popular method I use is the Systems Manager document.
The document name is AWSSAP-InstallBackint.
Go to run command, provide AWSSAP-InstallBackint.
Select AWSSAP-InstallBackint document that was created.
Now we will need to enter the parameters.
The first parameter to provide is the name of the bucket
you created in the previous step.
Then we will enter the bucket folder
and if you have multiple HANA instances,
you may want to create separate folders for each of the instances.
In production instance environments,
I would strongly recommend creating separate folders.
Now go ahead and provide the System ID for the HANA instance.
The next step is to choose the bucket region.
This one exists in us-east-1.
The fourth parameter is to enter the bucket owner account ID.
You can find the account ID in this dropdown.
Go to My Account.
It will give you the account ID.
Basically this is the ID for whichever AWS account
is going to own the bucket.
Copy that account ID and enter the account ID
in the bucket owner account ID.
Make sure that there are no additional spaces or anything,
otherwise it can cause the document to fail.
The next parameter is to provide an encryption key
if you want to encrypt your backups.
We will leave this as default.
Moving on we will provide the installation directory
where the Backint Agent is going to be installed.
You can modify it here if necessary,
but again, we will leave this as default.
The next critical step is modify global
Ini file with the Backint parameters.
You can do it manually or select modify.
Once this is provided, ensure no backup is in process.
Select ‘yes’.
If you don’t do this, the Backint Agent will fail.
Then select the target instance manually.
In this case we will select the HANA instance.
Go ahead and run it.
This will take less than 30 seconds now for installation to complete.
We should get a successful status once it is installed
and this completes the installation of the Backint Agent.
Now go to HANA Studio and trigger some backups
to ensure the agent works.
For the backup type you can choose either complete data backup
or differential or incremental,
but for this lab we will do the complete data backup.
Change the destination type to Backint.
You can add different prefix and suffixes for your choice,
but we will again leave this as the default.
Then we can click ‘Next’ and finish.
Now our backup to S3 is running.
In a moment we will see that it is successfully completed.
We will go to the S3 bucket
we created as part of the pre-requisites.
We can see that the backup we triggered was successful.
Let’s go into the backup folder and we have our backup right here.
Now, we should go ahead and trigger one more backup.
To differentiate from the first one, we will call this one as _Second_Run.
We will click ‘Next’ and then finish.
Let’s wait for it to complete.
For larger databases, the backup time will take longer
because they are bigger.
Again, we will wait for the backup to complete and here,
once it is successful, let’s go back to S3
to ensure that it has been completed.
We can see that the second backup is also in our S3 bucket.
This concludes how to configure your backups
using AWS Backint Agent for HANA database
and we were able to complete this in less than 30 minutes.
Thanks for watching.