Category Archives: All

Tigergraph Installation with Docker

Let’s Connect, Analyze, and Learn from Data.!

TigerGraph is the world’s fastest graph analytics platform designed to unleash the power of interconnected data for deeper insights and better outcomes. The company supports applications such as IoT, AI, and machine learning to make sense of ever-changing big data.

TigerGraph’s massively parallel processing (MPP) architecture combined with an efficient query processing engine allow for analyzing entities and their relationships at scale. TigerGraph is fully ACID compliant, giving the ability to perform both transactional and analytic workloads on the same platform. As with data lakes, TigerGraph’s scalability and flexible schema allow the joining of diverse data sets.

This is my first time using and install the Tiger Graph. Prerequisites, my local setup:

-macOS Catalina 10.15.7

-Docker Desktop 3.6.0 on Mac

TigerGraph Enterprise Edition docker image

Step 1: Install Docker on Mac follow this link.

Step 2: Open Terminal on your Mac and follow these steps:

-Prepare a Shared Folder on Host OS to be shared with Docker Container:

henrygultom@MacBook-Pro ~ % mkdir tigergraph
henrygultom@MacBook-Pro ~ % cd tigergraph
henrygultom@MacBook-Pro tigergraph % mkdir data
henrygultom@MacBook-Pro tigergraph % chmod 777 data
henrygultom@MacBook-Pro tigergraph % ls
data

-Run TigerGraph Docker image as a daemon:

henrygultom@MacBook-Pro tigergraph % docker run -d -p 14022:22 -p 9000:9000 -p 14240:14240 –name tigergraph –ulimit nofile=1000000:1000000 -v ~/tigergraph/data:/home/tigergraph/mydata -t docker.tigergraph.com/tigergraph:latest
Unable to find image ‘docker.tigergraph.com/tigergraph:latest’ locally
latest: Pulling from tigergraph
528184910841: Pull complete
8a9df81d603d: Pull complete
636d9303bf66: Pull complete
672b5bdcef61: Pull complete
5d1235f9b296: Pull complete
819f1e6e507e: Pull complete
Digest: sha256:4f16402f6cece37de98911ff286d4b6c996e7a7dab0cab996f36a77ede304010
Status: Downloaded newer image for docker.tigergraph.com/tigergraph:latest
b3f33c6f7d7591b8c0a5a2fe13e94f37d48a55eb643171002357110ae1c40332
henrygultom@MacBook-Pro tigergraph %
henrygultom@MacBook-Pro tigergraph % docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
b3f33c6f7d75 docker.tigergraph.com/tigergraph:latest “/bin/sh -c ‘/usr/sb…” 48 minutes ago Up 48 minutes 0.0.0.0:9000->9000/tcp, :::9000->9000/tcp, 0.0.0.0:14240->14240/tcp, :::14240->14240/tcp, 0.0.0.0:14022->22/tcp, :::14022->22/tcp tigergraph
henrygultom@MacBook-Pro tigergraph %

henrygultom@MacBook-Pro tigergraph % uname -a
Darwin MacBook-Pro.local 19.6.0 Darwin Kernel Version 19.6.0: Tue Jun 22 19:49:55 PDT 2021; root:xnu-6153.141.35~1/RELEASE_X86_64 x86_64
henrygultom@MacBook-Pro tigergraph %

-Use SSH to connect to your container:

henrygultom@MacBook-Pro tigergraph % ssh -p 14022 tigergraph@localhost
The authenticity of host ‘[localhost]:14022 ([::1]:14022)’ can’t be established.
ECDSA key fingerprint is SHA256:yxJX13+vAPeEMuhhUE6Ni0qVMGzeUzci29Buv7qvZ6U.
Are you sure you want to continue connecting (yes/no/[fingerprint])? yes
Warning: Permanently added ‘[localhost]:14022’ (ECDSA) to the list of known hosts.
tigergraph@localhost’s password:
Connection closed by ::1 port 14022
henrygultom@MacBook-Pro tigergraph %
henrygultom@MacBook-Pro tigergraph % ssh -p 14022 tigergraph@localhost
tigergraph@localhost’s password:
Welcome to Ubuntu 16.04.7 LTS (GNU/Linux 5.10.47-linuxkit x86_64)

* Documentation: https://help.ubuntu.com
* Management: https://landscape.canonical.com
* Support: https://ubuntu.com/advantage
tigergraph@b3f33c6f7d75:~$

-Start TigerGraph:

tigergraph@b3f33c6f7d75:~$ gadmin start
[ Info] If no serviceID is specified, it only starts services excluding the infrastructure. Use ‘gadmin start all’ to start all services.
[ Info] Starting ZK ETCD DICT KAFKA ADMIN GSE NGINX GPE RESTPP KAFKASTRM-LL KAFKACONN TS3SERV GSQL TS3 GUI
[ Error] ConnectionClosed (Unable to talk to ctrl, are all infrastructure services up? You can start them by ‘gadmin start infra’)
tigergraph@b3f33c6f7d75:~$
tigergraph@b3f33c6f7d75:~$ gadmin start all
[ Info] Starting EXE
[ Info] Starting CTRL
[ Info] Starting ZK ETCD DICT KAFKA ADMIN GSE NGINX GPE RESTPP KAFKASTRM-LL KAFKACONN TS3SERV GSQL TS3 IFM GUI
tigergraph@b3f33c6f7d75:~$


tigergraph@b3f33c6f7d75:~$
tigergraph@b3f33c6f7d75:~$ gsql
Welcome to TigerGraph.
GSQL > show v
vertex values var
GSQL > alter
alter
GSQL > alter
alter
GSQL > ls
—- Global vertices, edges, and all graphs
Vertex Types:
Edge Types:

Graphs:
Jobs:

JSON API version: v2
Syntax version: v1

GSQL > quit


tigergraph@b3f33c6f7d75:~$
tigergraph@b3f33c6f7d75:~$ ls
gsql-graph-algorithms mydata tigergraph tutorial
tigergraph@b3f33c6f7d75:~$ cd tutorial
tigergraph@b3f33c6f7d75:~/tutorial$ ls
2.x 3.x
tigergraph@b3f33c6f7d75:~/tutorial$
tigergraph@b3f33c6f7d75:~/tutorial$ cd 2.x/
tigergraph@b3f33c6f7d75:~/tutorial/2.x$ ls
gsql101 gsql102
tigergraph@b3f33c6f7d75:~/tutorial/2.x$ cd gsql101
tigergraph@b3f33c6f7d75:~/tutorial/2.x/gsql101$ ls
friendship.csv gsql101.gsql person.csv README.md
tigergraph@b3f33c6f7d75:~/tutorial/2.x/gsql101$ vim README.md
tigergraph@b3f33c6f7d75:~/tutorial/2.x/gsql101$

tigergraph@b3f33c6f7d75:~/tutorial/2.x/gsql101$ gsql gsql101.gsql
Dropping all, about 1 minute …
Abort all active loading jobs
Resetting GPE…
Successfully reset GPE
Stopping GPE GSE
Successfully stopped GPE GSE in 0.495 seconds
Clearing graph store…
Successfully cleared graph store
Starting GPE GSE RESTPP
Successfully started GPE GSE RESTPP in 0.075 seconds
Everything is dropped.
The vertex type person is created.
The edge type friendship is created.
Stopping GPE GSE RESTPP
Successfully stopped GPE GSE RESTPP in 17.650 seconds
Starting GPE GSE RESTPP
Successfully started GPE GSE RESTPP in 0.071 seconds
The graph social is created.
Semantic Check Fails: File or directory ‘$HOME/tutorial/gsql101/person.csv’ does not exist!
Semantic Check Fails: The FILENAME = ‘m1:/home/tigergraph/tutorial/gsql101/person.csv’ is not in a valid path format.

The job load_social could not be created!
tigergraph@b3f33c6f7d75:~/tutorial/2.x/gsql101$
tigergraph@b3f33c6f7d75:~/tutorial/2.x/gsql101$

tigergraph@b3f33c6f7d75:~/tutorial/2.x/gsql101$ gsql version
GSQL version: 3.1
GSQL commit number: 06c9098c895d88a30daf3ee307a428ee38f0a7b4
GSQL commit date: 2021-07-19 09:18:25 -0700
Copyright (c) 2014-2021 TigerGraph. All rights reserved.
This product is protected by U.S. and international copyright and intellectual property laws.
tigergraph@b3f33c6f7d75:~/tutorial/2.x/gsql101$

Continue – next tutorial:  https://docs.tigergraph.com/start/gsql-101/parameterized-gsql-query

Mewujudkan kawasan Danau Toba berstatus zero blankspot akses internet

Saya diundang menjadi pembicara narasumber untuk acara Webinar dengan topic “Mewujudkan kawasan Danau Toba berstatus zero blankspot akses internet”

Kaldera Toba atau yang lebih dikenal sebagai Danau Toba ditetapkan sebagai UNESCO Global Geopark pada Sidang ke-209 Dewan Eksekutif UNESCO di Paris, Prancis (2/7/2020).

Ada 24 titik blankspot internet tersebar di 9 kecamatan di Kawasan Danau Toba. Mau menunggu tahun 2024, terlalu lama rasanya.

#kominfo
#bakti
#kemenparekraf
#telkomsel4g

#danautoba #samosir #palaparingbarat #googleballoon #thecalderatobanomadicescape

Contact me: henry.gultom@gmail.com

Membuat dashboards di Azure portal

Jika sudah memiliki subscription di Azure portal dan kita memiliki virtual machine yang sudah kita setup didalamnya makan kita dapat menbuat Dashboards yang dapat melihat cloud resources secara terorganisasi dan fokus.  Dengan dashboards ini menjadi workspace kita dapat mengakses task operasional setiap hari dan memonitor resources.

Pada Azure portal kita bisa mengcustom dahsboard tersebut dan mempublish serta share dengan pengguna lain. Berikut cara untuk memulainya :

  1. Login ke Azure portal : https://portal.azure.com
  2. Pada menu dropdown sebelah kiri Azure portal, pilih Dashboard.Azure Portal menu dropdown
  3. Di dashboard panel, pilih New dashboard dan Blank dashboard.New dashboard
  4. Kita ketik nama dashboard yang kita inginkan.
  5. Pada bagian Tile Gallery ada berbagai macam pilihan add ons yang bisa kita drag and drop ke sisi kanan dashboard, bisa diexplore lebih lanjut.
  6. Contoh kita mau memasukkan Avg Percentage CPU untuk salah satu virtual machine kita.
    1. Klik Home pada Azure portal lalu pilih Virtual machine(VM) dan nama VM yang sudah kita definisikan.
    2. lalu pilih Metrics dan pilih AVG Percentage CPU
    3. lalu pilih Pin to dashboard.

 

 

Selamat Bu Khofifah, Gubernur Jatim 2019-2024

Ada rasa bangga melihat Presiden Joko Widodo (Jokowi) resmi melantik Khofifah Indar Parawansa-Emil Elestianto Dardak sebagai pasangan gubernur dan wakil gubernur Jawa Timur (Jatim) periode 2019-2024. Sebagai salah satu tim IT/Medsos/War Room di timses beliau,  ikut membantu kurang lebih 6 bulan memenangkan beliau dalam pilgub Jatim 2018.

Selamat Bu! Semoga amanah dan berkah untuk rakyat Jawa Timur.

https://news.detik.com/berita/d-4426544/jokowi-resmi-lantik-khofifah-jadi-gubernur-jawa-timur

 

System Big Data memverifikasi data DPS Pilgub Jatim 2018

Menjelang pilgub Jatim 2018, ada Data Daftar Pemilih Sementara dalam bentuk Excel. File ini saya olah dan analisa dengan memanfaatkan teknologi Big Data, untuk mengolah data besar calon pemilih. Penyusunan Daftar Pemilih merupakan salah satu tahapan yang terpenting dalam persiapan Penyelenggaraan Pemilu. Bagus juga ada input untuk memverifikasi dari data pemilih sementara. Sama-sama membantu untuk kebaikan bersama.

Hal ini dapat dilihat masih banyaknya pada DPT :
1.Data pemilih invalid
2.Data pemilih ganda
3.Manipulasi data pemilih
4.Data pemilih fiktif

Kita merubah proses pengecekan data yang melelahkan menggunakan Excel dan pengecekan manusia. Menjadi proses automatis menggunakan system Big Data :

Hasil temuan ini dapat menjadi masukan untuk perbaikan dalam pemutakhiran data pemilih tetap.

 

Melihat pekerjaan IT yang kulakukan selama di Lagos, Nigeria (Part 2)

Pekerjaanku sebagai system engineer di sebuah perusahaan di Lagos Nigeria memiliki task :

Scope of work:

·Maintain integrity and operational suitability of all servers
·Develop applications, system tools and lead all network system integration projects
·Back-up/restore/develop all system applications and databases
·Troubleshoot all application-related issues
·Other task assigned by line manager

Berikut foto2nya :

Melihat pekerjaan IT yang kulakukan selama di Lagos, Nigeria (Part 1)

Pekerjaanku sebagai system engineer di sebuah perusahaan di Lagos Nigeria memiliki task :

Scope of work:

·Maintain integrity and operational suitability of all servers
·Develop applications, system tools and lead all network system integration projects
·Back-up/restore/develop all system applications and databases
·Troubleshoot all application-related issues
·Other task assigned by line manager

Berikut foto2nya :