The optimal solution for saving a photo?

Question

MySQL

Imagine that there is a large social network where users save their photos.
What solutions or algorithms will be optimal for the task? save photos in database with base64 or in server according to standard and why?
DB: mysql

Answer 1

Photos should be stored as a separate file, and not inflated by the database.
You need to store the original, and make a preview and cache from the original, do not touch the original itself, because. in the future, the design may change or new functionality will appear, for which it will be necessary to generate a new image from the original.
Working with files directly is much more convenient

Answer 2

habrahabr.ru/company/io/blog/257533
and in general look at the io company blog

Answer 3

The best option is S3 cloud storage