First, the reason I haven't been blogging as much

I haven't been blogging nearly as much recently because my blog software has become almost unusable. I have been getting on average 500 spam comments and trackbacks per day, which makes actually posting comments to my blog pretty much useless, since they get lost immediately (damn those spammers!)

I plan on switching over to a new version of Wordpress in the coming week or two (hopefully before OSCON, but no promises). If anyone has read this blog for a while (over a year), you'd know I have gone through a number of blog software solutions, including Wordpress, Seredipity, and my own home-grown solution (a miserable failure in terms of functionality). I am going to try the new version of Wordpress and see if it helps. I mean, the purpose of blog software should be to enable the writer to write, as easily as possible, with few distractions (like spam). Hopefully the …

One of my "part time" roles is a sysop on the Quest MySQL Pipelines, as I have mentioned on here before we don't get many posts unfortunately and I can only assume that's because MySQL have such great forums of their own.

Anyway, Quest produce a product called Spotlight on MySQL which is a rather cool looking monitoring tool for MySQL. Personally I haven't had the chance to use it but the development team are currently looking for feedback on Spotlight on MySQL, with particular interest in if there is need for replication support.

So if you have anything to add pop over to the forum and let the guys know in the Spotlight on MySQL section.

http://pipetalk.quest-pipelines.com/default.asp?boardid=mysql

Jigsaw is an interesting new company that has started to pop up on a lot of people's radar lately.  You can think of Jigsaw as "social networking 2.0" for professionals.  It's got a very specific focus: business contacts. And even though that might sound narrow, their ambition is huge: develop a worldwide database of contacts at every business organization on the planet.  Think about it.  How useful would it be to have a universal directory of business contacts that was always up-to-date?  Pretty darned useful.

As with other Web 2.0 companies, Jigsaw gets really interesting as it deals with scale.  Managing a few hundred thousand or million contacts is not that hard a problem.  But as you start to add zeros to the numbers, then it becomes a seriously hard problem.  Luckily, they have a …

Today I found a bug in MySQL administrator. When I tried to create a new table, there is no information about the names of storage engines :

———
MySQL version: 5.1.12-beta-nightly-20060718-log
MySQL Administrator: 1.1.10
OS: Linux Fedora Core 5
———

The other think I found is the declaration of a new storage engine I think this is ‘early Falcon’

CREATE TABLE `tester`.`testFalcon` (
`id` TINYINT NOT NULL AUTO_INCREMENT,
`name` CHAR NOT NULL ,
PRIMARY KEY(`id`)
)
ENGINE = JSTAR;


...
{"Falcon", "jstar", MYX_DBM_TE_FALCON,
"Transactional engine for modern scale-out applications.\n"
"Supports MVCC (multiversion concurrency control)."},
Copyright (C) 2004 MySQL AB
....


Logs “on demand”

By default this query returns: …

During the MySQL Users Conference late April, I had the pleasure of being interviewed by Scott Mace in his ITConversations series. The podcast is now available online.

In his commentary to my podcast, Scott says

Open-source database management software is in millions of hands. Find out how MySQL profitably blazed this trail, and how Kaj Arnö of MySQL is helping define GPL 3.0, and how MySQL lives with the complexity of software patents and multiple storage engines. Kaj also discusses how MySQL both competes and cooperates with Oracle. Also, …

I just noticed that the crawlers finished on the RSS from the last seven day window:

Word: Linux Seen: 5588
Word: PHP Seen: 2131
Word: MySQL Seen: 1191
Word: Perl Seen: 1063
Word: Apache Seen: 1043
Word: Ruby Seen: 890
Word: APR Seen: 848
Word: Python Seen: 842
Word: Asterisk Seen: 113

Slight upticks in most of the counts. I was asked about the count in APR in person this week, aka "Why is it so high?". The answer is that the OPML file from Planet Apache is pulled and parsed. So anyone whom Planet Apache thinks is "of worth" gets added. I only pull at this time 47 OPML files at this time.

And no, Planet MySQL is not pulled, since it lacks an OPML file (hint, hint, hint...).

For the social sites:

Word: MySpace Seen: 929
Word: Slashdot Seen: 606
…

The new MySQL Cluster NDB API Documentation is now available.

San Mateo and Cupertino, Calif. â?? Jigsaw Data Corp., the online global marketplace for buying and trading business contact information, announced that it has selected MySQL, the world's most popular open source database software, to power its popular online user-generated database of over 3.3 million business contacts at more than 360,000 companies.

We continue were we left off.
Using the basic structure from the last example where we implemented a simple query, let's have a look at how to do inserts, deletes, and updates based on the primary key.

First of all, use the same table structure as last time:

> mysql -u root test
and create the following table in the test database:


create table t1 ( a integer primary key, b integer, c char(20)) engine=ndb;
insert into t1 values(1, 1, 'hello');
insert into t1 values(2, 2, 'hello again');


Insert operation - insert into t1 values (3, 1, 'good bye');

Before we do the actual insert, let us prepare the data of the tuple we should insert:

int pk_a =3 ; //primary key
int b=1;
char * string = "good bye";

char c[20];
memset(c,32,sizeof(c)); // mysql requires chars to be space padded. …

Hello,

We are conducting a webinar this Thursday @ 10 PST titled "High Availability Solutions for MySQL". We will be exploring the following topics:

• MySQL Replication
• MySQL Cluster
• MySQL Cluster & Replication
• Linux Heartbeat & MySQL Replication
• Linux Heartbeat, DRBD & MySQL
• Load Balancing & MySQL
• MySQL w/ Shared-Storage & Clustering Agents
• Other HA Solutions for MySQL

It is not too late to sign up:

http://www.mysql.com/news-and-events/web-seminars/

Hope you can join us,

Jimmy Guerrero
Sr Product Manager
MySQL