About the document

  • This is a getting started guide to start PISO-Manager on EC2 instance.

    • Start PISO-Manager on EC2 instance from AMI.

    • Configure PISO-TGT setting to point to the launched PISO-Manager.

  • Follow the PISO-Manager installation/setting guide for further details.

Prepare PISO-Manager

Start PISO-Manager on EC2 instance

  • Start EC2 instance with following setting.

    • AMI: (select PISO-Manager AMI at AWS Marketplace)

    • Instance type: over 4 core vCPU and over 8GB RAM. (m5.xlarge is recommended)

    • Storage: 50GB for a monitored instance generally. (See Installation Guide for more details)

      • /dev/sdb: online data

      • /dev/sdc: backup data

    • Security group: ssh, http(7777)

      • PISO-TGT must be able to connect to port 7777 of PISO-Manager

      • Port 7777 is used for Web-UI.

  • Logon to the EC2 instance with 'centos' user.

Setup PISO-Manager

  • Set hostname. For '<HOSTNAME>', you can give it the name you want.

sudo hostnamectl set-hostname --static <HOSTNAME>

  • Recognize expanded volume.
    If you have expanded volume size, you must use file system–specific commands to extend the file system to the larger size.

sudo xfs_growfs -d /mnt/piso-data
sudo xfs_growfs -d /mnt/piso-backup

  • Install
    Select 'en' or 'y' for questions and input license information. For license info., input the provided license password phrase.

su insight
cd ~/piso-manager/
./install/install.sh

....

source ~/.bashrc

Start PISO-Manager

  • Start PISO-Manager.

su insight
istctl uppg
istctl upap
istctl startall

  • Now you can access to PISO-Manager web UI. The URL is 'http://<IP_ADDRESS>:7777/piso/'.
    The default username is 'administrator', and the default password is your EC2 instance id.

Configure PISO-TGT setting to point to the launched PISO-Manager.

Attention

  • Assuming that PISO-TGT has already been installed on your DB server.

  • Follow PISO-TGT installtion guide for more details to install and configure PISO-TGT on your DB.

Configure PISO-TGT

  • Stop PISO-TGT process

istctl downistcmon
istctl stopall

  • Setup PISO-TGT to connect to PISO-Manager. Be sure that PISO-Manager’s securiy group is set up for connectted from PISO-TGT. (tcp/7777).

istctl setconfig

  • Set PISO-Manager IP address

    • Select 'STEP 1 Setup ISM'

      • Set IP Address of PISO-Manager.

      • Set 'C' for LANG.

      • Leave other information.

    • Select 'STEP 4 Register ISM'

  • Start PISO-TGT.

istctl upistcmon
istctl startall

  • Check PISO-TGT service status. (All processes must be runnging.)

istctl status

Configure PISO SQL collection

  • Confiugre PISO SQL collection and alert setting at PISO-Manager Web-UI.

    • Follow PISO-Manager setting guide for details.

  • After the configuration, database activities on the target database will be monitored.