Change Details

We currently have MariaDB running in support of the [[https://wikitech.wikimedia.org/wiki/Data_Engineering/Systems/Analytics_Meta|Analytics Meta]] services. These databases support the following subsystems: * Hive metastore * DataHub * Druid (both analytics and public clusters) * Superset (both production and next instances) * Hue (soon to be deprecated) These databases are running on an-mariadb100[1-2] and are currently running MariaDB 10.4. Under normal conditions, an-mariadb1002 is a replica of an-mariadb1001. The databases are backed up to db1208 and from there to bacula. We do not currently have a mechanism in place that would allow us to swap these roles easily. Such a mechanism would facilitate routine operational work on an-mariadb1001.

We currently have MariaDB running in support of the [[https://wikitech.wikimedia.org/wiki/Data_Engineering/Systems/Analytics_Meta|Analytics Meta]] services. These databases support the following subsystems: * Hive metastore * DataHub * Druid (both analytics and public clusters) * Superset (both production and next instances) * Hue (soon to be deprecated) These databases are running on an-mariadb100[1-2] and are currently running MariaDB 10.4. Under normal conditions, an-mariadb1002 is a replica of an-mariadb1001. The databases are backed up to db1208 and from there to bacula. We do not currently have a mechanism in place that would allow us to swap these roles easily. Such a mechanism would facilitate routine operational work on an-mariadb1001. #### [] Identify one or more options for how to improve this high-availability and managed failover for Analytics Meta, so that we might decide whether to proceed to an implementation.

We currently have MariaDB running in support of the [[https://wikitech.wikimedia.org/wiki/Data_Engineering/Systems/Analytics_Meta|Analytics Meta]] services. These databases support the following subsystems: * Hive metastore * DataHub * Druid (both analytics and public clusters) * Superset (both production and next instances) * Hue (soon to be deprecated) These databases are running on an-mariadb100[1-2] and are currently running MariaDB 10.4. Under normal conditions, an-mariadb1002 is a replica of an-mariadb1001. The databases are backed up to db1208 and from there to bacula. We do not currently have a mechanism in place that would allow us to swap these roles easily. Such a mechanism would facilitate routine operational work on an-mariadb1001. #### [] Identify one or more options for how to improve this high-availability and managed failover for Analytics Meta, so that we might decide whether to proceed to an implementation.