How many tables can a cluster realistically handle or how many tables/node can be supported? I am looking for a realistic idea of whether a 10 node cluster can support 100 or even 500 tables. I realize it is recommended to have a few tables at most (and to use the row key to add everything to one table), but that is not an option for us at this point. What are the settings that need to be tweaked and where are the issues going to occur in terms of resource limitations, memory constraints, and OOM problems? Do most resource limitations fall back to total active region count regardless of the table count? Where do things get scary in terms of a large numbers of tables?
Thanks in advance for any advice that can be provided.
