How do I add a database to a mirror

Question

Question

Phillip Wu · Jan 20, 2023

#InterSystems IRIS

I want to add a database to a mirror.

Is this the correct way to do so:

set status=##Class(SYS.Mirror).AddDatabase("/db/iknow")

Is the status=0 if it worked and anything else means it failed?

Thanks for any help

Product version: IRIS 2020.2

Discussion (10)2

Log in or sign up to continue

Eduard Lebedyuk · Jan 20, 2023

Assuming you have a sync mirror established, adding new db to mirror is as simple as:

Create DB on Primary.
Run SYS.Mirror:AddDatabase. It returns %Status, check that it's ok with $$$ISOK(sc). It should be equal to 1.
Dismount database on Primary (using SYS.Database:DismountDatabase) OR Freeze IRIS (Backup.General:ExternalFreeze).
Copy IRIS.DAT to Backup.
Mount database on Primary (using SYS.Database:MountDatabase) OR Thaw IRIS (Backup.General:ExternalThaw).
Mount database on Backup.
Activate database on Backup (SYS.Mirror:ActivateMirroredDatabase).
Catchup database on Backup (SYS.Mirror:CatchupDB).

Please note that some methods accept db name, most accept db directory, and others db sfn. Please keep that in mind.

3 1

score 0 · Answer 1 · 2023-01-20T12:18:29-05:00

Phillip Wu · Jan 20, 2023

Thanks for the fast reply

0 0

score 0 · Answer 2 · 2023-01-20T12:51:23-05:00

set status=##Class(SYS.Mirror).AddDatabase("/db/iknow")

I get a syntax error when I do:
IF $$$ISOK(status) {w "OK"} else {w "not OK"}

Although this works OK:
IF status {w "OK"} else {w "not OK"}

Any idea why this is so?

score 0 · Answer 3 · 2023-01-20T13:11:50-05:00

I get a syntax error when I do:

Are you doing this in console/terminal? Macros are not available there.

To check if you got an error in a terminal execute:

if sc=1 {w "OK"} else {w $system.Status.DisplayError(sc)}

score 0 · Answer 4 · 2023-01-20T13:16:20-05:00

Phillip Wu · Jan 20, 2023

I was running this from terminal - understood.

Thanks again.

0 0

score 0 · Answer 5 · 2023-01-24T15:11:46-05:00

Phillip Wu · Jan 24, 2023

Sorry, what is 'db sfn'?

0 0

score 0 · Answer 6 · 2023-01-25T01:28:01-05:00

Vitaliy Serdtsev · Jan 25, 2023

SFN - system file number

0 0

score 0 · Answer 7 · 2025-05-05T14:46:29-04:00

Is there a way to avoid copying iris.dat? That is, can the two databases be created separately and then set up as mirrored?

score 0 · Answer 8 · 2025-05-06T11:05:48-04:00

Well, I have great news for you, Otto!

Starting from 2025.1, we have automatic database download from mirror member. Documentation. No copying required.

score 0 · Answer 9 · 2025-06-06T08:38:54-04:00

I dismounted, secure copied the IRIS.dat to my backup/DR and mount the Database, but when I attempt to Activate Mirror Database on the backup, I am getting the following error...

sc="0 "_$lb($lb(2073,"/ensemble/TEST/DB/TESTING/",,,,,,,,$lb(,"%SYS",$lb("e^ActivateMirroredDatabase+3^SYS.Mirror.1^2","e^^^0"))))/* ERROR #2073: Mirrored Database '/ensemble/TEST/DB/TESTING/' is not found on this system */

but it shows that the database has been mounted in the Terminal.