Difference between revisions of "Replication"

From MusicBrainz Wiki
(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 ...)
 
(update to current)
Line 1: Line 1:
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:
+
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 and other CreateReplicationTriggers.sql files in subdirectories of admin/sql/; the list as of this writing is:
  
 
* annotation
 
* annotation
 
* artist
 
* artist
 
* artist_alias
 
* artist_alias
 +
* artist_alias_type
 
* artist_annotation
 
* artist_annotation
 +
* artist_ipi
 
* artist_meta
 
* artist_meta
 
* artist_tag
 
* artist_tag
Line 17: Line 19:
 
* gender
 
* gender
 
* isrc
 
* isrc
 +
* iswc
 
* l_artist_artist
 
* l_artist_artist
 
* l_artist_label
 
* l_artist_label
Line 47: Line 50:
 
* label
 
* label
 
* label_alias
 
* label_alias
 +
* label_alias_type
 
* label_annotation
 
* label_annotation
 +
* label_ipi
 
* label_meta
 
* label_meta
 
* label_gid_redirect
 
* label_gid_redirect
Line 81: Line 86:
 
* release_group_meta
 
* release_group_meta
 
* release_group_tag
 
* release_group_tag
* release_group_type
+
* release_group_primary_type
 +
* release_group_secondary_type
 +
* release_group_secondary_type_join
 
* release_name
 
* release_name
 
* replication_control
 
* replication_control
 
* script
 
* script
* statistic
 
 
* script_language
 
* script_language
 
* tag
 
* tag
Line 96: Line 102:
 
* work
 
* work
 
* work_alias
 
* work_alias
 +
* work_alias_type
 
* work_annotation
 
* work_annotation
 
* work_gid_redirect
 
* work_gid_redirect
Line 102: Line 109:
 
* work_tag
 
* work_tag
 
* work_type
 
* work_type
 +
* statistics.statistic
 +
* statistics.stastitic_event
 +
* cover_art_archive.art_type
 +
* cover_art_archive.cover_art
 +
* cover_art_archive.cover_art_type
 +
* cover_art_archive.release_group_cover_art

Revision as of 08:50, 4 March 2013

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 and other CreateReplicationTriggers.sql files in subdirectories of admin/sql/; the list as of this writing is:

  • annotation
  • artist
  • artist_alias
  • artist_alias_type
  • artist_annotation
  • artist_ipi
  • artist_meta
  • artist_tag
  • artist_credit
  • artist_credit_name
  • artist_gid_redirect
  • artist_name
  • artist_type
  • cdtoc
  • clientversion
  • country
  • gender
  • isrc
  • iswc
  • 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_alias_type
  • label_annotation
  • label_ipi
  • 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_primary_type
  • release_group_secondary_type
  • release_group_secondary_type_join
  • release_name
  • replication_control
  • script
  • script_language
  • tag
  • track
  • track_name
  • tracklist
  • tracklist_index
  • url
  • url_gid_redirect
  • work
  • work_alias
  • work_alias_type
  • work_annotation
  • work_gid_redirect
  • work_meta
  • work_name
  • work_tag
  • work_type
  • statistics.statistic
  • statistics.stastitic_event
  • cover_art_archive.art_type
  • cover_art_archive.cover_art
  • cover_art_archive.cover_art_type
  • cover_art_archive.release_group_cover_art