As you are probably aware, PHP 5.3.4 does not compile with MySQL 5.5 GA. The details can be seen in MySQL bug queue. Basically, the problem boils down to incorrect installation of MySQL headers. MySQL 5.5 build system does not install the headers under the include-prefix/mysql directly but instead installs under the include-prefix directory itself. So, when the PHP build system looks for the MySQL headers, it cannot find <mysql/psi/mysql_thread.h> and so forth.

What is the fix?

The MySQL dev team has committed patches to fix this issue in …

Series

What are the chances for a free software cloud?

• Resolving the contradictions between web services, clouds, and open source
• Defining clouds, web services, and other remote computing
• Why clouds and web services will continue to take over computing
• Why web services should be released as free …

Series

What are the chances for a free software cloud?

• Resolving the contradictions between web services, clouds, and open source
• Defining clouds, web services, and other remote computing
• Why clouds and web services will continue to take over computing
• Why web services should be released as free software (12/20)
• Reaching the pinnacle: truly open web services and clouds (12/22)
…

If you are fortunate enough to be in Beijing this week for Oracle Openworld, there are several sessions planned on MySQL to choose from. The English site is somewhat hard to navigate, so I humbly submit a tiny URL that will point you to the appropriate session search results.

Few act from pure motives, and I’m shamelessly plugging my own talks: Improving the Scalability of Web Applications with MySQL Replication, Performance and Scalability Enhancements in MySQL Release 5.5, and MySQL Strategy: What’s Next? (that last I’m merely technical backup for Richard Mason).

There are several other outstanding talks on MySQL migrations, tuning and Cluster as well, and of course an …

I’m back in the blogosphere!

This blog will focus on Smalltalk (mostly Pharo, Squeak, Dolphin, VAST and VW), databases (usually MySQL, PostgreSQL, SQL Server, DB2, InterBase and Firebird), algorithms and open source tools.  I’ll throw in some literature, music and mathematics occasionally.

Requirements to enjoy this blog : an interest in problem solving, a database and a Smalltalk environment!

If you are running any GNU/Linux server operating system like RHEL 5 or CentOS 5, you may probably install MySQL server that comes with the operating system packages either during the initial setup or later using yum(8). The advantage being addition/removal of packages either using the GUI package manager or rpm(8), yum(8). Fair enough. But unfortunately the MySQL package (mysql-server) that comes bundled with RHEL 5.5 or CentOS 5.5 is fairly old (5.0.77). What if you want to install the latest stable version of MySQL yet have the advantage of removing/re-installing the software using rpm(8)?

In this blog post, I will guide you with compiling MySQL from source code yet installing the software through rpm(8) so that we tune and configure the software for the target machine and yet uninstall the software using RedHat package manager.

Compiling and Installing MySQL using rpmbuild(8)

First make sure you have sudo(8) access and …

There have been a few great blog posts recently from MySQL bloggers about Postgres, and vice versa, with good comments and follow-on from the real experts in both systems. I think this is wonderful. Learning how other databases solve hard problems is highly educational, especially because ACID databases face some of the hardest problems in computing. Making MySQL better is good for PostgreSQL. The reverse is just as true. And we should also be learning from SQLite, and CouchDB, and others who have overcome tough technical hurdles, built successful companies, created thriving and enthusiastic communities, or whatever their success has been.

Related posts:

1. Postgres folks, consider the 2011 MySQL conference
2. …

On Sunday I will be in Stuttgart with the double purpose of attending the annual European PostrgreSQL conference and the technical meeting of my company that will be held after the normal proceedings of PGDay-EU.
For the first time in several years I am attending a conference where I am not a speaker. In my previous job I did not have much opportunity to attend PostgreSQL meetings, and I welcome this opportunity. The schedule is quite interesting, and I have made my personal picks:

• Monday:
  
  • 09:45 - 10:45 …

Oracle hasn't won many friends in open source communities since its acquisition of Sun Microsystems and Sun's array of open source assets, including MySQL, Java, and OpenOffice. Oracle seems bent on continuing this trend with the growing Hudson open source project.

read more

Some time ago I was asked to do a study of our most popular open source projects to assess 1) what governance models are out there and 2) if the governance model has any effect on the project's success (such as size of developer community) on the one hand and on the other hand on the business of the related vendor(s). Some of the results are quite remarkable and have general applicability, so I wanted to share them here:

read more