We are evaluating openfire on virtualised Linux using VMWare. So far we had no issues. Database is installed on a mySQL hosted on a second server.
While Spark is able to re-connect when openfire server is stopped, it will loose all roster content when database server is stopped for backups.
Logging off and on will fix the issue. Is it possible to have Spark handle this?
This is due to the fact that the database is used to house information while openfire is running. If you are stopping the database while openfire is running it is bound to cause all sorts of problems. Openfire should be stopped the entire time the database is offline. That way when spark users reconnect they have a fully operational server. You can schedule the openfire service to stop prior to stopping the mysql database, and restart after the mysql is running again.