Opts for Open-Source Clustering

By Lisa Vaas  |  Posted 2005-03-21 Print this article Print

One of Canada's largest online drugstores turned to Emic's EAC clustering to handle multiple MySQL databases, a growing workforce and the rising tide of U.S. citizens seeking lower-cost drugs.

Not only are Canadas border towns being swamped by U.S. citizens looking to avoid prohibitively costly drugs—so are its online drugstores. One of the largest,, has turned to clustering of MySQL databases on Emic Networks EAC (Emic Application Clustering) technology to avoid freezing its rapidly expanding workforce out of their ever-escalating order-processing tasks. Curtis Anderson, director of IT for the online drugstore, said that the move was prompted about a year ago by bad performance, back when operations were running on a back-end SQL Server database that was connected to a Windows executable client.
"The biggest problem with that application was it was all DCOM [Microsoft Corp.s Distributed Component Object Model]-based," said Anderson, in Winnipeg, Manitoba. "That scales to about 14 people, and then youre in trouble."
With a workforce that was—and still is—growing at the rate of about 10 percent per month, was in trouble. Anderson doesnt fault Microsofts SQL Server. Rather, he said, DCOM, as a single-threaded model, doesnt handle multiple users with much grace. eWEEK Technology Editor Peter Coffee says DCOM is tolerable—on one, single, lonely PC, that is. Click here to read more. "We were running into a lot of deadlock situations, primarily because of clients trying to access" the database, along with separate applications for pharmacy dispensing, CRM (customer relationship management), shipping and billing, he said. "We knew we were having problems with the applications, but this opened doors to putting everything onto one internal system that we could manage easily and centralize." That central system turned out to be a custom application, PharmacyWire, built by a local company, Metrex Internet Solutions. The application runs on an entirely open-source platform featuring the LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack and handles the drugstores workflow from start to finish: customer information tracking, order taking, payment information, order filling, pharmacy review and assessment, label printing, and shipping. The company started with two Emic nodes, "basically as a failover situation," Anderson said, but it quickly became apparent that the load was overwhelming one MySQL server. So added a third node, which shortly thereafter was followed by a fourth. The improved performance has enabled the drugstore to keep pace with the growing customer and employee demand. Currently, the system handles in the range of 1,500 to 2,500 transactions per second on IBM Blade server architecture. "It gives us breathing room for performance, so we can handle surges through the day," Anderson said. "It can handle that load without breaking a sweat." Click here to read an eWEEK Labs review of IBMs BladeCenter server. An added bonus of clustering, of course, is the pressure it relieves when it comes to scheduled maintenance. With clustering, a server can be brought out of the cluster and attended to, while the load it carried shifts over to the remaining nodes. EAC handles the shift automatically: As one server disappears, the others take up the slack. For now, the system is going "great guns," Anderson said, with its ample capacity. The future holds, unsurprisingly, a new node, Anderson said. EAC can scale to 16 nodes—a comforting thought for the online drugstore, given the facts that drug costs in the United States arent getting more affordable, its citizens arent getting happier with footing the bill and CanadaDrugs.coms growth isnt slowing down anytime soon. Check out eWEEK.coms for the latest database news, reviews and analysis.
Lisa Vaas is News Editor/Operations for and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.

Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel