We're pondering whether this is possible or whether anyone else has
done this. We would like to write records to an innodb database
(master) but have the front-end of out app interface a myisam (slave)
database. So have our app use two databases.
Reason is - we want to allow users to safely manage their records
(transactions, row locking etc... via innodb) but want their records
accessible 'speedily' via myisam.
Thanks in advance for any feedback!