We have gone through the links you posted us in detail and studied many other documentations on it as well as code. We are studying the MySQL memcached plug in code. We are trying to see the part of code where Memcached talks with innodb API. I have found the bug#20093 of MySQL also exists in Drizzle as the code bases are same. The bug is if you multiply -1 signed * 1 unsigned you get a garbage value in answer. I have solved this bug in Drizzle and i am also looking into another bug in Drizzle. If you say we can provide you the patch for Drizzle of the above mentioned bug. We will email you shortly describing our study on memcached and innoDB and our understandings. One thing that keeps un popping up in my mind is that on GSoC ideas page it is mentioned that this project is proposed for two students that is why me and my other friend (Sohair also in this mailing list) are working on it, but the ideas page suggests that one student should have good knowledge of java that is not an issue as we both know Java very well but we cant figure out where Java will sit in this project as the server layer will all be written in C/C++. Our guess is that the client side query parsing will be done in client console of Drizzle plus *IN JDBC* also. As most applications will use jdbc to connect with Drizzle, so the client side parsing (the decision to send query to SQL protocols or memcahced/handlersocket) will be decided inside jdbc and then send accordingly to server. Correct me if Drizzle has any other plans so we can also study the Java side of project in detail.
On Mon, Mar 26, 2012 at 5:24 PM, Henrik Ingo <henrik.i...@avoinelama.fi>wrote: > Hi Waqas > > Thanks for sharing your background. It sounds like your university has > very interesting curriculum! I hope that more universities would draw > this heavily upon open source code bases. Maybe in the future the > Drizzle project and your university could co-operate together, like > for the 2012-2013 semester. If your professor is interested, I could > discuss with him what to do together. > > Anyway, as for this project, if you manage to fix even one bug, then > please just share the diff. (In the case of MySQL bugs, just use that > bug tracker and then send a link to drizzle mailing list.) Reading the > diff is quite sufficient to the mentors to understand the problem that > was solved. > > Regarding Memcache API in this context, you should not only look at > Memcache itself (the cache server) but the implementation in MySQL 5.6 > that exposes a Memcache compatible API into MySQL. (So both of these > are Also-SQL solutions, just the interfaces are different.) > > See > > http://dev.mysql.com/tech-resources/articles/whats-new-in-mysql-5.6.html#nosql > http://blogs.innodb.com/wp/2011/04/nosql-to-innodb-with-memcached/ > > http://dev.mysql.com/tech-resources/articles/nosql-to-mysql-with-memcached.html > > It is worth pointing out that the Memcached chapter in the MySQL > manual currently talks about the separate Memcache cache, not the new > API that is part of MySQL. So anything they say here is not relevant > at all: > http://dev.mysql.com/doc/refman/5.6/en/ha-memcached.html > > henrik > On Mon, Mar 26, 2012 at 1:48 PM, Waqas Iftikhar <coldheart...@gmail.com> > wrote: > > Hi Mr. Ingo > > My name is Waqas Iftikhar. I am also interested to work on this project. > As > > Sohair mentioned above about me, I am a part of the team working on > MySQL in > > Software Engineering Research Centre at FAST-NU Pakistan. I am in junior > > year of BS in Computer Sciences. > > > > Well over aim was to learn MySQL code base to do further development so > > directions by our advisor were to solve few bugs of MySQL which he > assigned > > us himself that would over come our learning curve and give us insight to > > working of MySQL. Plus due to lack of time and studies burden we > proceeded > > towards the bigger goals for MySQL which our advisor had in mind rather > than > > submitting patches for the bugs. We will be providing complete > documentation > > of bugs which we have worked on shortly and we can send a patch if you > > require with screen shots in debug mode. In our work on MySQL we have > > studied authentication and all the functions related to charset in MySQL > > client. We have also looked on encryption in MySQL deeply the SHA > algorithm > > which is used to encrypt passwords. > > > > On the server side we have extensively studied the code how > MySQL receives a > > query performs different pre query processing operations, parsing the > query, > > opening up tables, acquiring lock, (a bit of solving complex joins) > > retrieving data in rows, realising lock closing tables. > > > > We both want to take part in this project as it has been mentioned on the > > GSoC ideas page that this project is proposed for two students so it > will be > > help full if both of us works together in one environment. > > > > We have been studying about Drizzle for many days now especially about > what > > you want to develop in GSoC idea. We have seen NoSQL > > protocols, Memcached and handler socket deep in detail. Memcached and > > handler socket are 2 different things and I would prefer Handlersocket > as it > > implements the technique of Not Only SQL in complete manner by running > > different servers on different ports. One listens to normal SQL protocols > > (on 3306), on the other Handlersocket listens from client (9998:read ; > > 9999:write) and then accessing the DB engine API directly. Thus avoiding > > all the overhead of SQL directory saving a lot of server work load. > > > > We have build Drizzle on Linux and now we want to start studying its code > > base deeply so we can get the idea of its working and where this GSoC > idea > > will be implemented. Can you please guide us with some > good debugging tools > > of Linux for Drizzle. > > > > On Mon, Mar 26, 2012 at 2:58 AM, Sohair Butt <buttsoha...@gmail.com> > wrote: > >> > >> Hello, > >> > >> I'm an undergraduate student currently in the junior year of my Computer > >> Science degree at FAST National University, Lahore, Pakistan. A friend > of > >> mine and I are interested in the handlersocket/memcache project idea > posted > >> on your GSoC 2012 ideas page and would like to work with you on it as > >> applicants for GSoC 2012. > >> > >> I have been working on and studying the MySQL code base for almost a > year > >> now as part of a team at Software Engineering Research Center (SERC) at > >> FAST-NU under the mentorship of our HoD, Dr. Fakhar Lodhi. The other > person > >> who is interested in this project is Waqas Iftikhar. He is also from > FAST-NU > >> and has been working with me in the team at SERC. Our work also includes > >> work on some of the bugs listed on bugs.mysql.com numbered 50675, > 50507, > >> 54034 and 20093. Over the last couple of days, I have extensively > studied > >> material regarding memcache and handlersocket online. If i'm not > mistaken, a > >> memcache solution has been introduced in MySQL 5.6 which can be of use > in > >> Drizzle. On the other hand though, handlersocket appeals more to me > since it > >> is open source, and has numerous advantages such as supporting CRUD > >> operations and maintaining data consistency, though, there is a large > >> drawback regarding security. I would like to know your thoughts > reagarding > >> this. > >> > >> Regards, > >> Sohair Tayyab Butt > >> > >> > >> _______________________________________________ > >> Mailing list: https://launchpad.net/~drizzle-discuss > >> Post to : drizzle-discuss@lists.launchpad.net > >> Unsubscribe : https://launchpad.net/~drizzle-discuss > >> More help : https://help.launchpad.net/ListHelp > >> > > > > > > > > -- > > Regards Waqas > > > > _______________________________________________ > > Mailing list: https://launchpad.net/~drizzle-discuss > > Post to : drizzle-discuss@lists.launchpad.net > > Unsubscribe : https://launchpad.net/~drizzle-discuss > > More help : https://help.launchpad.net/ListHelp > > > > > > -- > henrik.i...@avoinelama.fi > +358-40-8211286 skype: henrik.ingo irc: hingo > www.openlife.cc > > My LinkedIn profile: http://www.linkedin.com/profile/view?id=9522559 > -- Regards Waqas
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : drizzle-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
