[모니터링] Zeppelin 호출

JDBC, psql 설정

jdbc:postgresql://xx.xxx.xx.xxx:5432/engine (DB이름)

Shell

%sh
export LANG=C
PGPASSWORD=xxxxxxxx psql engine -h xx.xxx.xx.xxx -U kbn << EOF
SELECT vm_name FROM vms
where vm_name not like '%down%'
and vm_name not like '%temp%'
\q
EOF

JDBC

%jdbc
SELECT vm_name, usage_cpu_percent FROM vms
WHERE vm_name not like '%down%'
AND vm_name not like '%temp%'
ORDER BY usage_cpu_percent DESC;

Interpreter

Interpreter → Create → 정보입력 → New Create Notebook → 설정에서 binding을 해야 다른 interpreter를 가지고 올 수 있음

python input box

%python
import os
A = z.input("RHEVM", " ")
if "shell" == A:
    os.system('uname -n')
else:
    print "example) rhevm1, rhevm2, rhevm3 input"

print A

python check box

%python
options = [("apple","Apple"), ("banana","Banana"), ("orange","Orange")]
print("Hello "+ " and ".join(z.checkbox("fruit", options, ["apple"])))


python select box
print("Hello "+z.select("day", [("1","mon"),
                                ("2","tue"),
                                ("3","wed"),
                                ("4","thurs"),
                                ("5","fri"),
                                ("6","sat"),
                                ("7","sun")]))

python psql execute

%python
import subprocess
CMD =  subprocess.call('export PGPASSWORD="!imsida7"; psql -h "xx.xxx.xx.xxx" -U "kbn" -d "engine" -c "select vm_name from vms;"', shell = True)
print CMD

python query 변수 처리

%python
import subprocess as S

CMD1_1 = 'psql -U postgres -d rhevm1 -c "SELECT A.HOST_OS, A.VDS_GROUP_NAME, A.HOST_NAME, A.HW_MANUFACTURER, A.HW_PRODUCT_NAME, A.CPU_MODEL, A.CPU_SOCKETS, A.CPU_CORES, A.PHYSICAL_MEM_MB, C.VM_ENTITY_TYPE, B.VM_NAME, B.VM_IP, B.num_of_cpus, B.VM_MEM_SIZE_MB, B.GUEST_OS FROM VMS AS B INNER JOIN VDS as A ON A.VDS_GROUP_NAME = B.VDS_GROUP_NAME INNER JOIN vm_interface_view as C ON C.VM_NAME = B.VM_NAME WHERE B.VM_NAME NOT LIKE \'%%down%%\' AND B.VM_NAME NOT LIKE \'%%temp%%\'" | tr "|" "\t" | grep -v "rows" | grep -v "+"'
CMD1_2 = S.Popen(CMD1_1, stdout=S.PIPE, stderr=S.PIPE, shell=True)
(output, err) = CMD1_2.communicate()
A = output


print "%table"
print("Hello "+z.select("day", [(A,"RHV1"),
                                (B,"RHV2"),
                                ("3","wed"),
                                ("4","thurs"),
                                ("5","fri"),
                                ("6","sat"),
                                ("7","sun")]))