Re: design distributed database

[Rick James]

100K users? Is that like saying you and I are 'users' of this forum? How many are really connected at any moment? How many queries are running at any moment?

And what are the queries like? If they tend to fetch one row using the PRIMARY KEY, you can handle a thousand of those per second per machine. If they are dumping 100K rows out of the 1M rows, that is quite another matter.

And how many queries are performed for one "connection"?

Please try to calculate queries per second. And let's see how slow those queries are.

In comparison, this forum has at least 297505 rows (3 Lakh) (see this message number), perhaps 20K registered 'users' (most of whom show up only a few times), maybe a million non-registered users. All that boils down to only a few db hits per second. The server is probably rather idle.