MySpace SQL Server

Happy New Year, 2010

I was reading the latest SQL Server Magazine and there is a great feature cover story on MySpace in regards to the infrastructure with tons of great information in details regarding the database.

I have always known that MySpace operated using Microsoft’s SQL Server as the DB engine of choice.
The fact of the matter is having such a vastly popular well known social media site running SQL Server demonstrates the success of operating a Microsoft solution.

I may be partial to Microsoft solutions given the fact I am a certified professional for their products and services including SQL Services and Exchange Mail, this is a great case study I enjoyed reading and sharing with others who may be looking to grow their next emerging empire.

MySpace team is often asked “Why SQL Server?” and the choice to go with a Windows platform.
Compared to open-source competitors it’s really easy to get up and running and develop rapidly with Microsoft solutions.

When the site started in 2003 they had one instance of SQL Server 2000 running on one server.
The next step in growth was the approach to scaling with a master/slave model using transactional replication. 
“Service Broker has enabled us to reduce data errors across our distributed databases by orders of magnitude. This is significant because data errors used to be the greatest problem our group had to deal with.
Christa Stelzmuller

Chief Data Architect, MySpace


Benefits
MySpace gained the enhanced data integrity and better user experience it had sought by using the Service Broker feature of SQL Server 2005 in creating its Service Dispatcher application to support its distributed database infrastructure. The company found Service Broker to have enterprise-class performance, and its internal developers are enjoying faster development by relying on Service Broker to handle asynchronous messaging
between the database instances.

There is a full case study available from Microsoft @ http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?CaseStudyID=4000004532
In addition by visiting SQL Server Magazine, request InstantDoc ID 103058 or subscribing to the magazine.
http://www.sqlmag.com/Articles/ArticleID/103058/103058.html

Posted via email from IT Rockstar

Advertisements

About noneil
Rapper turned Rockstar!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: