Configuring multistreaming with third-party backup tools
By default, multistreaming is disabled, which means that SAP HANA uses a single channel for data backups and delta backups. If required, you can configure SAP HANA to use additional channels. When multiple channels are used, SAP HANA distributes the data equally across the available channels. All the parts of a multistreamed backup are approximately the same size.
Multistreamed data backups are configured individually for each database.
Note:
To create multistreamed data backups and delta backups of an SAP HANA database, the third-party backup tool must also be configured to use multiple channels. To get optimal performance, ensure that the third-party backup tool is configured correctly.
For more information about the configuration of the backup tool, consult the vendor documentation.
To enable multistreaming
- To enable multistreaming for data backups and delta backups, configure the parameters parallel_data_backup_backint_channels and parallel_data_backup_backint_size_threshold for each database. The parameters are in the backup section of global.ini.
- Specify the appropriate values for each service.
parallel_data_backup_backint_channels - Specify the number of channels to be used for multistreaming.
You can specify a value between 1 and 32. The maximum number of channels permitted for each service is 32.
The default value is 1.
A value of 1 means that data backups with third-party backup tools are created through a single channel. This disables multistreaming. To enable multistreaming, specify a value greater than 1.
Note:
Each additional channel requires an additional IO buffer (by default, 512 MB). Ensure that increasing the number of channels does not have a negative impact on memory consumption.
If backup encryption is enabled, three additional IO buffers are needed for each channel.
parallel_data_backup_backint_size_threshold - Specify the minimum data backup size for multistreaming to be enabled. The value is specified in GB.
You can specify a value of 1 GB or more.
The default value is 128 GB.
The threshold applies to each service individually. If the data backup size for a service is below the threshold, that service will not be multistreamed, even if multistreaming is enabled (parallel_data_backup_backint_channels > 1).
- (Optional) Ensure that all buffers fit into memory. You can optimize the configuration of the following parameters:
Reduce the backup buffer size.
Reconfigure data_backup_buffer_size.
Reduce the number of channels.
Reconfigure parallel_data_backup_backint_channels.
- Save.
The changes take effect immediately.