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

MariaDB/misc: Difference between revisions

From Wikitech-static
Jump to navigation Jump to search
imported>BryanDavis
(Add m5 section and striker schema)
imported>Ayounsi
Line 46: Line 46:
* '''etherpadlite''': jmm, alex
* '''etherpadlite''': jmm, alex
* '''heartbeat''': jynus
* '''heartbeat''': jynus
* '''librenms''': filippo
* '''librenms''': filippo, Arzhel
* '''puppet''': jynus
* '''puppet''': jynus
* '''racktables''': jmm, alex, krenair working on moving to servermon
* '''racktables''': jmm, alex, krenair working on moving to servermon
* '''reviewdb''': gerrit. - chad
* '''reviewdb''': gerrit. - chad
* '''rt''': daniel working on migration , db schema upgrade on db2007
* '''rt''': daniel working on migration , db schema upgrade on db2007
== m2 ==
=== Current schemas ===
These are the current dbs, and what was needed to failover then:
* '''reviewdb'''
* '''otrs'''
* '''bugzilla_testing'''
* '''frimpressions'''
* '''heartbeat'''
* '''iegreview'''
* '''scholarships'''
* '''testblog'''


== m3 ==
== m3 ==
Line 65: Line 78:


=== Current schemas ===
=== Current schemas ===
* '''labswiki''': schema for wikitech (MediaWiki)
* '''striker''': schema for [[toolsadmin.wikimedia.org]] (Striker)
* '''striker''': schema for [[toolsadmin.wikimedia.org]] (Striker)
* ???: schema(s) for OpenStack

Revision as of 22:21, 13 March 2018

There are 5 "miscelaneous" shards: m1-m5.

  • m1: Basic ops utilities
  • m2: otrs, gerrit and others
  • m3: phabricator and other older task systems
  • m4: eventlogging system
  • m5: openstack and other labs-related dbs

On the last cleanup, many unused databases were archived and/or deleted, and a contact person was discovered for each of them.

m1

Current schemas

These are the current dbs, and what was needed to failover then:

  • bacula ; sudo service bacula-director restart after the migration. I had already made sure no jobs were running with status director. Tested after with a list media
  • etherpadlite ; seems like etherpad-lite crashed after the migration and systemd took care of restarting it. etherpad crashes anyway at least once a week if not more so no big deal ; tested by opening a pad
  • heartbeat: needs "manual migration"- change master role on puppet
  • librenms: required manual kill of its connections @netmon1001: apache reload
  • puppet: required manual kill of its connections; This caused the most puppet spam. Either restart puppet-masters or kill connections **as soon** as the failover happens.
  • racktables: went fine, no problems
  • rt: required manual kill of its connections ; @unobtinium: apache reload

Deleted/archived schemas

  • reviewdb: not really on m1 anymore (it was migrated to m2). To delete.
  • blog: to archive
  • bugzilla: to archive * kill archived and dropped
  • bugzilla3: idem kill archived and dropped
  • bugzilla4: idem archive, actually, we also have this on dumps.wm.org https://dumps.wikimedia.org/other/bugzilla/ but that is the sanitized version, so keep this archive just in case i guess
  • bugzilla_testing: idem kill archived and dropped
  • communicate:  ? archived and dropped
  • communicate_civicrm: not fundraising! we're not sure what this is, we can check users table to determine who administered it archived and dropped
  • dashboard_production: Puppet dashboard db. Never used it in my 3 years here, product sucks. Kill with fire. - alex archived and dropped
  • outreach_civicrm: not fundraising, this is the contacts.wm thing, not used anymore, but in turn it means i dont know what "communicate" is then, we can look at the users tables for info on the
  • bacula: alex
  • admin: archived and dropped
  • outreach_drupal: kill archived and dropped
  • percona: jynus dropped
  • query_digests: jynus archived and dropped
  • test: archived and dropped
  • test_drupal: er, kill with fire ? kill archived and dropped

owners, (or in many cases just people that volunteer to help for the failover)

  • blog: blog people are Tilman Bayer et all (HaeB) archived and dropped
  • etherpadlite: jmm, alex
  • heartbeat: jynus
  • librenms: filippo, Arzhel
  • puppet: jynus
  • racktables: jmm, alex, krenair working on moving to servermon
  • reviewdb: gerrit. - chad
  • rt: daniel working on migration , db schema upgrade on db2007

m2

Current schemas

These are the current dbs, and what was needed to failover then:

  • reviewdb
  • otrs
  • bugzilla_testing
  • frimpressions
  • heartbeat
  • iegreview
  • scholarships
  • testblog

m3

Current schemas

  • phabricator_*: 57 schemas to support phabricator itself
  • rt_migration: schema needed for some crons related to phabricator jobs
  • bugzilla_migration: schema needed for some crons related to phabricator jobs

Dropped schemas

  • fab_migration

m5

Current schemas

  • labswiki: schema for wikitech (MediaWiki)
  • striker: schema for toolsadmin.wikimedia.org (Striker)
  • ???: schema(s) for OpenStack