Difference between revisions of "Database Setup"

From MusicBrainz Wiki
Jump to navigationJump to search
m
(Remove links to outdated content; restructure to clarify the difference between standalone download and full install with replication)
Line 1: Line 1:
 
<small>[[Products]] > [[Database]] > Database setup</small>
 
<small>[[Products]] > [[Database]] > Database setup</small>
   
The [[Database| MusicBrainz Database]] is an SQL database that contains all the information about [[Artist|artists]], [[Release|releases]], [[Track|tracks]], [[Advanced Relationships]] between them, but also the MusicBrainz users ([[Editor|editors]]) and the changes they entered into the database ([[Edit Type|edits]]). MusicBrainz currently uses PostgreSQL as its underlying database software.
+
The [[Database| MusicBrainz Database]] is an SQL database that contains all the information about [[Artist|artists]], [[Release Group|release groups]], [[Release|releases]], [[Recording|recordings]], [[Advanced Relationships|advanced relationships]] (and [[MusicBrainz Database|everything else]] between them, but also the MusicBrainz users ([[Editor|editors]]) and the changes they entered into the database ([[Edit Type|edits]]). MusicBrainz currently uses PostgreSQL as its underlying database software.
   
The database can be [[Database Download|downloaded]] from the MusicBrainz website. There are a few guides available on how to setup your own copy of the database, and import the data:
+
The database can be [[Database Download|downloaded]] standalone from the MusicBrainz website. To setup your own fresh copy of the database, and import the data, see the relevant section of the [http://github.com/metabrainz/musicbrainz-server/blob/master/INSTALL the INSTALL guide].
* [[Database Installation]]
 
* [[Database Installation/Mac OS X Panther|Installation on Mac OS X Panther]]
 
* [[Debian VMWare Database]]
 
* [https://github.com/lalinsky/mbslave Alternative setup using a Python-based tool (including replication)]
 
   
  +
=== Replication ===
It is also possible to setup a mirror using MySQL: see [[MusicBrainz MySQL]].
 
  +
If you are interested in keeping the data in sync with MusicBrainz using our [[Live Data Feed|live data feed]], you may consider
  +
* setting up a virtual machine using the official [[Server Setup]] guide
 
* an alternative setup using a [https://github.com/lalinsky/mbslave Python-based tool] (including replication)
 
* setting up a mirror using MySQL with [[MusicBrainz MySQL]]
   
[[Category:To Be Reviewed]] [[Category:WikiDocs Page]] [[Category:Development]] [[Category:Database]]
+
[[Category:WikiDocs Page]] [[Category:Development]] [[Category:Database]]

Revision as of 08:46, 20 November 2011

Products > Database > Database setup

The MusicBrainz Database is an SQL database that contains all the information about artists, release groups, releases, recordings, advanced relationships (and everything else between them, but also the MusicBrainz users (editors) and the changes they entered into the database (edits). MusicBrainz currently uses PostgreSQL as its underlying database software.

The database can be downloaded standalone from the MusicBrainz website. To setup your own fresh copy of the database, and import the data, see the relevant section of the the INSTALL guide.

Replication

If you are interested in keeping the data in sync with MusicBrainz using our live data feed, you may consider