Master with innodb and slaves with MyISAM

[Stefano Nichele]

Hi All,
i read an article that suggests to use innodb (i need it) on the master and MyISAM on the slave where no transactions are performed.

This for me make sense since MyISAM is really faster but, since in this way I'm not able to promote it as master in case of failure, i'm thinking to use:
Master: innodb
Slave1: innodb
Slave2: myisam
Slave3: myisam

I have still to verify if the jdbc driver is able to "forward" reads on the idler slaves, otherwise i could keep slave1 offline having a sort of master-master (active-passive).

The questions:
- what do you think about this approach ?
- how cascade on delete works in this case? I know that they work with innodb and not with myisam so i have some concerns. Is the replication able to handle this case?

Thanks a lot
ste