1 Reply Latest reply on Jul 7, 2016 3:56 AM by Chris

    Percona Multi-Master replication and Openfire

    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.