(note: see below for updates)

This is an idea I've been kicking around for a while and wanted some feedback. Memcached does an amazing job as it is but there's always room for improvement.

Two areas that memcached could be improved are local acceleration and large capacity support (terabyte range)

I believe this could be done through a "hierarchy of caches" with a local in-process cache used to buffer the normal memcached and a disk-based memcached backed by berkeley DB providing large capacity.

The infrastructure would look like this:


in-process memcached -> normal memcached -> disk memcached

The in-process memcached would not be configured to access a larger memcached cluster. Clients would not use the network to get() objects and it would only take up a small amount of memory on the local machine. Objects would not serialize themselves before …

After being "on hold" briefly for a variety of reasons, the Community Doxygen Project, which aims to "doxify" the MySQL server source code comments into standardized Javadoc commenting, is coming together.

David Shrewsbury will be leading the Doxygen Project for the community, with help from myself, Nicklas Westerlund, Frank Mash, Baron Schwartz, and Ronald Bradford. David has been working …

I am happy to announce the latest creation from foundeo: fusionKit.

fusionKit is a CD full of some handy ColdFusion components and UDF's. It is a similar concept to the DRK's that Macromedia used to sell, but is it's 100% ColdFusion.

My favorite component in the kit is the Bayesian CFC. You may recall that spam filters tend to use bayesian analysis to determine if a message is spam or ham. This CFC allows you to perform the same kind of analysis on any block of text. I am using this CFC in one of my client's blogs, and it has blocked over 4,000 spam comments in one week!

There is also the tagging CFC, which makes it easy to work with tags or …

I will be attending CodeMash in January (perhaps even as a speaker, as I put in a proposal for a session. It is a semi-local event for me, as it is in Sandusky, Ohio, which is about an hour and a half away from Columbus. Should be a great event for coders, and represents all platforms, not just Linux, so is bound to be a good event for networking with a variety of enthusiasts of all development platforms. Check it out!

My company has 9 production MySQL servers.

Our company does:

over 4 billion queries a week — an average of over 450,000 per machine, though in reality 2 servers do near 1 billion themselves, 5 do about the average, and 2 do much less (about 65k and 100k queries).

receive over 1380 GB (almost 1.35 TB!!) of data per week, an average of over 153 GB per server.

send out over 1400 GB of data per week, an average of 157 GB per server.

Our hardware is only somewhat beefy — 64-bit architecture, 3.20 GHz Intel(R) Xeon(TM) CPU, 6GB of RAM in 4 of the 5 most-used servers (4GB in the others).

We make over USD $220,000 per week ($10 billion per year) in sales for our web application.

If we bought the highest level of service, Platinum, for all 9 production machines, the cost would be 0.40% of our sales. The cost would be less than the cost of a new IT person (even a junior IT person!), and …

My company has 9 production MySQL servers.

Our company does:

over 4 billion queries a week — an average of over 450,000 per machine, though in reality 2 servers do near 1 billion themselves, 5 do about the average, and 2 do much less (about 65k and 100k queries).

receive over 1380 GB (almost 1.35 TB!!) of data per week, an average of over 153 GB per server.

send out over 1400 GB of data per week, an average of 157 GB per server.

Our hardware is only somewhat beefy — 64-bit architecture, 3.20 GHz Intel(R) Xeon(TM) CPU, 6GB of RAM in 4 of the 5 most-used servers (4GB in the others).

We make over USD $220,000 per week ($10 billion per year) in sales for our web application.

If we bought the highest level of service, Platinum, for all 9 production machines, the cost would be 0.40% of our sales. The cost would be less than the cost of a new IT person (even a junior IT person!), and …

Sometimes the NDBAPI is not perhaps the most straightforward. This might be useful if you are struggling with scan filters (filtering tuples in the ndbd kernel, like engine-condition-pushdown) in combination with strings. Please have a look at my previous blog about how to use strings in the NDBAPI.

If you are using string daratypes with the NdbScanFilter::COND_EQ then the following rules applies:

• VARCHAR and VARBINARY strings must have their length prepended (1 or 2 bytes)
• CHAR must be space padded
• BINARY must be null byte padded
  

However, for NdbScanFilter::COND_LIKE the following applies:

• VARCHAR and VARBINARY must NOThave the lenght prepended!
• CHAR must NOT be space padded
• BINARY must NOT be null byte padded

Many thanks to Pekka (MySQL) and Jim Dowling (MySQL) on this subject.

The test results that I have generated before (see my previous post) did not really help me in reaching my project goal, which is to make it possible to predict SQLbusRT's performance, reliability and scalability when it is used in an application.

In my new strategy I'm gonna take one step at a time to put the different components of SQLbusRT to the test.

My first upcoming test will involve sending messages back and forth between two processes, using the ORTE communication bus. This way, I can really measure ORTE's performance and reliability alone, without influence of MySQL. I will perform this test in different scenario's which will let me determine the scalability as well.

After having processed the results of these tests, I will include MySQL. Making these separate tests will let me determine the influence of ORTE and MySQL separately.

The new test results will of course be posted …

Today we announced a partnership with Microsoft. The goal of this technical collaboration is to make PHP on Windows a first class citizen. It has always been our goal to make PHP run well on any platform, and this initiative reinforces that. Both companies have also observed huge interest both from the community and our respective customers bases in good PHP support on Windows, and therefore, collaborating on making this happen is a no-brainer for both.

This is actually not the first time where PHP and Windows have crossed paths. Five years ago, Microsoft invited the PHP development team to come to Redmond and spend a week in their labs to optimize PHP on Windows. Zeev, Shane Caraveo and myself represented the PHP team. We actually made quite a few significant improvements but since that time, there hasn't been much focus on making PHP run well on Windows. Also, five years ago the team that invited us Redmond didn't have very much of …

MySQL AB Licenses Hyperic IT Management Technology, MySQL (Press Release)

Hyperic Gives ISVs Enterprise-Class IT Management Capability with New OEM Partner Program, Hyperic (Press Release)

Medsphere Expands Management Team To Support Growing Market Interest in OpenVista Electronic Health Record System, Medsphere (Press Release)

Helmi Technologies Joins Open Source Collaborative Eclipse Foundation, Helmi Technologies (Press Release)

Bostech’s New ChainBuilder ESB Enables Communication Between Applications in a …