You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

The data warehouse is a MySQL Enterprise Edition instance located on two servers: prod-dwarehouse01.geant.net (62.40.122.84 - Sofia PoP) and prod-dwarehouse02.geant.net (62.40.122.132 - Athens PoP)

There are Test and UAT versions of the data warehouse, but these only have the MySQL Community Edition installed on them.

Access to the databases is via two user accounts either WhseUser or WhseAdmin (Passwords stored in KeyPass

Currently, data from our core corporate systems are manually exported and imported into the respective databases:

cacti - Cacti configuation tables

md_vpn - MDVPN Monthly Service Report data

nfsen - Old network traffic information data

opsdb - OpsDB data

otrs - OTRS Ticketing System data

poller - Poller configuration tables

reports - Monthly Service Report (MSR) data

sde - Old ticket data

tableau - Ad hoc reporting tables

terraform - Terraform data

And router specific databases created by the Poller system eg. mx1_ams_nl


*** IMPROVEMENT - This data export/import should be automated.


  • No labels