I am creating an online music streaming site, but I am not sure where to store the data: in a database, or in a web server, or anything else. I tried to write the data in a database, but the BLOB datatype can store only a limited size of audio files.I tried to increase the max_allowed_packet size but still I have the same error.
You can store your audio file in Aws S3 bucket.Storing media files in mysql is not a good practice as most of the db memory will be occupied by media files. More information on how to stream audio from S3 is present here Streaming MP3s from Amazon S3