Solution similar to MERGE for InnoDB?

[Jon Langevin]

Are there any solutions similar to the MERGE engine, for providing fast data retrieval from an InnoDB table?

I am considering building an application based on InnoDB so that I can take advantage of the foreign key constraint feature, to reduce room for error. So essentially, I want to use InnoDB for the application backend (where data will be entered), but have a faster retrieval method for the frontend.

Can anyone point me to the solution that I'm looking for?

Thanks!