Skip to Content

Contributors

Session storage in S3

Hello OCA community,

As part of a multi-tenant deployment with several replicas, we are looking to persist Odoo sessions elsewhere than in the container.

We recently tested the OCA/session_db module with success, but if anyone had any experience to share on the multi-tenant side we'd be more confident ;-).

Nevertheless, since we also use the OCA/fs_storage and OCA/fs_attachment modules to store attached files in an S3 environment, we'd be tempted to use S3 instead of the DB.
Do any of you know of such a module? Is it a good idea?

I'm sure I'll have other questions about multi-tenant deployment with k8s, but I'd rather keep this to one subject per e-mail.

Thank you in advance for any help you can provide.

Stéphane Van Erp for iMio




by Stéphane Van Erp - 10:15 - 19 May 2024

Follow-Ups

  • Re: Session storage in S3
    Hello Stéphane,

    > We recently tested the OCA/session_db module with success, but if anyone had any experience to share on the multi-tenant side we'd be more confident ;-).

    We have good experience with session_db. It has the advantage of being simple to deploy.
    Multi-tenant is not an issue provided you use a dedicated db for sessions.
    Do you have specific worries regarding multi tenancy?

    Intuitively I suspect session_db or session_redis would have better performance than an s3 solution, but I'd be interested about the results if you do any measurements.

    Best regards,

    --
    Stéphane Bidoul

    On Sun, May 19, 2024 at 10:16 PM Stéphane Van Erp <notifications@odoo-community.org> wrote:
    Hello OCA community,

    As part of a multi-tenant deployment with several replicas, we are looking to persist Odoo sessions elsewhere than in the container.

    We recently tested the OCA/session_db module with success, but if anyone had any experience to share on the multi-tenant side we'd be more confident ;-).

    Nevertheless, since we also use the OCA/fs_storage and OCA/fs_attachment modules to store attached files in an S3 environment, we'd be tempted to use S3 instead of the DB.
    Do any of you know of such a module? Is it a good idea?

    I'm sure I'll have other questions about multi-tenant deployment with k8s, but I'd rather keep this to one subject per e-mail.

    Thank you in advance for any help you can provide.

    Stéphane Van Erp for iMio



    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe


    by Stéphane Bidoul - 11:16 - 21 May 2024
  • Re: Session storage in S3
    We use session_redis
    
    https://github.com/camptocamp/odoo-cloud-platform/tree/16.0/session_redis
    
    Alexandre Fayolle
    
    On 19/05/2024 22:16, Stéphane Van Erp wrote:
    
    > Hello OCA community,
    
    > 
    
    > As part of a multi-tenant deployment with several replicas, we are 
    
    > looking to persist Odoo sessions elsewhere than in the container.
    
    > 
    
    > We recently tested the OCA/session_db module with success, but if anyone 
    
    > had any experience to share on the multi-tenant side we'd be more 
    
    > confident ;-).
    
    > 
    
    > Nevertheless, since we also use the OCA/fs_storage and OCA/fs_attachment 
    
    > modules to store attached files in an S3 environment, we'd be tempted to 
    
    > use S3 instead of the DB.
    
    > Do any of you know of such a module? Is it a good idea?
    
    > 
    
    > I'm sure I'll have other questions about multi-tenant deployment with 
    
    > k8s, but I'd rather keep this to one subject per e-mail.
    
    > 
    
    > Thank you in advance for any help you can provide.
    
    > 
    
    > Stéphane Van Erp for iMio <https://imio.be>
    
    > 
    
    > 
    
    > 
    
    > _______________________________________________
    
    > Mailing-List: https://odoo-community.org/groups/contributors-15 
    
    > <https://odoo-community.org/groups/contributors-15>
    
    > Post to: mailto:contributors@odoo-community.org
    
    > Unsubscribe: https://odoo-community.org/groups?unsubscribe 
    
    > <https://odoo-community.org/groups?unsubscribe>
    
    > 
    
    
    -- 
    Alexandre Fayolle
    Senior Software Engineer
    Tel : +33 4 58 48 20 30
    
    Camptocamp France SAS
    18 rue du Lac Saint André
    73 370 Le Bourget-du-Lac
    France
    
    http://www.camptocamp.com
    
    

    by Alexandre Fayolle - 08:53 - 21 May 2024
  • Re: Session storage in S3
    Hello

    Not tested but I would mount session folder (as we actually do with filestore in our infra) with nfs in your containers
    Maybe there will be some security issues with that...
    I let experts give their pov

    Best regards

    --------------------------------
    Cyril VINH-TUNG
    INVITU
    Computer & Network Engineering
    BP 32 - 98713 Papeete - French Polynesia
    Tél: +689 40 46 11 99
    contact@invitu.com
    www.invitu.com

    Le dim. 19 mai 2024, 10:16, Stéphane Van Erp <notifications@odoo-community.org> a écrit :
    Hello OCA community,

    As part of a multi-tenant deployment with several replicas, we are looking to persist Odoo sessions elsewhere than in the container.

    We recently tested the OCA/session_db module with success, but if anyone had any experience to share on the multi-tenant side we'd be more confident ;-).

    Nevertheless, since we also use the OCA/fs_storage and OCA/fs_attachment modules to store attached files in an S3 environment, we'd be tempted to use S3 instead of the DB.
    Do any of you know of such a module? Is it a good idea?

    I'm sure I'll have other questions about multi-tenant deployment with k8s, but I'd rather keep this to one subject per e-mail.

    Thank you in advance for any help you can provide.

    Stéphane Van Erp for iMio



    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe


    by Cyril VINH-TUNG - 10:46 - 19 May 2024