I gave a talk about sharding at the International PHP Conference 2008. I started with a short introduction about the problem that sharding tries to solve. Most of the talk was about the actual implementation and problems that people might run into if they try to use sharding in their projects. Ulf already gave a about optimization possibilities using mysqlnd’s ability to do asynchronous queries. And last but not least, it was nice to have the ability to talk to Jan or other people, who gave me interesting new ideas on sharding. The slides of my talk can be found here. Feel free to comment.
I didn’t use distcc for quite a while. Usually modern dual or quad CPUs are fast in enough to compile in a reasonable time, but after compiling PHP 100 times, I wanted to make things faster and use distcc with my server which otherwise just idles around. My laptop, where I usually compile PHP, is a 1.2Ghz dual core with 2gb ram running Ubuntu 8.10 beta. The server is an up-to-date Gentoo on a 2.7 Ghz dual core with 4GB ram. If you install distcc, which is pretty straight forward, and start compiling you might run into the following error:
/usr/include/bits/stdio2.h:98: undefined reference to `__builtin_va_arg_pack’