Question Adam Raszkiewicz · Sep 6, 2023

How to mirror DB between two VMs using APIs?

Is it possible to configure mirror of the DB between two VMs using APIs like that one? I assume, based on the description, it can be done but on the same instance but I'm not sure how to do that for two separate VMs. I know how to use IRIS portal and set up Mirrored Members connections but now trying to automate that process.

Thanks!

Comments

Pietro Montorfano · Sep 7, 2023

Hi,
as always you can, but it's quite complex.

in order you should:

  1. create the db on server 1
  2. add it to the mirror
  3. backup the db on server1
  4. restore the db on server2
  5. bring it online
  6. do the catchup on server2

Everything is scriptable, but it can be complex because it involves 2 servers

0
Eduard Lebedyuk  Sep 7, 2023 to Pietro Montorfano

I usually dismount and copy for 3, 4.

0