1 of 1 people found this helpful
I think that this software architecture limits the maximum available throughput in writing to the DB
You are probably right, but it is much simpler to implement and does support most use cases I have experienced with minimium support issues. Most cluster-aware plugins work the same way (senior node does all write operations, while others do read operations)
Anyone knows what is the throughput of a single openfire server to a DB in terms of insert per second?
That will depend on the DB driver. Oracle will certainly outperform HSQLDB
OK i understand. So if I consider race condition and data consistency it's reasonable to make able to write all servers directly to DB?
As far as I am probably throughput offered by a single openfire writing to the DB is enough, but now i'm thinking about scalability and solutions to apply if users' number and the messages they sent grow.
Thanks a lot again