Database
Database Design
MB_MySQL
Description
Features
Download
License
Bugs
Contact Us

Description

MB_MySQL version 3.1 is the latest release of the official free open-source MySQL implementation of the MusicBrainz database that allows the full replicated MusicBrainz database to run on home, office and internet servers.

Features

  • Completely automated install: The database is downloaded, created, loaded in, indexed and initialised in one step.
  • Multiple language support: Currently English and German.
  • Plugin support: You can easily write clean plugins based on a variety of replication triggers.
    • Example: A blank plugin canvas you can copy that has all the documentation.
    • Full Text: InnoDB doesn't support FULLTEXT indexing which is ideal for track searching. With this plugin a separate MyISAM table for each artist, album, track and label is kept so you can have your cake and eat it too.
    • Live Stats: Keeps real time stats on table records without the need for InnoDB to do a full table scan to count them.
    • Pending Log: Keeps a copy of all the pending replication data.
    • Soundex: Keeps extra soundex tables for searching artists, albums, tracks and labels based on the soundex algorithm.
  • Dynamic SQL translator: For converting the original PostgreSQL to MySQL compatible stataments.
  • Replication engine rewrite. Rather that trying to adapt the MusicBrainz replication code originally designed for Postgres, the replication engine has been reduced to a single subroutine as of version 3.0.
  • Smart indexing. Automatically calculates which table columns need to be indexed based on their cardinality during the database build.
  • Microsoft WIndows supported.

Sites That Use MB_MySQL

Download & Installation

Please remember the database takes approximatly 12GB of disk space and depending on your server it could take over 24 hours to build. After downloading the correct package below simply run init.pl and follow the prompts.

Mac OS X, Linux, Unix

Download MB_MySQL.

Windows

1. You need to install ActivePerl available from the ActiveState website.
2. Download MB_MySQL.

License

MB_MySQL and all affiliated MusicBrainz, Chance MEDIA or 3rd party products and/or services remain free on the bases that ffrit is used for non-commerical purposes. If you intend to use any of these products and/or services for commerical purposes you may need to purchase a data license from MusicBrainz directly. Please contact us.

Bugs & Feature Requests

If you find a bug or would like to request a feature for a future release we would like to hear from you, please contact us.