I've always used Postgres, but don't think the copyright assignment thing is that big a problem. The FSF does that, and it seems to work out ok.
The FSF uses copyright assignment to ensure that open source code is not legally encumbered.
MySQL uses the copyright assignment so they can sell code contributed by open source developers in their commercial platform without compensating the authors.
Looks like InnoDB supports transactions, no? http://dev.mysql.com/doc/refman/5.1/en/innodb-transaction-mo...
"MySQL doesn’t support DDL transactions;"
Meaning you can't change the schema transactionally. InnoDB handles data transactions ok, but I hadn't realized that it doesn't handle schema changes. It seems like I'm always discovering some little nasty about Mysql when I am forced to use it.