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 Password Manager.)

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