[Erp5-users] (no subject)

[jp at nexedi.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?
>