| MB_MySQL (core module) |
| |
What is it? |
| |
How does it work? |
| |
What do I need to use it? |
| |
Where can I get it? |
| |
Can I help? |
| |
|
| The WebInterface (this site) |
| |
Can I download and run this web site on my local server? |
| |
How do I get a new feature put into the site? |
| |
|
| Custom SQL |
| |
What is Quota? |
| |
What counts as Quota? |
| |
How do I get more Quota? |
| |
What are the restrictions of using this service? |
| |
 |
| |
| |
| |
| What is it? |
| |
MB_MySQL is a very easy to use and setup automated system for running the MusicBrainz database on web/office/home servers. |
| |
|
| How does it work? |
| |
The MusicBrainz database is available for free (not for commercial purposes) to anyone that wishes to use it. The original MusicBrainz database is written in PostgreSQL. Every hour a 'replication' is released that allows local versions of the database to be up to date with the real database. Normally these replications would by processed by the accompanying replication software for the PostgreSQL database.
MB_MySQL allows the entire MusicBrainz database to run and automatically update from hourly released replications with MySQL. It is 100% free and open source. |
| |
|
| What do I need to use it? |
| |
First and foremost, a unix based machine. This software has been tested to run on Windows, but due to the lack of support from MySQL, the windows MySQL client is horrendously slow and simple unable to cope with this magnitude of data.
Minimum requirements:
- A unix based system. Any distribute of linux should do.
- MySQL version 5 or later. I'm not sure if it works on earlier versions of MySQL, but it has been designed for version 5.
- Perl. You will need this to run the software to do the updating etc. (comes as standard with unix.)
- At least 10GB of hard disk space (20GB+ recommended).
As for other things like how much RAM the server must have, CPU, settings for MySQL etc. This is hard to say, i've tested it on a few servers myself and it will run fine on; 3Ghz Pentium 4 with 512mb RAM running Fedora Core 6. If you manage to get it running a really old machine, i'd like to hear from you ... just because it would be cool. :) |
| |
|
| Where can I get it? |
| |
You can download various packages from the download page. |
| |
|
| Can I help? |
| |
Absolutely. Anything from suggesting ideas or reporting bugs to improving it yourself in any way is always appreciated. Any kind of feedback is good. :) |
| |
|
| Can I download and run this web site on my local server? |
| |
Yes. Everything about the project (including this entire web site) is completely open source. You may download, edit and distribute any of the source for no commercial purposes. See the download page. |
| |
|
| How do I get a new feature put into the site? |
| |
If you believe it is a worthy feature, then chances are that someone else will thinks it's good to. Please contact me. |
| |
|
| What is Quota? |
| |
'Quota' specifically applies to the Custom SQL service. Quota basically means how many seconds of execution time you can poll to the database, once you quota hits 0 you may not use this service until your quota has been increased or refreshed. |
| |
| What counts as Quota? |
| |
Only successfully executed commands count towards the quota (ie. If your statement has and error it will not charge it to your Quota). At the moment the following commands do not take quota:
|
| |
| How do I get more Quota? |
| |
Quota can only be allocated by the site administrator. The Quota is there to stop people polling hundreds of heavy commands to the database and taking database resources. It hasn't been decided on what grounds qualifies a user to have more quota yet, possibly a daily or weekly refresh system. If you would like more Quota contact me. |
| |
|
| What are the restrictions of using this service? |
| |
For security reasons there is a list of keywords that will stop the execution of a statement (such as INSERT, UPDATE, DELETE, etc.) If a statement is attempted to be executed it will return and error message notifying the user that the statement could not be executed. If the statement is blocked it will not count towards your Quota. |
| |
|
