Project: MySQL Forge RSS/Atom feeds

KEY ACCOMPLISHMENTS LAST WEEK

* Already subscribed to MySQL mailing lists (gsoc and internal).
* Contacted my mentor and got instructions about how to set up a local working copy.
* Read documentation about Bazaar, the version control system
* Installed linux (Debian) on my PC, to make a local development environment possible * Started looking at and playing with the source code. * Registered a blog, http://gsoc-forge.blogspot.com/ where I will publish the weekly reports and maybe more. * Installed a local working copy of Forge on my system.

KEY TASKS THAT STALLED LAST WEEK

None....

KEY CONCERNS

My university classes haven't finished yet. Here in The Netherlands we have classes until the end of June. So I have less time available as I …

The next bug-fix release of MySQL Workbench is coming up this week. Tax is still working on the build, we had some unit tests failing that are now passing again. Apart from the usual bug fixes this will be the first release created out of our new Bazaar repositories, http://bazaar-vcs.org/

The team has been relying on the SubVersion source version control system which worked great for us during the last years. But as we did the branching for MySQL Workbench 5.1 we decided that it is time to move to a more advanced system. We have been looking at Mercurial http://www.selenic.com/mercurial/wiki/ but decided to go with Bazaar instead which performed excellent in our tests.

We hope to finish the WB 5.0.22 release by tomorrow and then it will take 24h for the mirrors to catch up.

Key Accomplishments

1. Opened mysql slap and went through the code
2. Read through and attempted a few tutorials http://blogs.techrepublic.com.com/howdoi/?p=133
3. Ran through a few basic tutorials regarding mysql development
4. Learnt about bitclient and the method of committing the patches into the main release.
5. Installed cygwin and obtained the latest 5.1 source distribution.

Key Tasks That stalled last week

• None So far.

Key Concerns

1. Some more documentation or a few tips would definitely help.
2. Also if you are good at database benchmarking , then please do to contact me at taufiqaalam@gmail.com

Tasks in the Upcoming Week

1. Understand the mysql …

Key Accomplishments

1. Opened mysql slap and went through the code
2. Read through and attempted a few tutorials http://blogs.techrepublic.com.com/howdoi/?p=133
3. Ran through a few basic tutorials regarding mysql development
4. Learnt about bitclient and the method of committing the patches into the main release.
5. Installed cygwin and obtained the latest 5.1 source distribution.

Key Tasks That stalled last week

• None So far.

Key Concerns

1. Some more documentation or a few tips would definitely help.
2. Also if you are good at database benchmarking , then please do to contact me at taufiqaalam@gmail.com

Tasks in the Upcoming Week

1. Understand the mysql …

From May 28th-31st, the annual LinuxTag will take place in Berlin, Germany. I followed the growth and evolution of LinuxTag from the very early days and I have fond memories of the event back when it still took place at the University of Kaiserslautern and our SuSE "booth" was just a regular table taken from the lecture rooms...

Things have evolved a lot since then. Today, LinuxTag is one of the largest Linux/Open Source Events in Europe and my new employer Sun is a major sponsor this year. In addition to several talks and keynotes, there will be a large Sun booth in the exhibition area (Booth #205) and we will have a dedicated MySQL demo pod! Some of the things we plan to demo there are the upcoming MySQL Server releases (5.1, …

Let the coding begin! The Google Summer of Code 2008 coding session has begun.

I am maintaining this blog as a way of recording my progress for others to follow (and to prevent me from slacking off).

I am working on integrating Memcached with the MySQL Query Cache (mentored by Brian Aker from MySQL)

I've done some bonding through the mailing list, blogs, and IRC but I feel I should have done a bit more. I just moved back from college to my parents house and started working full time in Boston (wow what a commute). I've read through the code a few times and feel I have an understand for how it works. It compiles, tests, and runs on my dev box (gentoo 2.6). I've started reading the book Google sent me (SPOILER) and it is wonderful.


In reading through the MySQL codebase I've come up with a list of design decisions I will …

I was contacted this week by a previous client regarding a failure of processing data. This was a Contact, Financial and Media Management system I developed for a non-for-profit organization a LAMJ stack, and I’ve had to do nothing since deployment in the past 3 years, no bug fixes, no feature enhancements. The only thing lacking is additional management reporting, and data is extracted for this option now.

It runs under commodity Hardware, Linux and MySQL and it’s only unscheduled downtime was an power failure before UPS power was installed. However this all changed last week. Processing of regular scheduled encrypted data simply failed unexpectedly.

A summary of the environment.

• Data is inserted with AES_ENCRYPT(data,key);
• Data is retrieved with AES_DECRYPT(data,key);
• Data is never updated.
• New data is always added, and historical data always remains.
• The …

Long ago I wrote a 100-page book on MySQL 5.0 stored procedures. It’s on our dev-zone pages. But it’s out of date. In 2006 I made some corrections for MySQL 5.1. It took me a long time to publish the revised book, but here it is: http://blogs.mysql.com/peterg/files/2008/05/book01.pdf.

I finally have some images to show you what my improved Cacti templates look like.

These aren’t a perfect demo, since for example this server doesn’t have the query cache enabled, but it should show you what I’ve done. Note, for example, that each graph is labeled with the actual values of the images drawn on it. You don’t have to guess what the values are by squinting at the graphs.

You can click on any image to go to a larger version. Enjoy:

…