From posgrado at correo.chapingo.mx  Wed Mar 20 05:28:48 2013
From: posgrado at correo.chapingo.mx (posgrado)
Date: Wed, 20 Mar 2013 04:28:48 +0000
Subject: [Erp5-users] (no subject)
Message-ID: <21EEB69A5D57164B936A5969225DA4FA08A7C789@SN2PRD0202MB176.namprd02.prod.outlook.com>

Hello
Could you tell me if ERP5 works with ZODB, NEO and MYSQL? Because in some sites I found that ERP5 works with them or ERP5 only works with MYSQL or NEO or ZODB?
If ERP5 works with ZODB, NEO and MYSQL how do they work?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.tiolive.com/pipermail/erp5-users/attachments/20130320/b9156613/attachment.htm>

From vincent at nexedi.com  Wed Mar 20 10:55:30 2013
From: vincent at nexedi.com (Vincent Pelletier)
Date: Wed, 20 Mar 2013 10:55:30 +0100
Subject: [Erp5-users] (no subject)
In-Reply-To: <21EEB69A5D57164B936A5969225DA4FA08A7C789@SN2PRD0202MB176.namprd02.prod.outlook.com>
References: <21EEB69A5D57164B936A5969225DA4FA08A7C789@SN2PRD0202MB176.namprd02.prod.outlook.com>
Message-ID: <20130320105530.50579a97@vincent-tkpad>

Hi.

On Wed, 20 Mar 2013 04:28:48 +0000,
posgrado <posgrado at correo.chapingo.mx> wrote :
> Could you tell me if ERP5 works with ZODB, NEO and MYSQL? Because in some sites I found that ERP5 works with them or ERP5 only works with MYSQL or NEO or ZODB?
> If ERP5 works with ZODB, NEO and MYSQL how do they work?

To clear up a bit:
- ZODB is an object database, which can be stored in a variety of ways,
  typically using "FileStorage" (a single big file with all object
  data, plus an index to accelerate access to object and which can be
  generated from the big file).
- NEO is an alternative storage for ZODB, replacing FileStorage and ZEO
  (a network layer which cen be used between ZODB and FileStorage to
  share access to a single database) because NEO includes such network
  layer.
- MySQL (nowadays we prefer MariaDB) is the well-known relational
  database.

ERP5 needs both an object database and a relational database to work.
The object database contains the actual data, and the relational
database contains extracts of those objects and relations between them
to be able to look objects up efficiently.

So the answer is yes, ERP5 works with all these. ZODB and MySQL/MariaDB
are strictly needed, and NEO can be used optionally if you need the
scalability and/or resilience.

Regards,
-- 
Vincent Pelletier
ERP5 - open source ERP/CRM for flexible enterprises

From jp at nexedi.com  Wed Mar 20 11:45:56 2013
From: jp at nexedi.com (jp at nexedi.com)
Date: Wed, 20 Mar 2013 11:45:56 +0100
Subject: [Erp5-users] =?utf-8?q?=28no_subject=29?=
In-Reply-To: <21EEB69A5D57164B936A5969225DA4FA08A7C789@SN2PRD0202MB176.namprd02.prod.outlook.com>
Message-ID: <20130320104557.C575DBF033D@mail2.tiolive.com>

Hi,

ERP5 uses ZODB to store/retrieve persistent objects and a relational database to index objects. Such an architecture in which object storage is sharded over multiple hosts and while each index is stored in RAM on a single host is now recognized by researchers as the most scalable one for large enterprise applications (see keynote of Prof  Amr El-Abbadiof University of California at  Cloudcom 2012 - http://grid.chu.edu.tw/cloudcom2012/speakers.html)

MariaDB (or MySQL) is the preferred relational database for the index in ERP5. There has been tests with PosgreSQL, SQLLite and Oracle too, but peformance was not as good in our case. The index is used mostly for searches and reports.

ZODB preferred implementations for ERP5 are FileStorage, ZEO and NEO. 

FileStorage stores persistent data directly to the filesystem. ZEO adds a layer of networking which helps building clusters. FileStorage and NEO have been extremely reliable over the last 10 years and were used to implement ERP5 based mission critical systems for banks, payment, tax office, etc. 

For very large data, NEO provides a fully distributed implementation of ZODB. NEO itself relies on MariaDB, SQLLite and soon more backends to store/retrive persistent data There are other implementations of ZODB, some of which rely on relational database (Oracle, MySQL) or on filesystem.

NEO has now been stable for one year on a terabyte database. Within a probably a year, NEO will likely become the single preferred implementation of ZODB for ERP5. It will then migrate to a socket-less vesion of MariaDB such as HailDB or MariaDB embedded. 

Does this answer your question ?

Regards,

JPS.


> Hello
> Could you tell me if ERP5 works with ZODB, NEO and MYSQL? Because in some sites I found that ERP5 works with them or ERP5 only works with MYSQL or NEO or ZODB?
> If ERP5 works with ZODB, NEO and MYSQL how do they work?
>