Hello I would like to know if a percona multi-master replication in three regions (servers) A, B et C will work with openfire ?
Basically, I would like to install three openfire servers in three regions (offices) sharing the same database that percona replicates over these these three servers or locations.
I would like to know if that would work and allow a user in office A on server A to chat with a second user locates in office B on server B as if they were on the same server.
I am planing on manually configure the database on two server by editing the file conf/openfire.xml
<testSQL>select 1</testSQL> "
Is there a plugin or another approach to achieve this ?