dantro Posted October 31, 2008 Share Posted October 31, 2008 hello i have a big problem dealing with shards. i would be pleased to get your ideas and practical solutions to my problem. imagine following scenario: i have 5 mysql shards, sharded by primary key. shard #1 (id 1-1,000,000) shard #2 (id 1,000,001-2,000,000) shard #3 (id 2,000,001-3,000,000) shard #4 (id 3,000,001-4,000,000) shard #5 (id 4,000,001-5,000,000) that way it is pretty easy to build a application to connect to the right shard if i have the id. now the problem: what do you do, if you consider to get your entries if you don't use primary key id. for example you want to get the entries by another key (date for example). do you have any ways to build appropriate keys to get your data on different ways out of shards ? please help me.. i hope someone already did something like that. what do you do if you sharded your data on different physical machines and want to get the data our on different ways. thank you very much dan Quote Link to comment Share on other sites More sharing options...
Daniel0 Posted November 1, 2008 Share Posted November 1, 2008 What exactly do you mean with "shard"? Quote Link to comment Share on other sites More sharing options...
dantro Posted November 2, 2008 Author Share Posted November 2, 2008 by sharding I mean partionioning of database tables Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.