Actually, It's more like this (M=, Z=, ..., Y= ~1000):

  database_shard_1:
    -- table_circle_1
    -- table_circle...
    -- table_circle_M
    -- table_....
    -- table_square_1
    -- table_square...
    -- table_square_M

  database_shard_...:
    -- table_circle_M+1
    -- table_circle...
    -- table_circle_Z
    -- table_....
    -- table_square_M+1
    -- table_square...
    -- table_square_Z

   database_shard_N:
    -- table_circle_Z+1
    -- table_circle...
    -- table_circle_Y
    -- table_....
    -- table_square_Z+1
    -- table_square...
    -- table_square_Y

table_circle_<number> all share the same table definition, but have
different names (numbers). Same goes for table_square_<number>, etc.
The number in table_square_<number> is used to determine which shard
to look in (1...N). Each shard is responsible for a range of numbers.

--diana
-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.


Reply via email to