A Dimecres 16 Juliol 2008, [EMAIL PROTECTED] va escriure: > I think that the first thing that you need to decide is where your > bottleneck is (if there's any). > > You can have one single PostgreSQL server and many tinyerp-servers running > against the same database. That's pretty straight forward. You can even use > some sort of load balancer in front of them if needed. > > If you have concerns about the availability of the database you can > replicate it with many different systems: - Slony is easy if you just need > to have a slave with take over capabilities in case of failure - If you
Slony has a big issue that is table definitions and such won't be synchronized to slaves. I think this is specially important with OpenERP if you want to install/uninstall new modules, etc. Once everything is stable might be ok though. > need some sort of database cluster you can use PGPoolII. With it you can > have one master and severral syncronized slaves. This setup allows you to > send INSERT, UPDATE, DELETE queries to the master and SELECTs to any of the PG Pool II can handle multiple master but with the problem of inconsitent timestamps between databases which is very good as OpenERP makes extensive use of them. AFAIK PG Pool-II doesn't do master-slave synchronization but relies on Slony or other software, but as you said can load balance queries or even parallelize them. > slaves, thus reducing the database load. - Postgres-R recently released > provides a multi-master database solution for postgres but it is somehow > difficult to set up and configure.. And probably not ready for production yet... A WAL based synchronization mechanism that is easy to setup will most probably be provided with PostgresSQL 8.4 which is due in 9 months or so. But that will probably not include being able of quering the slave and will only be useful for high availability. > Regards, > Pedro > > > > > _______________________________________________ > Tinyerp-users mailing list > http://tiny.be/mailman/listinfo/tinyerp-users -- Albert Cervera i Areny http://www.NaN-tic.com _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
