Difference between revisions of "Replication"

From MusicBrainz Wiki
(update to current)
(Add information about which tables belong to which dumps)
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 and other CreateReplicationTriggers.sql files in subdirectories of admin/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
+
==Included in replication==
 +
=====Tables in mbdump.tar.bz2=====
 
* artist
 
* artist
 
* artist_alias
 
* artist_alias
 
* artist_alias_type
 
* artist_alias_type
* artist_annotation
 
 
* artist_ipi
 
* artist_ipi
* artist_meta
 
* artist_tag
 
 
* artist_credit
 
* artist_credit
 
* artist_credit_name
 
* artist_credit_name
Line 51: Line 49:
 
* label_alias
 
* label_alias
 
* label_alias_type
 
* label_alias_type
* label_annotation
 
 
* label_ipi
 
* label_ipi
* label_meta
 
 
* label_gid_redirect
 
* label_gid_redirect
 
* label_name
 
* label_name
* label_tag
 
 
* label_type
 
* label_type
 
* language
 
* language
Line 69: Line 64:
 
* puid
 
* puid
 
* recording
 
* recording
* recording_annotation
 
* recording_meta
 
 
* recording_gid_redirect
 
* recording_gid_redirect
 
* recording_puid
 
* recording_puid
* recording_tag
 
 
* release
 
* release
* release_annotation
 
 
* release_gid_redirect
 
* release_gid_redirect
* release_meta
 
 
* release_label
 
* release_label
 
* release_packaging
 
* release_packaging
 
* release_status
 
* release_status
 
* release_group
 
* release_group
* release_group_annotation
 
 
* release_group_gid_redirect
 
* release_group_gid_redirect
* release_group_meta
 
* release_group_tag
 
 
* release_group_primary_type
 
* release_group_primary_type
 
* release_group_secondary_type
 
* release_group_secondary_type
Line 93: Line 80:
 
* script
 
* script
 
* script_language
 
* script_language
* tag
 
 
* track
 
* track
 
* track_name
 
* track_name
 
* tracklist
 
* tracklist
* tracklist_index
 
 
* url
 
* url
 
* url_gid_redirect
 
* url_gid_redirect
Line 103: Line 88:
 
* work_alias
 
* work_alias
 
* work_alias_type
 
* work_alias_type
 +
* work_gid_redirect
 +
* work_name
 +
* work_type
 +
 +
=====Tables in mbdump-derived.tar.bz2=====
 +
* annotation
 +
* artist_annotation
 +
* artist_meta
 +
* artist_tag
 +
* label_annotation
 +
* label_meta
 +
* label_tag
 +
* recording_annotation
 +
* recording_meta
 +
* recording_tag
 +
* release_annotation
 +
* release_meta
 +
* release_group_annotation
 +
* release_group_meta
 +
* release_group_tag
 +
* tag
 +
* tracklist_index
 
* work_annotation
 
* work_annotation
* work_gid_redirect
 
 
* work_meta
 
* work_meta
* work_name
 
 
* work_tag
 
* work_tag
* work_type
+
 
 +
=====Tables in mbdump-stats.tar.bz2=====
 
* statistics.statistic
 
* statistics.statistic
 
* statistics.stastitic_event
 
* statistics.stastitic_event
 +
 +
=====Tables in mbdump-cover-art-archive.tar.bz2=====
 
* cover_art_archive.art_type
 
* cover_art_archive.art_type
 
* cover_art_archive.cover_art
 
* cover_art_archive.cover_art
 
* cover_art_archive.cover_art_type
 
* cover_art_archive.cover_art_type
 
* cover_art_archive.release_group_cover_art
 
* cover_art_archive.release_group_cover_art
 +
 +
==Not included in replication==
 +
=====Tables in mbdump-derived.tar.bz2=====
 +
* ??? release_tag
 +
* ??? tag_relation
 +
 +
=====Tables in mbdump-editor.tar.bz2=====
 +
* editor
 +
 +
=====Tables in mbdump-edit.tar.bz2=====
 +
* edit
 +
* edit_artist
 +
* edit_label
 +
* edit_note
 +
* edit_recording
 +
* edit_release
 +
* edit_release_group
 +
* edit_url
 +
* edit_work
 +
* vote
 +
 +
=====Tables in mbdump-cdstubs.tar.bz2=====
 +
* cdtoc_raw
 +
* release_raw
 +
* track_raw

Revision as of 09:15, 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:

Included in replication

Tables in mbdump.tar.bz2
  • artist
  • artist_alias
  • artist_alias_type
  • artist_ipi
  • 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_ipi
  • label_gid_redirect
  • label_name
  • label_type
  • language
  • link
  • link_attribute
  • link_attribute_type
  • link_type
  • link_type_attribute_type
  • medium
  • medium_cdtoc
  • medium_format
  • puid
  • recording
  • recording_gid_redirect
  • recording_puid
  • release
  • release_gid_redirect
  • release_label
  • release_packaging
  • release_status
  • release_group
  • release_group_gid_redirect
  • release_group_primary_type
  • release_group_secondary_type
  • release_group_secondary_type_join
  • release_name
  • replication_control
  • script
  • script_language
  • track
  • track_name
  • tracklist
  • url
  • url_gid_redirect
  • work
  • work_alias
  • work_alias_type
  • work_gid_redirect
  • work_name
  • work_type
Tables in mbdump-derived.tar.bz2
  • annotation
  • artist_annotation
  • artist_meta
  • artist_tag
  • label_annotation
  • label_meta
  • label_tag
  • recording_annotation
  • recording_meta
  • recording_tag
  • release_annotation
  • release_meta
  • release_group_annotation
  • release_group_meta
  • release_group_tag
  • tag
  • tracklist_index
  • work_annotation
  • work_meta
  • work_tag
Tables in mbdump-stats.tar.bz2
  • statistics.statistic
  • statistics.stastitic_event
Tables in mbdump-cover-art-archive.tar.bz2
  • cover_art_archive.art_type
  • cover_art_archive.cover_art
  • cover_art_archive.cover_art_type
  • cover_art_archive.release_group_cover_art

Not included in replication

Tables in mbdump-derived.tar.bz2
  •  ??? release_tag
  •  ??? tag_relation
Tables in mbdump-editor.tar.bz2
  • editor
Tables in mbdump-edit.tar.bz2
  • edit
  • edit_artist
  • edit_label
  • edit_note
  • edit_recording
  • edit_release
  • edit_release_group
  • edit_url
  • edit_work
  • vote
Tables in mbdump-cdstubs.tar.bz2
  • cdtoc_raw
  • release_raw
  • track_raw