Analytics/Systems/Cluster/Mysql Meta

From Wikitech
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). Daily snapshots are backed up into HDFS at /wmf/data/archive/backup/mysql/analytics-meta/.