We are happily running an openfire cluster with the database being on an MS SQL Cluster and I now need to replicate the SQL to our disaster recovery site.
The plan was to use the inbuilt MS SQL Replication, specifically the Transactional replication. But when trying to configure it 2 table are shown as unavailable due to them not having a key. The 2 tables affected are ofMucConversationLog and ofPubsubNodeGroups.
The plan is to add a new column to each table and mark it as the key. The column would be set to auto-increment.
Can this be done without affecting openfire ?
Is there a better solution?