v2 can use Innodb or MyISAM. Innodb doesn't lock the table, but takes a little longer in some circumstances. You're not only limited to MySQL either, Postgres is also supported aswell as SQLite. I'll add support for any DB if there is demand ;)Do you have any performance data for policyd using postgres vs mysql? It seems that postgres 8.3.0 fares well against mysql in a number of scenarios now.
I think everyone with large installations can definitely agree Postgres is a great workhorse. I don't have any hard evidence or proof, but my personal findings is with a table containing a few million rows it was a few % faster across the board. Postgres is very configurable aswell.
Advantage with mysql is the replication. 1-to-1 multi-master between geographically different locations is a sure nice feature when doing something like MX backups.
-N
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Users mailing list [email protected] http://lists.policyd.org/mailman/listinfo/users
