facebook and databases

Discussion in 'Databases' started by coleio, Apr 5, 2018.

  1. #1
    hi, so new to the forum and new to back end and sql development. currently studying the ciw foundations course. i have a particular project i intend to start work on and at the moment I'm just researching. the site i have in mind is similar to facebook (only on a much smaller scale) so my question is, how is facebooks databases structured.

    what happens when a user signs up for the first time, is a MySQL database created specifically for that person with several tables for user info, account settings, statuses and photos?

    i am mostly curious about how the facebook status feed works. i imagine that when someone posts a status, the status is sent to a cgi script that takes the posting users status and logs it using sql to a table on each friends personal database. in my limited experience it makes sense, right? but i imagine data replication could be a problem. is there a better more efficient way to make this work?

    thankyou in advance
     
    coleio, Apr 5, 2018 IP