cluster db question
All nodes share the same underlying DB for user data and authentication, and I've found this(http://www.tigase.org/content/1mln-or-more-online-users-tigase-cluster):
HARDWARE USED FOR TESTS
The Tigase cluster is setup on 5 Intel ATOM N270 machines with 2GB of RAM and 16GB SSD hard drives. CPU - 32b with Hyper Threading, 1.6GHz, 1.1GB out of total 2GB of RAM are assigned to the Tigase server.
Specifically, no longer existed Dell Mini9s with slightly enhanced configuration are used for tests.
MySQL 5.1.31 database is installed on 6th - IBM Thinkpad machine.
Everything is connected through Netgear ProSafe 8 Port Gigabit Switch - GS108. Dell Mini9s use 100MB ethernet connections only and the Thinkpad uses 1GBit ethernet connection.
Does this mean that 1min online users（with tigase clusters） need only one single mysql machine（which may have 16384 max connections limit ）? thank you.
Added by Wojciech Kapcia almost 5 years ago
I think there is some mixup with quoted article - excerpt comes from http://www.tigase.org/content/xmpp-service-sharding-tigase-intel-atoms
Anyhow - Tigase uses connection pool for database connection with (by default) 10 connections for each repository (and given that you can have separate repository configuration for each domain this number MAY be greater if configured differently) so in theory one database machine should be able to handle 1 million users. Of course this greatly depends on the test scenario and how intensive on database they will be - in some cases with lots of operations that involve using database single database machine could not suffice.