AnsweredAssumed Answered

Percona Multi-Master replication and Openfire

Question asked by Chris on Jun 29, 2016
Latest reply on Jul 7, 2016 by Chris

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

 

"

<defaultProvider>

      <driver>com.mysql.jdbc.Driver</driver>

      <serverURL>jdbc:mysql://172.68.25.211:3306/openfire2?rewriteBatchedStat$

      <username encrypted="true">19e11dd4a2c68678fff69940d731b521695c437cf08887$

      <password encrypted="true">755368eabf6cc8af0e689d5ea330dedcb249d87fe7aa7c$

      <testSQL>select 1</testSQL> "

 

Is there a plugin or another approach to achieve this ?

Thanks.

Outcomes