[Erp5-users] [showcase] Data Publica project

[Kazuhiko Shiozaki]

Hello,

For those who are interested in how the official buildout is used in
real projects, I would like to introduce Data Publica project.
http://www.data-publica.com/

Base system : Mandriva 2009.1 x86_64
Building softwares : using the official buildout 'as it is'

And here is the list of software components that are used in Data Publica.

Zope : 2.12.14
SQL : MariaDB 5.2.4
Fulltext : SphinxSE 1.10-beta (so-called real time index)
Persistent cache : kumofs with file based storage
Volatile cache : kumofs with RAM based storage
Document conversion : cloudooo-1.10 (released today, bravo!)

It is the first real ERP5 project where MariaDB and SphinSE are used, AFAIK.

As you may already know, both 'software building' recipe and 'instance
creation' recipe for all of these softwares are already included in the
official buildout.

My development laptop is using Mandriva 2010.2 x86_64, and my another
testing laptop is using Ubuntu 10.10 i386, and everything is running
fine in all of these three different environments, thanks to fully using
the official buildout.

I attach the except of buildout.cfg file used in Data Publica, that is
enough to create supervisord.conf for all of these instances described
above. Yes, it shows exactly how to create a 'SAMPLE FUNCTIONING
supervisor.conf' file. It is really simple, isn't it?

And for those who are interested in technical details, I continue. :)

MariaDB is working quite well, just as the drop-in replacement of
MySQL-5.1. Since Data Publica project is using SphinxSE as fulltext
index, we use InnoDB in full_text table without fulltext key.
(see erp5_full_text_sphinxse_catalog business template).

But for those who don't/can't use SphinxSE, using Aria storage engine in
full_text table can be interesting, because Aria is in a sense 'crash
safe' MyISAM.
http://kb.askmonty.org/v/when-will-transactional-fulltext-indexes-be-ready
If somebody here tries Aria storage engine in full_text table, I'm very
interested in your impression. :)

We don't try XtraDB yet, but it can be also interesting for high load
project where rich hardwares are used. Switching from InnoDB to XtraDB
is quite easy, just by using ha_xtradb.so plugin instead of
ha_innodb_plugin.so.

Thanks for reading.
-- 
Kazuhiko Shiozaki, Nexedi SA Senior Consultant
Nexedi: Consulting and Development of Free / Open Source Software
http://www.nexedi.com
ERP5: Full Featured High End Open Source ERP
http://www.erp5.com
ERP5 Wiki: Developer Zone for ERP5 Community
http://www.erp5.org
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: buildout.cfg
URL: <http://mail.tiolive.com/pipermail/erp5-users/attachments/20110114/cb2ccef4/attachment.txt>