You are browsing a read-only backup copy of Wikitech. The live site can be found at wikitech.wikimedia.org

Analytics/Systems/Cluster/Mysql Meta

From Wikitech-static
< Analytics‎ | Systems‎ | Cluster
Revision as of 12:23, 11 July 2019 by imported>Elukey
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

The Analytics Mysql Meta instance is a Mariadb database currently running on the Analytics Hadoop coordinator host (an-coord1001), that hosts some low volume db schemas related to Hadoop tools like Hive, Oozie, Druid, etc..

Databases

MariaDB [(none)]> show databases;
+-----------------------------------+
| Database                          |
+-----------------------------------+
| druid                             |
| druid_public_eqiad                |
| hive_metastore                    |
| hue                               |
| oozie                             |
| superset_production               |
| superset_staging                  |
+-----------------------------------+

Dependent services

The Mariadb instance collects metadata about the following systems:

Backup

All the databases are periodically backed up in /srv/backup/mysql/analytics-meta on the Analytics Hadoop Master Standby (an-master1002).