Hi -
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!