To add-
Make sure you migrate ALL tables AND your default table type (ie db
type) from MyISAM to innodb
ONLY innodb tables are transaction safe. If you have a multi-table
transaction where 1 table is not inno, you'll go crazy trying to
figure out why all your rollbacks seem to corrupt your database.
On Mar 1, 2006, at 4:38 PM, Perrin Harkins wrote:
If you aren't already using InnoDB tables in MySQL, try that
first. It
may save you the trouble of porting to PostgreSQL. (Nothing
against Pg,
but why port if you don't have to?) The transaction and replication