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
"
com.mysql.jdbc.Driver
jdbc:mysql://172.68.25.211:3306/openfire2?rewriteBatchedStat$
19e11dd4a2c68678fff69940d731b521695c437cf08887$
755368eabf6cc8af0e689d5ea330dedcb249d87fe7aa7c$
select 1 "
Is there a plugin or another approach to achieve this ?
Thanks.