Configuring Project Voldemort to use MySQL

Project Voldemort (v0.51) uses BerkeleyDB by default and the steps necessary to use MySQL as the backing data store are slightly different than what is on the website. This is what I did:

1. Copied mysql-connector-java-5.0.4.jar into voldemort/lib
2. Set mysql as the persistence engine in stores.xml:

<stores>
  <store>
    ...
    <persistence>mysql</persistence>
    ...
  </store>
  ...
</stores>

3. Added this line to server.properties to enable mysql:

storage.configs=voldemort.store.mysql.MysqlStorageConfiguration, voldemort.store.memory.InMemoryStorageConfiguration, voldemort.store.memory.CacheStorageConfiguration, voldemort.store.bdb.BdbStorageConfiguration

• The documentation says to set “enable.mysql.engine=true”, this does not work. The engine loading config property has since been generalized so that you can import your own data stores.

4. Set up login information in server.properties:

# Mysql
mysql.host=localhost
mysql.port=3306
mysql.user=root
mysql.password=password
mysql.database=voldemort_single