…and it seems to work. Sorry for the 30 minute downtime because of that.
We are planning to migrate Pubsub/PEP (Publish-Subscribe / Personal Eventing Protocol) from Mnesia to MySQL in the very near future, which means the next two days.
Unfortunally there is no export/import script, so all data will be lost. It is also impossible to export own data from a client, at least I was told so.
Migration should fix some problems with PEP, also MySQL allows more administration and has less resource overhead.
The server was offline this morning because of Kernel and MySQL upgrade. It would have happened faster if the server rebooted cleanly after “shutdown -r now” which it didn’t. So we had to send someone there to reset the machine manually.
We also upgraded Spectrum to support JID escaping. If this works after our tests (there seem to be some problems with clients who don’t support the unofficial % character which is used for @) I write more about this here.
The switch to MySQL was used to test virtual hosts on the Jabber server which works really great.
Next to the primary domain jabber.hot-chilli.net this domain was added for public use:
Some time later two extra domains for public use were added:
We also offer Jabber hosting for private domains.
On December 22nd, 2008, we switched the ejabberd daemon from Mnesia storage to MySQL storage.