Replication

From MusicBrainz Wiki
Revision as of 22:03, 1 March 2012 by Ianmcorvidae (talk | contribs) (New page: The MusicBrainz Live Data Feed is based on a concept of replication. You can read about how it works at Replication Mechanics and Trigger Based Replication. The list of tables ...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

The MusicBrainz Live Data Feed is based on a concept of replication. You can read about how it works at Replication Mechanics and Trigger Based Replication. The list of tables to be replicated can be found in the codebase at admin/sql/CreateReplicationTriggers.sql; the list as of this writing is:

  • annotation
  • artist
  • artist_alias
  • artist_annotation
  • artist_meta
  • artist_tag
  • artist_credit
  • artist_credit_name
  • artist_gid_redirect
  • artist_name
  • artist_type
  • cdtoc
  • clientversion
  • country
  • gender
  • isrc
  • l_artist_artist
  • l_artist_label
  • l_artist_recording
  • l_artist_release
  • l_artist_release_group
  • l_artist_url
  • l_artist_work
  • l_label_label
  • l_label_recording
  • l_label_release
  • l_label_release_group
  • l_label_url
  • l_label_work
  • l_recording_recording
  • l_recording_release
  • l_recording_release_group
  • l_recording_url
  • l_recording_work
  • l_release_release
  • l_release_release_group
  • l_release_url
  • l_release_work
  • l_release_group_release_group
  • l_release_group_url
  • l_release_group_work
  • l_url_url
  • l_url_work
  • l_work_work
  • label
  • label_alias
  • label_annotation
  • label_meta
  • label_gid_redirect
  • label_name
  • label_tag
  • label_type
  • language
  • link
  • link_attribute
  • link_attribute_type
  • link_type
  • link_type_attribute_type
  • medium
  • medium_cdtoc
  • medium_format
  • puid
  • recording
  • recording_annotation
  • recording_meta
  • recording_gid_redirect
  • recording_puid
  • recording_tag
  • release
  • release_annotation
  • release_gid_redirect
  • release_meta
  • release_label
  • release_packaging
  • release_status
  • release_group
  • release_group_annotation
  • release_group_gid_redirect
  • release_group_meta
  • release_group_tag
  • release_group_type
  • release_name
  • replication_control
  • script
  • statistic
  • script_language
  • tag
  • track
  • track_name
  • tracklist
  • tracklist_index
  • url
  • url_gid_redirect
  • work
  • work_alias
  • work_annotation
  • work_gid_redirect
  • work_meta
  • work_name
  • work_tag
  • work_type