I have developed an application win/mac with RS using a mysql database on my VPS. Sometimes my connection gets broken and my app seems to lock up. I've the timeout to 60sec but after this time out the app seems to work but is not able to access the database anymore, so I think it cannot recover the connection.

I open the database in the App.Open event. What is a good practice to keep a healthy connection? There doesnt seem to be a db.reconnect method. Or is it a good way to setup a time that periodicly checks if the db is still connected and if not connects again?