Drizzle

Database sharding

Asked by Pavel Stratil

Hi,

I'm a dev for an application that uses directory-based sharded databases to store data. The app is built around mysql so should will work with drizzle as well. But since drizzle has its own sharding mechanisms in development, I thought of looking into it and possibly provide some native support for our app. Unfortunately, I couldn't find much information on this, could anyone tell me what is the current status of sharding support (some api yet?), what sharding schemes are/will be supported, if directory-based sharding is supported will the api allow to couple with existing sharding logic, any plans for drizzle-side management of the cluster (i.e. automatic data migration & replication)?

Thanks, Pavel

Question information

Language:
English Edit question
Status:
Solved
For:
Drizzle Edit question
Assignee:
No assignee Edit question
Solved by:
Eric Day
Solved:
Last query:
Last reply:
Revision history for this message
Best Eric Day (eday) said : 		#1

Hi Pavel,

At first, sharding will simply be a few client API calls that allow you to set a sharding key for a query, and then a server is chosen from a list based on the key (like how memcached works). Eventually we will also put the sharding key into the protocol so that a proxy or server instance could do something with the query, for example, route it somewhere or proxy it. From the application side though, the main thing you need to do is associate a query with a key.

Hope this helps, let me know if you have any other questions!
-Eric

Revision history for this message
Pavel Stratil (pavel-senbonzakura) said : 		#2

Hi Eric,

sounds great! I was worried that something more complex might be implemented which could mean that I'd have to change the partitioning code in my package to plug into drizzle's native support.

Thanks for your time,
Pavel

Revision history for this message
Pavel Stratil (pavel-senbonzakura) said : 		#3

Thanks Eric Day, that solved my question.

Revision history for this message
Vahaber (alphagoblin4) said : 		#4

i think i can help! email me!!

Revision history for this message
Sekhar (msekharmca) said : 		#5

HI epic, I am using jdbc client library. How can give Shading .where i can change the code give me one example..

Please help me..

Thanks,
sekhar