My app connects to a remote MySQL database without any problems on shinyapps.io, however, after some unknown time span, the app does not start up anymore, sometimes with the error message that the connection to the database failed. Restarting the app on the shinyapps.io dashboard helps, for some time, until some time later, start up fails again due to time limitation.
The app runs without any problems on my machine. The database is tiny and no demanding computations are required upon start up. I use the R package RMySQL to connect to the database. My database is not restricted to specific IP addresses. I set the time limit for start up to the maximum value (300 seconds).
Any thoughts? Thank you for your replies.