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




Reply via email to