My virtual machines usually have nothing to do between 7pm until midnight when they reschedule a lot of work for the rest of the day. The scheduling starts with fetching a list of tasks and times from a MySQL database. Is it possible for the Virtual Machine to go cold and then struggle to connect to the database at midnight? I seem to have a problem with connecting to the database at midnight consistently, but it usually works fine during the day when the Virtual machine has steady tasks to execute.
Should I have a "warm up" procedure every 10 minutes to do a simple database call to keep the Virtual Machine and database "warm"?
Anyone else find anything similar? I know that Azure WebSites have a similar concept and can go "cold/warm" depending on usage, so first user usually get's bad loading times as the website is powering on.