Hi Koder, On Tue, Mar 23, 2010 at 12:34:52PM +0800, koder chen wrote: > Hi, I am a student from Tsinghua University. I major in CS&T. > > I am interested in drizzle. I have built up drizzle from source code, > and gone through some basic features of drizzle. It says that, drizzle > supports > sharding among multiple points. I have not be able to go deep into the > source > code and the documents in time, so I haven't found the related modules in > it yet.
The current sharding ideas for Drizzle are mainly in the client side, with the possiblity of extending to proxy or server level for control or redirection. See: http://drizzle.org/wiki/MySQL_Differences#Partitioning_.26_Sharding > I have the idea that we can add distribution support to drizzle. It will > be a front end, > and people can use it to do distributed jobs, like horizontal/vertical > split. The user > only have to care about how the tables are splitted according to their > usage, and this > module will handle how the table slices will be located and stored in > multiple drizzle nodes, > and the query too, of course. You may also want to look at sharding at the storage engine level. This is what the Spider engine for MySQL does, and doing something similar for Drizzle could be useful. See: http://spiderformysql.com/ > It can be a client tool, or a library for usage embedded into the source > code. We can discuss > it in more details. > > The lines above are only brief description of my idea. I have developed > such a > system based on Mysql. The system is not too complicated, but it works. > And I hope > I can go further with the ideas came from the previous project, and put it > into drizzle. > > If the similar module does exist in drizzle, then I would like to choose > another project, > or to find out if there are some improvements I can do to the existed one. Nothing exists currently, mostly designs and blueprints at this point. The really interesting sharding pieces are dependant on the new Drizzle protocol, which is slightly lower priority to be completed right now, but work has started there. Best regards, -Eric _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
