Replication: Difference between revisions
From MusicBrainz Wiki
Jump to navigationJump to search
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 ...) |
(→Tables in mbdump-edit.tar.bz2: +edit_area) |
||
(3 intermediate revisions by 2 users not shown) | |||
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: |
||
==Included in replication== |
|||
⚫ | |||
=====Tables in mbdump.tar.bz2===== |
|||
* artist |
* artist |
||
* artist_alias |
* artist_alias |
||
* artist_alias_type |
|||
⚫ | |||
* artist_ipi |
|||
⚫ | |||
⚫ | |||
* artist_credit |
* artist_credit |
||
* artist_credit_name |
* artist_credit_name |
||
Line 17: | Line 17: | ||
* gender |
* gender |
||
* isrc |
* isrc |
||
* iswc |
|||
* l_artist_artist |
* l_artist_artist |
||
* l_artist_label |
* l_artist_label |
||
Line 47: | Line 48: | ||
* label |
* label |
||
* label_alias |
* label_alias |
||
* label_alias_type |
|||
⚫ | |||
* label_ipi |
|||
⚫ | |||
* label_gid_redirect |
* label_gid_redirect |
||
* label_name |
* label_name |
||
⚫ | |||
* label_type |
* label_type |
||
* language |
* language |
||
Line 64: | Line 64: | ||
* puid |
* puid |
||
* recording |
* recording |
||
⚫ | |||
⚫ | |||
* recording_gid_redirect |
* recording_gid_redirect |
||
* recording_puid |
* recording_puid |
||
⚫ | |||
* release |
* release |
||
⚫ | |||
* release_gid_redirect |
* release_gid_redirect |
||
⚫ | |||
* release_label |
* release_label |
||
* release_packaging |
* release_packaging |
||
* release_status |
* release_status |
||
* release_group |
* release_group |
||
⚫ | |||
* release_group_gid_redirect |
* release_group_gid_redirect |
||
* release_group_primary_type |
|||
⚫ | |||
* release_group_secondary_type |
|||
⚫ | |||
* release_group_secondary_type_join |
|||
* release_group_type |
|||
* release_name |
* release_name |
||
* replication_control |
* replication_control |
||
* script |
* script |
||
⚫ | |||
* script_language |
* script_language |
||
⚫ | |||
* track |
* track |
||
* track_name |
* track_name |
||
* tracklist |
* tracklist |
||
⚫ | |||
* url |
* url |
||
* url_gid_redirect |
* url_gid_redirect |
||
* work |
* work |
||
* work_alias |
* work_alias |
||
* work_alias_type |
|||
⚫ | |||
* work_gid_redirect |
* work_gid_redirect |
||
⚫ | |||
* work_name |
* work_name |
||
⚫ | |||
* work_type |
* work_type |
||
=====Tables in mbdump-derived.tar.bz2===== |
|||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
=====Tables in mbdump-stats.tar.bz2===== |
|||
⚫ | |||
* 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 (see http://tickets.musicbrainz.org/browse/MBS-5978) |
|||
* tag_relation |
|||
=====Tables in mbdump-editor.tar.bz2===== |
|||
* editor |
|||
=====Tables in mbdump-edit.tar.bz2===== |
|||
* edit |
|||
* edit_area |
|||
* 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 |
Latest revision as of 20:14, 23 September 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 (see http://tickets.musicbrainz.org/browse/MBS-5978)
- tag_relation
Tables in mbdump-editor.tar.bz2
- editor
Tables in mbdump-edit.tar.bz2
- edit
- edit_area
- 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