The organizers of OSDC::Israel::2009 have asked me to help them find sponsors for their event.

The Open Source Developers' Conference in Israel, 2009 is planned to be a low-cost three-day muliple track conference held somewhere in Israel. The conference will be held in the beginning of 2009. Exact dates and location will be announced later on our mailing lists.

The conference theme is Open Source Tools with an emphasis on Test Automation and Quality Assurance. The talks presented at the conference will be about practical uses of Perl, Python, PHP, Ruby and some other languages and technologies.

I am particularly intrigued by the idea of the …

So I'm back from OSCON 2008. As usually it is fun conference to attend. Though I could only come for couple of days (Wed/Thu) as things are too busy here.

Same as previous year I would note the conference is not as much backend and high performance focused as MySQL Conference or even Velocity, though this year there are number of interesting talks for example about Hypertable and lucidDB.

Honestly I could visit less talks than I wanted because I had too many things to do - talk to bunch of people, staff Sphinx .ORG booth (Andrew could not come so that was on me).

Sphinx both turned out …

So... last night couple of our application servers crashed. It was apparently due to some new codes that were released although I'm not yet sure. Here is the summarize version of what transpired:

1. Sysadmin got paged that the application servers were not responding.

2. Sysadmin called the DBA team to check the database connections... We said everything looks okay on our end.

3. Sysadmin called the developers next and they found out that the new codes caused the system to go haywire.

4. When the developers tried to revert back the old codes, apparently some of them did not checked-in the older version and it caused a couple missing database privileges to occur. Also, some needed tables were also missing.

5. From that time on, we were really in trouble and sufficient to say it was a very very long night.

The lesson: maybe it is nice to test an integrated backup …

Sun Microsystems, Inc. today announced that the largest professional networking site, LinkedIn has selected Sun's MySQL Enterprise database subscription to support the company's rapid growth. With a network of more than 25 million professionals in more than 170 industries from around the globe and many more joining daily, LinkedIn turned to Sun when it recognized the need to increase the speed and performance of the open source database that powers its public Web site.

I recently posted about the results of the EDB Open Source Survey. It doesn't look like the raw data is going to be released. I was also reading about an O'reilly survey that costs $350 to see. Not that I am opposed to them making money, but I wanted to see the results and I think there are a lot people who feel the same. I have no idea if my survey is anything like O'reilly's.

Anyway, I have created a new survey. It has about 10 demographics questions asking who you are, where you are, what kind of role you have, etc. The rest are related to databases and open source. ALL data, and I mean all of the raw results, will be made available to anyone who wants to see it. I will also do some analysis and I will make that data available to any who want to see that.

All questions on the survey are optional. Feel free to skip …

Someone who should know told me that LinkedIn runs its main application on Oracle. So when I saw the press release about MySQL being their database, I read carefully, and they are not very specific about exactly what MySQL is used for. Depending on how you read it, you could argue that they left open the possibility that the main application database is not MySQL, and the MySQL deal is for something peripheral.

Hooray! The MySQL reference manual has a new search system. It now uses a Google Appliance and the results should be a lot better. The old system was not very helpful. It used to break config variables into multiple words and search on them individually and give a billion results I didn’t care about. I’ve just tried to search for some things like key_buffer_size and got results I think are very useful.

The following Lua scripts are the examples are from my MySQL Proxy @ OSCON 08 presentation.

analyze_query.lua

MySQL Proxy Analyze Query.

Requires MySQL Proxy Logging Module.

What is released is the Version for MySQL 5.0. A generic version for all MySQL versions is not yet released.

histogram.lua

This script is part of the standard MySQL Proxy examples.

Other Scripts

Additional Lua scripts from MySQL forge are available here.

MySQL Proxy got a bunch of changes in the svn-repo over the last weeks. Most of the important changes are in and we are working on making it a good 0.7.0 release.

The important changes are:

• script cache to improve the proxy performance
• central low-level decoding + lua wrappers
• plugins for proxy, admin and debug
• admin plugin is now lua based (more flexible)
• improved test coverage
• close a connection where we did throw a assertion before

Script Cache

In 0.7.0 we added a script-cache to only reload a script when it has changed and use a byte-cached version of it if it is unchanged.

This speeds up all script functionality quite nicely. No extra compile step as we did in 0.6.x when a connection was opened.

Plugins

We moved the proxy functionality into a plugin that can be loaded at startup as needed. We have at …

I have completed a rough draft of the first chapter of "Drupal Performance and Scalability". The first chapter of this online book is divided into four sections, the first of which focuses on the importance of fully defining your performance and scalability goals, helping you to identify what you need to accomplish and how to set concrete and attainable goals. The second section discusses monitoring and measuring your ongoing progress, helping you decide what you need to monitor, and how to monitor it. The …