The database should be able to work fine with one million users, one million
roles. Do not keep all data in memory, load the required info on login into a
cache (size changeable without restart).

On login, load the requested data, if it is not in cache already.

Example:

SET GLOBAL USERNAME_CACHE = 1000000;
SET GLOBAL ROLE_CACHE = 1000000;

As users log in, these caches fill up. If we SET GLOBAL ROLE_CACHE=1000, this
works as a LRU for the 1000 most recently used...

Title modified.
--- /tmp/wklog.224.old.8097	2011-06-30 19:33:47.000000000 +0000
+++ /tmp/wklog.224.new.8097	2011-06-30 19:33:47.000000000 +0000
@@ -1,2 +1,2 @@
-Handle milions of users & roles.
+Handle millions of users & roles.
 

Observers changed: Sergei

High Level Description modified.
--- /tmp/wklog.224.old.3757	2011-06-30 17:55:53.000000000 +0000
+++ /tmp/wklog.224.new.3757	2011-06-30 17:55:53.000000000 +0000
@@ -9,4 +9,6 @@
 SET GLOBAL USERNAME_CACHE = 1000000;
 SET GLOBAL ROLE_CACHE = 1000000;
 
+As users log in, these caches fill up. If we SET GLOBAL ROLE_CACHE=1000, this
+works as a LRU for the 1000 most recently used...