Question Phillip Wu · Aug 31, 2022

Hi,

I have this arrangement of mirror

Node 1: Primary

Node 2: Failover

Async member is DR server

There is also an arbiter on another server

I want to make 'Node 2' primary as 'Node 1' is to be taken down for some scheduled maintenance work.

I know that I can issue 'iris stop' on 'Node 1' and 'Node 2' should takeover as Primary.

Questions

1. Is this a reliable recommended way? I have had cases in the past when the Failover node did not take over as Primary

2. Is there a better way of promoting Failover to Primary?

4
0 306
Question Phillip Wu · Aug 7, 2022

I’m a complete novice with ObjectScript.

I’m trying to write some Object Script directly into command line interface on Linux using some examples on the internet

sudo -u irisowner iris session SCRTC

Username: superuser

Password: ************

AUMHSCRTC:USER>a SET x=1

AUMHSCRTC:USER> WHILE x<10 {

AUMHSCRTC:USER> WRITE !," Looping",x

AUMHSCRTC:USER> SET x=x+1

AUMHSCRTC:USER> }

AUMHSCRTC:USER> WRITE !,"DONE"

AUMHSCRTC:USER>do a

 Looping1

 Looping2

 Looping3

 Looping4

 Looping5

 Looping6

 Looping7

 Looping8

 Looping9

DONE

That seems to work!

How if I put these commands into a file:

cat > /tmp/a.scr

superuser

xyz

a SET x=1

 

16
0 634
Question Phillip Wu · Aug 5, 2022

I want to get Mirror Status and copy this report into a file for audit purposes.

I have a Linux servers for IRIS DB with this layout:
LIVETC01           Backup
LIVETC02           Primary
LIVEDR             Async Copy
ARBITER

I understand that this will get me the mirror status
# sudo -u irisowner iris session LIVETC01
LIVETC01:USER>zn "%SYS"
LIVETC01:%SYS>do ^MIRROR

1) Mirror Status
2) Mirror Management
3) Mirror Configuration

Option? 1

1) List mirrored databases
2) Display mirror status of this node
3) Display journal file info
4) Status Monitor

Option? 4
Status of Mirror LIVETC at 14:25:22 on 08/05/2022
Incomin

6
0 675
Question Phillip Wu · Jul 27, 2022

Hi,

I have a question about deleting journals at the OS level(Linux) without corrupting the IRIS DB or it’s mirror copies.

The reason for deleting journals is the filesystem it lives on frequently fills up. 

I don't have enough disk space to further expand the journal filesystems.

When the journal filesystem fills up then the application stops.

I have the following IRIS nodes(mirror status)

LIVETC01            Backup

LIVETC02            Primary

LIVEDR                Async Copy        **OFFLINE**

ARBITER

LIVEDR is currently offline but IRIS software has been installed.

I checked inside Mirror Monitor

5
0 972
Question Phillip Wu · Jul 17, 2022

I did a google search for 'Grafana' and 'IRIS Health'.

This gave these candidates:

https://github.com/caretdev/grafana-intersystems-datasource
https://community.intersystems.com/post/using-grafana-directly-iris
https://grafana.com/grafana/dashboards/14869

Does anyone know which one is 'best'?
If you have used any of these, do you have any detailed instructions on how to install?
Most of these packages assume you know how to install and run them and so are very light on how to install.

I'm using Grafana on a Windows platform (without the use of docker)

1
0 478