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 ...) |
Ianmcorvidae (talk | contribs) (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_primary_type |
|||
* release_group_type |
|||
* release_group_secondary_type |
|||
* release_group_secondary_type_join |
|||
* release_name |
* release_name |
||
* replication_control |
* replication_control |
||
* script |
* script |
||
⚫ | |||
* 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.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