Welcome! Log In Create A New Profile

Advanced

Re: Accessing binary blob data in MySQL backend

csg
May 31, 2011 10:42AM
Igor Sysoev Wrote:
-------------------------------------------------------

> I can not say anuthing about subject, I'm just
> interesting are any
> advanatges to store images in MySQL instead of
> file system ?

First of all quite a lot of backend processes and application code relies on it. Those interfaces cannot be changed easily. But on the other hand for the ease of handling the data. For redundancy it is much easier and more performant to do MySQL replication instead of file system based approaches. With millions of files even when using deep hashed subdirectory trees a full rsync(1) run would take several hours up to half a day to perform a sync. Even when using tools utilizing the inotify(7) framework like lsyncd(1) [1] you have to run a full rsync(1) run from time (e.g., reboots due to kernel updates, inotify event overflow, etc.). With data backup you would face the same issues, too. As company policies discourage the use of AGPL-licenses software, MongoDB/gridfs is also not an option. Our current solution is Apache 2.2 MPM worker/Perl-based but on the long term this does not scale too well anymore, that's why we are looking for alternatives.

[1] http://code.google.com/p/lsyncd/
Subject Author Posted

Accessing binary blob data in MySQL backend

csg May 31, 2011 07:20AM

Re: Accessing binary blob data in MySQL backend

Igor Sysoev May 31, 2011 09:58AM

Re: Accessing binary blob data in MySQL backend

SplitIce May 31, 2011 10:08AM

Re: Accessing binary blob data in MySQL backend

Igor Sysoev May 31, 2011 10:34AM

Re: Accessing binary blob data in MySQL backend

SplitIce May 31, 2011 10:40AM

Re: Accessing binary blob data in MySQL backend

csg May 31, 2011 10:48AM

Re: Accessing binary blob data in MySQL backend

SplitIce May 31, 2011 11:32AM

Re: Accessing binary blob data in MySQL backend

csg May 31, 2011 10:42AM

Re: Accessing binary blob data in MySQL backend

mow May 31, 2011 10:54AM

Re: Accessing binary blob data in MySQL backend

csg May 31, 2011 11:05AM

Re: Accessing binary blob data in MySQL backend

Igor Sysoev May 31, 2011 11:10AM

Re: Accessing binary blob data in MySQL backend

csg May 31, 2011 11:24AM

Re: Accessing binary blob data in MySQL backend

Piotr Sikora May 31, 2011 11:52AM

Re: Accessing binary blob data in MySQL backend

agentzh June 01, 2011 12:04AM

Re: Accessing binary blob data in MySQL backend

csg June 01, 2011 02:12AM

Re: Accessing binary blob data in MySQL backend

mow May 31, 2011 11:44AM



Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 85
Record Number of Users: 6 on February 13, 2018
Record Number of Guests: 421 on December 02, 2018
Powered by nginx      Powered by FreeBSD      PHP Powered      Powered by MariaDB      ipv6 ready