4 Replies - 687 Views - Last Post: 19 January 2011 - 08:52 PM Rate Topic: -----

#1 Mitman  Icon User is offline

  • D.I.C Head

Reputation: 3
  • View blog
  • Posts: 79
  • Joined: 09-March 08

Industry Standard for Storing Information in Databases

Posted 14 January 2011 - 08:15 PM

I was just wondering how major websites like Facebook, Google, etc. store their information in databases. Is it simply mysql with much more security/complexity or is there some other method for storing such large amounts of data. I am learning PHP/MySQL right now just for fun and to hopefully make a small website sometime in the future.
Is This A Good Question/Topic? 3
  • +

Replies To: Industry Standard for Storing Information in Databases

#2 Ionut  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 385
  • View blog
  • Posts: 1,053
  • Joined: 17-July 10

Re: Industry Standard for Storing Information in Databases

Posted 15 January 2011 - 02:57 AM

Big companies with large databases don't work with MySql or open source databases, but with MSSQL, Oracle, DB2. There are more powerfull, offer a better experience in administration and have the most impresive solutions for two of the most important request nowadays: scalability and high availability.
About Google(as for Microsoft and Amazon) moved its storage in Cloud and, because I am not familiar with this concept, I cannot give you more details, but you can search about Cloud on google.
Was This Post Helpful? 2
  • +
  • -

#3 AdaHacker  Icon User is offline

  • Resident Curmudgeon

Reputation: 438
  • View blog
  • Posts: 792
  • Joined: 17-June 08

Re: Industry Standard for Storing Information in Databases

Posted 15 January 2011 - 11:38 AM

View PostIonut, on 15 January 2011 - 04:57 AM, said:

Big companies with large databases don't work with MySql or open source databases, but with MSSQL, Oracle, DB2.

That depends on whether you're talking about large enterprises or large websites. MySQL is actually quite popular with large public-facing websites. For instance, Facebook, Twitter, and YouTube make use of it.
Was This Post Helpful? 2
  • +
  • -

#4 skyhawk133  Icon User is offline

  • Head DIC Head
  • member icon

Reputation: 1818
  • View blog
  • Posts: 20,238
  • Joined: 17-March 01

Re: Industry Standard for Storing Information in Databases

Posted 15 January 2011 - 01:57 PM

A lot of larger companies like Google and such are using NoSQL type implementations. Google uses what's called "BigTable". You can read up on NoSQL implementations here: http://en.wikipedia.org/wiki/NoSQL

MySQL is quite popular, but it is not what is used by some of the largest sites anymore. It's just not fast enough for the type of processing they have to do.
Was This Post Helpful? 2
  • +
  • -

#5 Mitman  Icon User is offline

  • D.I.C Head

Reputation: 3
  • View blog
  • Posts: 79
  • Joined: 09-March 08

Re: Industry Standard for Storing Information in Databases

Posted 19 January 2011 - 08:52 PM

Thanks for the replies. They were very helpful and i appreciate the links you gave.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1