Database Replication
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