eHarmony spurns Microsoft, finds match with Oracle 10g

Online matchmaker eHarmony migrated from Microsoft to Oracle to meet its need for greater scalability.

This Content Component encountered an error

Business has been growing fast for eHarmony -- so fast that the popular online matchmaker decided to migrate from Microsoft SQL Server to an Oracle 10g infrastructure to meet the need for greater scalability.

The yearlong migration process began in late 2005, when -- faced with the prospect of more than 10,000 singles signing up for eHarmony's service via the company's website each day -- IT executives with the Pasadena, Calif.-based firm concluded that Microsoft SQL Server had reached its limits.

"Scalability was the main issue with [Microsoft SQL Server]," said Mark Douglas, eHarmony's vice president of technology. "We just physically outgrew it because it doesn't have the same kind of functionality that [Real Application Clusters] provide with Oracle."

Today, eHarmony, which boasts more than 17 million registered users and 400 million page views per month, is operating a clustered

Oracle vs. Microsoft

One of the main reasons eHarmony decided to get off Microsoft SQL Server had to do with locking, the process by which the system makes individual rows of code non-writeable when they're being accessed by more than one user at a time, according to Douglas.

"The way locking works in SQL Server becomes a big scaling issue over time," he said. "We're running anywhere [up to] 1,000 transactions per second, so that turns into hundreds of thousands of locks, and it just is not scalable."

Douglas added that there are ways to get around the locking issue in Microsoft SQL Server, but they would have required the company to make significant changes to its homegrown, Java 2 Enterprise Edition-based matchmaking application.

"Instead, we chose to move to Oracle," he said. "There is a minimum amount of locking in Oracle, so it scales a lot better."

More Oracle case studies:

Millipore swaps out SAP for Oracle

Oracle edges out SAP at logistics firm

Migration challenges

As eHarmony geared up to make the jump to Oracle, a lot of changes had to be made, and each and every one of them had to be tested, re-tested, and tested again, according to Douglas.

eHarmony had to change its applications, its reporting environment and even some of its data, which was stored differently in SQL Server.

"Just about everything that touched the database, which is pretty much everything we have, had to in some way change," Douglas said. "And [those changes] had to be thoroughly tested. Everything had to work."

Before going live with Oracle last December, eHarmony conducted 100 straight days of testing and scripted every move to ensure as little downtime as possible when the final switch was made.

"We essentially moved 100 days in a row before we actually did it permanently," Douglas said. "You couldn't have any data loss, and so it was a pretty involved effort."

Oracle 11g still a ways off

The newest version of Oracle's flagship database management system,

This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close