I've done some benchmarking today with eZ publish CMS and MySQL running a process inserting articles (objects) into the CMS system. I ran the test on both the standard GCC compiled version of MySQL and the Intel ICC compiled version. The total process was 11.9% faster and the MySQL part was 20.2% faster. So atleast on heavy write operations the ICC compiled version of MySQL is running faster with eZ publish. This is good news for people running write intensive eZ publish sites. When testing with read queries I did not see that much of a difference, I will do more tests on heavy read intensive operations to find where …

Now that master is all set! Its time for the slave to obey the master. To setup the slave, We need to tell the Slave server which log file it is supposed to read, and yet again we need to give a unique server-id to the slave.

So open the /etc/my.cnf and add the following below the [mysqld] section.

server-id=2
replicate-do-db=test
report-host=slave-server-1

read more

Now that master is all set! Its time for the slave to obey the master. To setup the slave, We need to tell the Slave server which log file it is supposed to read, and yet again we need to give a unique server-id to the slave.

So open the /etc/my.cnf and add the following below the [mysqld] section.

server-id=2
replicate-do-db=test
report-host=slave-server-1

read more

LinuxWorld shows are all over the world now, and this year for the first time: Sydney Australia. Later this morning, I'll be speaking in the "business models" panel of the conference - people are always curious how and where we thrive. Should be interesting.

Right now I'm listening to Monica Kumar from Oracle. As Matt Asay noted recently, she's a good speaker - and of course much prettier than me ;-)
I aim to say hi later, put on my own charm, and who knows... perhaps I'll convince her to try OUR free database product!


At the exhibition, MySQL partner HP has a big pavilion. MySQL is of course part of HP's reference architecture.
The local free/open source and IT industry organisations (Linux Australia, OSIA, AUUG, …

To configure the master we need to start binary logging, and some minor tweaking. Before we move ahead, I assume that you have the root or Administrator access to the sytem where you are setting up replication. First let us setup the Binary logging.

read more

If you are here reading Replication for MySQL, if you know what type of replication is available in other databases, then it may be a bit troubling for you to understand. However, One point will make everything clear.

In MySQL replication is that of the Binary Log, which has user's commands logged in it.

Generally replication is used when there are many servers to balance the load and have the same data. In such cases, Usually A single master and multiple Slaves are used.

So let us consider we have 3 servers,

• Server A: The Master Server (192.168.5.100)
• Server B: The Slave Server no. 1 (192.168.5.101)
• Server C: The Slave Server no. 2 (192.168.5.102)

The Servers B and C are peers to each other.

read more

We were fortunate to have Adam Bosworth come to the MySQL Developer's Meeting. Of the different topics he spoke on, one was on his six F system (and we are about to see how badly I can misremember the system more then a week later).

The six F's are:
Fame
Fortune
Family
Fun
Freedom
Force

He measures new hires on these and believes that companies are directed by two of these. The point is to find out where the developers are with their life in regard to these six points during interviews. Companies should define what their two F's are and hire people based on these. The idea is to align both company and people so that there is a clear set of goals. It is all about optimizing and setting the right expectations.

Fame is self explanatory, the same with Fortune (and this is really only possible with those first few employees, after that the measure of this shrinks …

Now that I have PBXT running under both Mac OS X (Power PC) and Linux, I have posted the source code. Here is the download URL:

http://www.primebase.com/xt/download/mysql-4.1.16-pbxt-0.9.1.tar.gz

As the name suggests, the engine has been integrated into MySQL 4.1.16 (the nightly build of November 4, 2005). I have labeled this version Alpha since it is almost feature complete, but please check my to-do list before you build and run it:

http://www.primebase.com/xt/download/pbxt-to-do.txt

Here are some brief instructions for building MySQL with PBXT:

http://www.primebase.com/xt/download/how-to-build.txt
…

A couple of really nice articles mentioning my forthcoming book, No Lobbyists As Such - The War over Software Patents in the European Union, have been published during the last several hours:

Jay Lyman wrote a very comprehensive and competent review for NewsForge.

W. David Gardner wrote that the book “foretells a new crusade” against software patents in Europe. Dave’s article, which succeeds in putting my book into the current political perspective, first appeared on TechWeb, then also on ITNews.com.au, an Australian site that belongs to the same network (CMP), and on …

Today I took a break from software engineering. Besides a few meetings and a few small code tweaks I spent the bulk of the day looking at MySQL Cluster in 5.1.7.

I've set up a cluster a handful of times now so it's fairly familiar. From scratch to having three boxes (one Fedora Core and two Red Hat ES 4) and MySQL 5.1.7 installed took until ~10:30. At this point I was walking from the server room back to my desk when I noticed a conference room full of engineers. A 10am meeting that I thought was pushed back to 2 wasn't. Oops.

A few hours later I was loading sets of data from our production database to see just how well the data moves from 4.0 to 5.1. I haven't completed any comprehensive tests, but I wasn't impressed with performance when restoring from a dump file. Perhaps I need to do some cluster tuning, or the cluster is just slower at DDL. Next I'd like to grab some sample sets of queries from production and run them against …