Re: Best option for blobs storage

On Sat, Mar 17, 2018 at 8:05 AM, Thierry Florac <[email protected]> wrote:

> Hi,
>
> I would like to migrate a ZODB application from ZEO to RelStorage (with a
> PostgreSQL database).
> The application (built on top of Pyramid) is deployed on a cluster of
> several web application servers (with three virtual servers using five
> application processes each) and is using many blobs to store images,
> videos...
> I was previously using ZEO blobs and until now I'm trying to use
> PostgreSQL blobs, but it doesn't seem to be as efficient and quick as ZEO
> blobs (and PostgreSQL databases become so large that their backups become
> more complicated).
>

That's interesting. Any numbers you'd care to share would be appreciated.


> So what kind of configuration would be the more efficient for RelStorage
> blobs in this situation needing a shared blobs storage?
>

The only other option with just RelStorage is to use a shared file system.

I suppose another option would be to use ZEO just for blobs, but that's a
bit unattractive because then you'd need to deal with multiple databases.

Jim

-- 
Jim Fulton
http://jimfulton.info

-- 
You received this message because you are subscribed to the Google Groups "zodb" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
For more options, visit https://groups.google.com/d/optout.