[asterisk-users] Playback/background audio from MySQL BLOB

Don Kelly dk at donkelly.biz
Tue Sep 23 22:53:27 CDT 2014

On Tue, 23 Sep 2014, Steve Edwards wrote:

>>  On 09/23/2014 02:17 PM, Steve Edwards wrote:
>> >  For some applications, storing recorded audio (prompts and caller
>> >  recordings) as a BLOB in MySQL has advantages.
> On Tue, 23 Sep 2014, Don Kelly wrote:
>>  I'm curious about what the advantages are of storing audio in a blob.
>>  Wouldn't it be more efficient to store it in a file and just put the  
>> filename in the database?
> Multiple web servers, multiple Asterisk servers, multiple DB servers, 
> synchronizing filesystems vs db, etc.
> It appears to eliminate some problems, but Asterisk limiting audio 
> playback to files seems like a tough obstacle.

Mike said:
Maybe make the audio files available to all servers via a single NFS
directory?  Probably not a good solution if the servers aren't co-located.

Maybe someone could write a Linux device "file" that would return the blob's
content as a file read.


More information about the asterisk-users mailing list