I came across as interesting situation with MySQL that I had not come across before. Most people would not have come across this problem either as the majority of MySQL installs are either single server based. If there are multiple servers, then they are usually the same platform or very close eg. Linux on x86 etc.

The issue I came across was actually in respect to a MySQL Forums entry and this guy who was trying to replicate from Unix to Mac OS X. The problem was explained that the replication showed the status as normal, the read_master_pos_log and the exec_master_pos_log were all fine, and the relay logs were working. There was no errors showing and the replication seemed to be going through according to all system status reports. The issue was that no data was going in to the tables.

read more

I came across as interesting situation with MySQL that I had not come across before. Most people would not have come across this problem either as the majority of MySQL installs are either single server based. If there are multiple servers, then they are usually the same platform or very close eg. Linux on x86 etc.

The issue I came across was actually in respect to a MySQL Forums entry and this guy who was trying to replicate from Unix to Mac OS X. The problem was explained that the replication showed the status as normal, the read_master_pos_log and the exec_master_pos_log were all fine, and the relay logs were working. There was no errors showing and the replication seemed to be going through according to all system status reports. The issue was that no data was going in to the tables.

read more

I came across as interesting situation with MySQL that I had not come across before. Most people would not have come across this problem either as the majority of MySQL installs are either single server based. If there are multiple servers, then they are usually the same platform or very close eg. Linux on x86 etc.

The issue I came across was actually in respect to a MySQL Forums entry and this guy who was trying to replicate from Unix to Mac OS X. The problem was explained that the replication showed the status as normal, the read_master_pos_log and the exec_master_pos_log were all fine, and the relay logs were working. There was no errors showing and the replication seemed to be going through according to all system status reports. The issue was that no data was going in to the tables.

read more

I'm scribbling this while temporarily stranded in Vancouver,
Washington. The train had electric trouble so the aircon and toilets
didn't work (and it's quite a hot day). Now go on train-sceptics,
have your laugh! But I've seen similar stuff happen in other
countries, and with airlines also. I'm quite entertained here, I like
watching people do whatever they do, and there's plenty of that here.



Amtrak has been taking good care of us with lots of cold water, ice, and popsicles... the local fire rescue has come by to check whether everybody (particularly the older people) were doing ok with the heat, and just now someone from a local TV station came by …

At OSCON next week, I'm giving a presentation entitled Making Sales While Making Friends: Lessons Learned from Open Source Businesses. I'm in the middle of preparing it, and also reflecting on some conversations I had earlier this week with sales executives from MySQL, Red Hat, JasperSoft, and SugarCRM.

In the course of those conversations, I was surprised by how differently we supposedly similar open source companies run our operations. We're each an open source company, but with varying licensing, sales, and support models. That's a good thing.

But it's also a perplexing thing if you're trying to weave together a common theme between them.

After our meeting, I spent some time on Sourceforge, pulling download data and correlating it to company revenues for these and other open source companies. After awhile, similarities started to …

Many people have complained that the new MySQL Forum misses an appropriate navigation. Now it's back:



Stay tuned - more enhancements are to come!

Mårten Mickos, CEO of MySQL AB, answers a variety of questions about MySQL AB and the MySQL Server on the german "Pro-Linux" news site. Worth a read, if you understand german...

Yesterday I received a sample copy of the "SUSE Linux 10.1 OSS - vorkon" DVD, which was assembled by Nicolaus Millin. While I have not installed it yet (as I by now have a very well running installation of SUSE Linux 10.1 on my laptop), the content of the DVD sounds very promising. In addition to incorporating all the updates that have been published since SUSE Linux 10.1 was released (around 100), this version also includes additional drivers like the 3D graphics drivers from ATI and nVidia, network card drivers like ndiswrapper, madwifi and rt2500 as well as drivers for AVM products and Logitech QuickCams. So the base system should already run very smooth …

OK, so next week is OSCON, in case you hadn't heard... I will be presenting a tutorial entitled Maximum Velocity MySQL on Monday morning, from 8:30am until noon, in room Portland 255. The tutorial will cover advanced SQL, schema and index strategies, and performance tuning topics, with lots of code examples and demonstrations. It should be a great time, and there'll be lots of giveaways, so be sure to check it out.

Additionally, there is a MySQL BoF session scheduled for Thursday evening from 8pm to 9pm in room D135. We'll be providing pizza (and probably beer if we can get our hands on some). I will be there along with Arjen and likely Brian as well. We hope to have discussions with …

Similar to the useless use of cat award. The useless use of if award highlights code examples where people use the if function or ternary operator when the return of the expression does the exact same thing. I first noticed this with returning boolean values from php functions. To protect the innocent the winner of today’s award will remain anonymous.

<anonymous> to my knowledge, youll have to SUM(IF(your_field <> “”, 1, 0)) as total_non_empty

Ignoring that the whole query should be using where your_field != ” and group by the non if() way to write this is:

SUM(your_field <> ”)

These examples aren’t an award to a specific person since I’m digging them up from my memory. This pretty much applies to both C and PHP.

< ?php

function foo()

{

$str = 'foo';

return $str == 'foo' ? TRUE : FALSE;
}

?>

Can be …