Execute method on failover member (mirror)

I need to know what options exist to execute methods on the failover members of a mirror system from the primary.

  • 0
  • 0
  • 134
  • 2
  • 2

Answers

The primary practical difference is that the mirror backup databases are mounted read-only, so any methods you might run on a mirror backup can't make changes to the database(s).

Can you provide any additional detail as to what you're trying to do?

as Jeff mentioned: the Shadowed DB is Read Only.

Execution of some code in a remote instance of Caché is independent of Mirror or not

  • Either pack your code (or its call) into a ClassMethod with a return value.
    mark the Method as  [SqlProc ]
    trigger it by SELECT my.procedure()
  • Or wrap it into some WebService ( REST, SOAP) and execute it that way. 

I know that the mirrored DB's are in read-only.

With the SqlProc sollution, how do I execute the call from the primary to the secondary? Using ODBC?

Thank you

Yes.  Connect to Mirror using SQLgateway.
Link Procedure And then just to a SELECT or CALL.
The code has, of course, to be prepared already on Mirror.