postgres enterprise manager 5.0
TRANSCRIPT
Postgres Enterprise Manager 5.0
Gabriel Gyori - ELOS Technologies, s.r.o.
http://www.elostech.cz
25. 4. 2015
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 1 / 21
Obsah
Obsah prezentacie
Obsah prezentacie
Postgres Enterprise Manager - uvod
Architektura
Podporovane operacne systemy
Graficka administracia databaz
Monitoring vykonu databaze
Planovanie kapacıt
Sprava logov
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 2 / 21
Postgres Enterprise Manager PEM
Postgres Enterprise Manager
GUI pre administraciu databaze
IDE pre SQL, graficky debugger
monitorovanie vykonu
raidenie upozornenı
planovanie kapacıt
SQL profilovanie
analyza databaze
sprava logov
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 3 / 21
Postgres Enterprise Manager PEM
PEM server, agent, client
PEM server
spracovanie udajov prijatych od agentovudrziavanie informacii o databaze
PEM agent
zber statistickych udajov o databazezber statistickych udajov o OSzodpovedny za plnenie uloh na manzovanej databaze
PEM client
Graficke rozhranie pre zobrazovanie nazberanych udajov
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 4 / 21
Postgres Enterprise Manager Operacne systemy
Operacne systemy
PEM/OS Windows 32/64 Linux 32/64 Solaris HP-UX
Server • •Client • •Agent • • • •
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 5 / 21
Postgres Enterprise Manager Graficka administracia databaz
Graficka administracia databaz
zmeny konfiguracnych parametrov
manazment uctov, bezpecnosti
tvorba a udrzba novych databaz
zadavanie SQL kodu v jednoduchomeditore
kontrola vykonu databaze
zaloha a obnovenie databaze
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 6 / 21
Postgres Enterprise Manager Graficka administracia databaz
Graficka administracia databaz
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 7 / 21
Postgres Enterprise Manager Graficka administracia databaz
Graficka administracia databaz
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 8 / 21
Postgres Enterprise Manager Graficka administracia databaz
Graficke IDE
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 9 / 21
Postgres Enterprise Manager Graficka administracia databaz
Graficke IDE
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 10 / 21
Postgres Enterprise Manager Monitoring vykonu databaze
Monitoring vykonu databaze
vseobecne analyzy servera
analyza databaze
analyza pamate
analyza I/O
analyza ulozneho priestoru
analyza objektov
analyza vykonu operacneho systemu
analyza cakania systemu
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 11 / 21
Postgres Enterprise Manager Monitoring vykonu databaze
Vyuzitie zdrojov HDD
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 12 / 21
Postgres Enterprise Manager Email alerting
Email alerting
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 13 / 21
Postgres Enterprise Manager Planovanie kapacıt
Planovanie kapacıt
ake mnozstvo ulozneho priestoru budedatabaza potrebovat’ za urcity cas
ako rychlo databaza rastie
ktore objekty su zodpovedne za rastdatabaze
bude moj server schopny zvladnut’ d’alsıobjekt
vykon databaze rastie, klesa, jekonstantny
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 14 / 21
Postgres Enterprise Manager Sprava logov
Sprava logov
vsetky/zlyhane pripojenia k databazi
odpojenia z databaze
vsetky dotazy (SELECT)
DDL dotazy (CREATE, DROP ...)
DML dotazy (INSERT, UPDATE ...)
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 15 / 21
Postgres Enterprise Manager Sprava logov
Sprava logov
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 16 / 21
Postgres Enterprise Manager Audit
Audit logov
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 17 / 21
Postgres Enterprise Manager Automaticke vyhl’adanie spravovanych databaz
Automaticke vyhl’adanie spravovanych databaz
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 18 / 21
Postgres Enterprise Manager SQL Profiling
SQL Profiling
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 19 / 21
Postgres Enterprise Manager Report Postgres Expert
Report Postgres Expert doporucenı
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 20 / 21
Postgres Enterprise Manager Report Postgres Expert
Dakujem za pozornost’
Gabriel Gyori (ELOS Technologies) PEM 25. 4. 2015 21 / 21