Backup with 'application aware processing' turn off Postgres & Oralce processing

[phillip_from_oz]

I'm trying to backup a Linux VM (VMWare; SUSE).

This VM has an IRIS DB (Intersystems). Intersystems provides pre-freeze and post-thhaw scripts.

I've been running the backups with 'application aware processing' so I can add the pre-freeze and post-thaw scripts.

However on checking the logs I can see that Veeam tries to install the Postgres agent and Oracle agent.

Is there a way to stop Veeam from running Postgres and Oracle processing for this VM?

The reason is that the Intersystems supplied pre-freeze and post-thaw scripts must be run not too far apart (in time) otherwise the the VM being backed up will be considered by it's mirrored pair VM as 'down'.

The mirror paired VMs exchange "I'm alive" messages.

[PetrM]

Hi Phillip,

Maybe it's worth trying to find a method to fine-tune the logic of sending these "I'm alive" messages instead of increasing risks to get the inconsistent application data in backup? Could you please maybe share a link where I can read more about the requirements for pre-freeze/post-thaw scripts on IRIS database side? Actually, I'm not sure that I fully understand how it's related to Oracle/PostgreSQL processing.

Thanks!

[phillip_from_oz]

Unfortunately the "I'm alive messages" are part of proprietary code of the Intersystems IRIS database.

I can adjust, what Intersystems terms, "Quality of Service" time which affects when the alternate mirror node expects the "I'm alive messages".

You can read about backups and pre-freeze and post-thaw scripts in this url:
https://docs.intersystems.com/irislates ... CDI_backup

We are using the section "External backup"

[PetrM]

Hi Phillip,

The article is very detailed, thank you.

I can adjust, what Intersystems terms, "Quality of Service" time which affects when the alternate mirror node expects the "I'm alive messages".

Seems to be a way to go, isn't it?

Thanks!

[phillip_from_oz]

[07488778]
Thanks for your efforts.

I will keep searching to see if there is a way of turning off Oracle & Postgres processing as I don't use these products on that server.

I also suspect that VSS should not be as well as this is a Linux server

[PetrM]

Hi Philipp,

There is no option to disable it. If you don't use these products, why do you want to disable AAIP? Our rescan logic will not detect Oracle/PostgreSQL environments, and the job will continue to work.

I'm not sure that I fully understand the issue: what exactly is affected by the PostgreSQL/Oracle agents installation? If this operation increases pre-freeze/post-thaw scripts execution time anyhow, then the only workaround is to adjust IRIS QOS time.

Thanks!

[phillip_from_oz]

Thanks for your interest in this issue.

This is the general arrangement in mirror:
N1 - Primary [Active node]
N2 - Backup [Passive node]
Arbiter [Witness server]

N1 sends "I'm alive" messages to N2 and arbiter
N2 sends "I'm alive" messages to N1 and arbiter

N1, N2, Arbiter are VMWare VM
When Veeam backs up N1,
runs pre-freeze script
VMWare snapshot
runs post-thaw script

The pre-freeze script is supplied by vendor.
The pre-freeze script when run flushes all memory buffers to disk.
The pre-freeze script when run stops sending "I'm alive" messages to N2 and arbiter

The post-thaw script is supplied by vendor.
The post-thaw script when run re-starts sending "I'm alive" messages to N2 and arbiter

If there is a large difference in time between the run of the post-thaw script and pre-freeze script
then N2 assumes that N1 has gone down and attempts to take over control. The time that N2 waits is set by
the QOS value.

When post-thaw script gets run on N1 it tries to take control again.
Chaos!

On checking the Veeam logs there is quite a bit of processing Oracle and Postgres between
the run of pre-freeze script and post-thaw script