What structure and base to choose for an Instagram similar application?

R

Rustam Salavatov2014-10-12 21:54:33

MySQL

Rustam Salavatov, 2014-10-12 21:54:33

Good afternoon.
I am planning a scheme for a small social platform with a video very similar to Instagram.
Backend development with Django.
Frontend on Facebook React.
the question is if there is an example of how the Instagram database of similar applications is organized.
And what is the best base to choose?
MySql(MyIsam/Innodb), MariaDB or Postgree?
By functionality, we have in the table
Users
Movie
Comments Likes Hashtags
Music Templates Downloads with sources

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

M

My joy, 2014-10-13
@t-alexashka

In terms of speed, everyone advises postgresql, although I myself have not worked with it. It seems to me that mysql is enough for you (why not?), you still have to do replication, + cache with memcached, and duplicate part of the key data in elasticsearch for faster search.

B

Boy, 2017-02-18
@demavair

The whole platform and architecture of Instagram is described here
https://www.insight-it.ru/highload/2012/arkhitektu...