Hi,

Sorry this is not a a direct SQLAlchemy question but I thought of giving it 
a shot.

I am trying to decide whether I go with consistent hashing or direct 
mapping to distribute server logs over a set of databases.

I can add a column to the servers table that points to the database that 
will store the server logs

vs

I can use a Consistent Hashing Ring that can map server_id to a database 
that will store the server logs.


The advantage of manually assigning a server to a log db instance is that I 
can distribute the logs to new servers efficiently (least loaded) and can 
avoid having a particular log db instance getting assigned new servers to 
it if it reached its capacity.

Any thoughts of either approach?


-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/sqlalchemy/-/dHDvKT0xmxsJ.
To post to this group, send email to sqlalchemy@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