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:

…

learning the 5 string banjo

Originally uploaded by Elliot Murphy

This week Sun will host the first two free webinars on MySQL and Memcached. Ivan Zoratti will kick off on Wednesday with "Highly scalable solutions with MySQL and Memcached".

On Thursday Monty Taylor, Jimmy Guerrero and Frank Mash will talk about "Designing and Implementing Scalable Applications with Memcached and MySQL".

You should do as I did and register for the event as soon as possible :-)

My Sakila Cube (black)
Originally uploaded by Geert JM VanderkelenThis is maybe an old idea, but still great to do! Thanks to Ronald's tip I could make the cube you see here. Just pure fun!

Check out how to do on Ned Batchelder's site!

(Also thanks to Ronald Bradford, I can walk the earth with my good walking shoes! )