What database is currently using Youtube?

Question

I hope someone can help me in this thread, even if this is not a specific programming issue. I am writing a bachelor's degree, where I compare MySQL with MongoDB, and I want to write something about Youtube, as the platform has to handle a lot of queries with a heavy dataload. The only good resource I've found is the video: Seattle Scalability Conference: YouTube scalability

Since the conference was in 2007, I can imagine that there were some updates regarding the database.

The last information I get from this conversation is that the thumbnails are stored in the BigTable database and metadata in MySQL. Are there any changes since then? Where are the videos stored? Is there a record in the MySQL table that refers to the saved video?

Thanks in advance for your reply!

Answer 1

According to this, youtube still uses mysql: http://code.google.com/p/vitess/wiki/ProjectGoals

Answer 2

I think they use a database that can use FileTable

Answer 3

I'm not sure what is happening on youtube, but I am developing a similar application for our client. So what we do, we use the best of both worlds, such as SQL and NoSQL ..

We save the video to disk and save the path to these videos in the MySQL db table. Then we have a separate table that contains the genre and video mapping, and which video belongs to a particular genre.

Today, with a huge amount of user data, we can use this data like never before, so you see that now everything has changed than in 2007, and with the popularity and dependence of people on the Internet when they appear on sites like you, with us There is an extensive set of unstructured data that, when used correctly, can give you excellent results. Thus, in our project, we store the site administrator and inform about such things as custom db, video placements and genre mapping, etc. In MySQL, we store unstructured user interaction data in a NoSQL database. Then we use NoSQL data to do all the analytics and provide the user with relevant results.

Answer 4

They use mysql with Bigdata. User information that has who uploaded the file, all file data will be stored in mysql, and the data will be stored in Bigdata.