Skip Links

How Mozilla keeps its MySQL database tidy

MySQL database management tool ScaleBase virtualizes MySQL database, spreading database load into smaller bite-size chunks

By , Network World
August 08, 2012 11:49 AM ET

Network World - As an open source company, Mozilla developers make a lot of different versions of software code each day, and part of Sheeri Cabral's job to keep track of them all: which ones work, which don't, how many times they've been downloaded, and which have a bug that needs to be fixed.

To do that, the makers of the Firefox browser have a MySQL database, the common open source structured database system, which organizes the information in a table format. A few months ago Cabral, who is a database administrator and architect for Mozilla and a MySQL community contributor, began running into issues as the database grew to over 100GB. "If that database doesn't work, the downloads aren't available," she says, emphasizing the importance of the database.

Typically the solution to such a problem is to throw more compute capacity at the server housing the database, or potentially switching from hard drive spinning disks to solid state drives, says Paul Burns, an analyst at Neovise. But Cabral found a different solution: Instead of having this one single database, Mozilla has in effect virtualized its database by splitting it up into a group of clusters, each holding a portion of the database. Using technology from a company named ScaleBase, now when a query is made the ScaleBase software identifies the cluster where the data is stored so that the entire database doesn't have to be searched. This speeds performance without adding additional hardware. "This is not an easy thing to do," Cabral says, "but they seem to have done it and it's working."

MORE MOZILLA: Can Mozilla right the ship?

NOT ALL FUN AND GAMES: Inside the IT challenges of sports and entertainment

ScaleBase was born out of an Israeli consultancy a few years ago. After receiving several requests from customers to help scale MySQL databases for Web-based and mobile applications, the idea of sharding the database, or splitting it up into smaller bite-size chunks, was tested. It worked for a variety of customers, so a business was born to sell the product on a wider scale, says Paul Campaniello, VP of global marketing for ScaleBase. "People have virtualized machines, storage, operating systems," he says. "No one has really virtualized the MySQL database yet."

After receiving venture capital funding two years ago, the company brought ScaleBase into GA this year and since then it has built out its management team, including bringing on now-Executive Chairman Ram Mester, a former vice president at IBM's information management division where he led the database management, security and optimization practices.

ScaleBase describes its flagship Data Traffic Manager as a load balancing tool that sits between an application and the backend database used to store data for the program. When using the software for the first time, ScaleBase will atomically analyze the database and partition it up into multiple instances. Once a query is made, it directs the client requests directly to the appropriate instance within the database. Pricing is based on the size of the database being managed.

Our Commenting Policies
Latest News
rssRss Feed
View more Latest News