I am building an online booking system and would like to know what is the best way to tackle this problem. The booking application is always going be accessed by the ticket office staff and not the end users. The internet connection at the ticket office can drop intermittently for few minutes. I don't want the booking system to be unavailable during this period. I want to make sure the web application is able to run offline more for a short period without affecting the on going transaction or the bookings. Application will be using a Mysql Database.
Can someone please enlighten me on what's the best way to do this or guide me on the right direction?