Handling Disaster Recovery Plan (DRP)

Context

You may have a DRP that includes having a backup platform on which a new Indexima cluster will temporarily run.

If you synchronize your data using a SYNCHRONIZE command, you have to change the source of the indexima table

This means:

you are in the position CREATE my_table FROM JDBC “my_Original_Jdbc_Connection”

and you want CREATE my_table FROM JDBC “my_Backup_Jdbc_Connection”

How to

This can be done using the following command

ALTER TABLE my_table SET SYNCHRONIZE FROM my_Backup_table IN "my_Backup_Jdbc_Connection"