I already wrote about some MySQL Error Messages which are confusing, here is one more:

PLAIN TEXT SQL:

1. 080603 20:53:10 [Note] Slave: connected TO master 'repl@host.com:3306',replication resumed IN log 'master-bin.003676' at position 444286437
2. 080603 20:53:10 [Note] Slave: received end packet FROM server, apparent master shutdown:
3. 080603 20:53:10 [Note] Slave I/O thread: Failed reading log event, reconnecting TO retry, log 'master-bin.003676' position 444292333
4. 080603 20:53:10 [Note] Slave: connected TO master 'repl@host.com:3306',replication resumed IN log 'master-bin.003676' at position 444292333
5. 080603 20:53:10 [Note] Slave: received end packet FROM server, apparent master shutdown:
6. 080603 20:53:10 [Note] Slave I/O thread: Failed reading …

At last night’s event, a lot of the questions were really implicitly asking, “Is open source better? Why?”

The first answer everyone comes up with is that it’s free, and that’s better.

However, that is neither necessary nor sufficient to deem it “better”.

If MySQL did exactly the same tasks Oracle did, but was free, there’s still a huge amount of money involved when migrating. Merely staffing the migration costs a lot of money.

Companies using open source technologies because they are free are (probably) making the right software choice for the wrong reason.

Firstly, open source does not have to be free — MySQL proves that. Their Enterprise source code is free to paying customers (and whoever paying customers distribute to, but that is not the issue).

Secondly, open source’s benefits far outweigh mere license costs, though the license cost is definitely the most tangible …

Post Summary: An apology with a lesson.

When Steve Curry contacted me just after the MySQL Conference and Expo asking me if I’d be interested in a community roundtable, I was excited. Not just because Steve Curry brought me an inflatable pink dolphin after I squee‘d that I needed one, although I never forget when someone does me a favor.

However, a few weeks ago it seemed like the event was more of a PR gathering than a community roundtable. I was disappointed, and told Steve as much.

And then, one of two things happened:

1) My concerns were brought up, discussed and folks decided a roundtable involving community was a good idea;
or
2) I had come up with two different pictures of the event in my mind, based on my expectations of “community roundtable” at first and “event with businesses and PR, to include …

At the MySQL Conference & Expo 2008, Britt Crawford and Justin McCarthy, both from Cafepress.com, gave us a very interesting talk on scaling with HiveDB. I took a few notes (pasted below), their slides are online (warning: 6.1MB PDF), and if you’re after their abstract its available as well.

I also took a video of them (refer to Slide 12, for the IRC conversation):

The quick notes:

• OLTP optimised (as it serves cafepress.com)
• Cannot lock tables, or take it offline
• Constant response time is more important than low latency (little slower query is ok, just not exponentially …

Just ran into the weirdest case... a client was outsourcing some of its sysadmin stuff, and in this instance their task was to set up a couple of new servers which were going to run MySQL, hence my involvement. So I was present at a meeting where this company was represented by two very capable people - they were clearly technically very clued in.

All good so far. But the actual work done by the company was... bad. 32-bit OS install on 64-bit hardware, not providing documentation on some specific setup aspects, that kind of "fun". Cause? The people I met were actually sales, and not the same as those involved in the execution of the plans. The result is a rather curious and sad story, where sales is for once more competent than technicals in the same company. Oh dear!

Almost 2 years ago, in How Open Do You Have To Be To Be Open Source? I wrote:

Google and Yahoo! are not rich because they have secrets. They are rich because they started with secrets, but I believe they could safely let their secrets out with very little loss of revenue.

Matt Asay’s recent post Google’s slow transformation into an open, transparent company made me dig up that post, which by many standards is old in terms of time, but it’s only now that some of this change is actually happening.

Matt ponders,

It remains to be seen what, if anything, Google will actually open, but I trust its track record on living up to its word more than Microsoft’s, which also went through a flurry of …

Seems to be down, only reports "500 Internal Server Error".
First time I checked it today. Honest, guv!

I've been using MySQL fulltext indexes on a table where I keep a few varchar and one text column that is used for searches. I've had it defined as:

CREATE TABLE `items_text` (
  `item_id` bigint(20) NOT NULL,
  `fts` varchar(4) NOT NULL default 'grzr',
  `author` varchar(80) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `content` text NOT NULL,
  PRIMARY KEY  (`item_id`),
  FULLTEXT KEY `title` (`title`),
  FULLTEXT KEY `author` (`author`),
  FULLTEXT KEY `fts` (`fts`),
  FULLTEXT KEY `content` (`content`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

One of my colleagues pointed out he was experiencing slow performance with this query:

select count(*) from items_text where (MATCH (title, author, content) AGAINST ('+iron +man' IN BOOLEAN MODE))

I ran EXPLAIN just to make sure that the index was being used:

mysql> explain …

I wrote this a few weeks ago and held it back until now. I decided to publish this somewhat in response to Roberto's post. While Roberto is trying to find a band-aid to the problem, I think we need to rethink the root cause of the problem. I've been blogging about OSS for nearly 2 years now. My in-the-trenches experience with OSS goes back to early 2004. The constant drumbeat of "proprietary software is dead, open source is the only path forward" has been deafening at times. I'll admit that I too used to espouse similar words. But, I am... READ MORE

Hey,

As I had mentioned in my previous blog entry about MySQL Admin and NetBeans. There, I had ended the post, with a note that I have filed an issue related to MySQL Server Node in Database Explorer.

After exchanging several mails and updating the bug report at Issuezilla. I told David, that I would be looking for a workaround, as he had set the TBD to 6.5 release. I can’t wait that long!

So, I had two options, either hack the code and fix it by myself, and use it. Else, I should look for a workaround.

I am glad that I could find a workaround for this issue. What I did, when I …