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

Analytics/Systems/Cluster/Mysql Meta

From Wikitech-static
< Analytics‎ | Systems‎ | Cluster
Revision as of 17:55, 26 August 2019 by imported>Ottomata
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..


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:


All the databases are periodically backed up in /srv/backup/mysql/analytics-meta on the Analytics Hadoop Master Standby (an-master1002). Daily snapshots are backed up into HDFS at /wmf/data/archive/backup/mysql/analytics-meta/.