/var/adm/blog

Dell Dvd Store for Drizzle

A while back, the good folks at Dell created an e-commerce benchmarking application called the "DVD Store" that emulates, of all things, a web based DVD store. The test application contains a backend database component, a web application layer, as well as series of driver program to drive load against the application. The DS2, as it is known, is built in such a way that the database backend can implemented with a variety of databases, including Oracle, SQLServer, and MySQL. Last week, I spent some time porting the application to work with Drizzle.

You can find the fruits of my labor at http://launchpad.net/ds2drizzle/trunk/0.01/+download/ds2-drizzle-0.01.tar.gz. This port not only includes a Drizzle based backend --the backend currently uses the default INNODB storage engine-- but also supports the web based DS2 driver which can be run against both JSP or PHP based implementations of the DVD Store Web Application. Not included in this port is the ASP based Web Application nor has the direct (non-web-based) driver been ported to work with Drizzle.

The database schema used by this port looks very similar to the MySQL DS2 schema with one major exception. The original MySQL schema contained FULLTEXT indices. Since the INNODB storage engine does not support FULLTEXT indices, these indices have been removed from the schema. The affect of this is that the queries which relied on the FULLTEXT indices needed to be reworked. For the time being, these queries have been changed from MATCH type queries that took advantage of the FULLTEXT index to LIKE queries. This is obviously not an optimal solution and should be considered a hack (which I solely chose out of expedience). A better solution would have drizzle work in conjunction with the fulltext search engine such as lucene or sphynx.

Posted at 08:53PM Sep 15, 2009 by Eric Lambert in Drizzle  |  Comments[0]