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 ?

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 ?

I am looking for MySQL High Availability with huge transactions. So I am preferring to go with Innodb Engine.

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

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.

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 ?