I am looking for MySQL High Availability with huge transactions. I prefer to go with InnoDB Engine.

I prefer to use MySQL Master - Slave Replication. However, this option provides us Manual fail over of Application from Master to Slave.

#QUESTIONS

• What could be the maximum difference time to have Sync between Master and Slave ?
• Is there any option of having High Availability other than this approach ?