Mis “Myspace

What kind of databases and database servers does MySpace use? A database is an organized appeal of data. A database server is a computer program that provides database services to early(a)(a) computer programs. In the initial phases, MySpace operated with deuce electronic network servers (a computer use that helps to deliver web content that can be accessed through the internet) communicating with one database server and a Microsoft SQL Server database(as s database, it is a parcel product whose primary function is to gillyflower and retrieve data pass on by other software applications).But as the number of accounts started to increase to 500,000 in 2004 one database server wasnt sufficient. MySpace then deployed three SQL servers database. Which one served as a master database, which received all new data and copied it to the other two databases. As time passed and the number of accounts grew to millions, the database servers where approaching their input/ produce capacity a nd causing MySpace to add legion(predicate) cheaper servers to share the database load.Still having problems with overload, MySpace switched to virtualized storage architecture. In which databases write to any available disk, thus eliminating the possibility of an applications apply disk becoming overloaded. In 2005 MySpace added more servers between the database servers and the meshing servers to store and serve copies of frequently accessed data objects so that the identifys web servers wouldnt call for to query the servers with lookups as frequently. Why is a database technology so important for a business such as MySpace?Due to the nature of MySpace and because it mostly receive from and serves to its uses are data objects desire pictures, audio files and video files databases technology is the only technology that accomplish the mission. Its database must(prenominal) make the objects readily available to anyone requesting access to an entity (person). Database technology cuts through many problems of traditional filing. Rather than storing data in separate file for each(prenominal) application, data are store as to appear to users as be stored in only one single location.How effectively does MySpace organize and store the data on its site? MySpace. com was one of the most popular loving networking sites and experienced one of the greatest growths in the history. But unfortunately it wasnt able to keep with its data storage and challenged technical letdowns that degrade web site performance and frustrated its rapidly expanding network users. MySpace used two Web servers communicating with one database server. It was adequate when the site had a lessened number of users who were updating or accessing database objects.Obviously that wont work with millions of users. Unfortunately, MySpace unbroken overloading more frequently than other major Web sites. With a log in error rate of 20 to 40 percent on or so days, the site is not effectively organi zing or storing data. What data management problems have risen? How has MySpace solved, or attempted to solve these problems? Some of the problems MySpace has encountered are unequal storage space on its database servers, slow access or no access through its log-in application, and users inabilities to access data.Over the years, MySpace has attempted to fix these problems by adding more and Web servers and more database servers. Some were simply added on without restructuring the full system to more efficiently use its hardware and software. Workloads were not distributed equally between servers which caused inefficient use of resources. MySpace developers continue to redesign the Web sites database, software, and storage systems, to keep pace with its exploding growth, but their job is never done. MySpace switched to a virtualization storage architecture which ended the practice of attaching disk dedicated to specific applications.