I’ve been seriously swamped in these last few weeks. Relocating (from Melbourne to Kuala Lumpur) has been interesting. Not to mention that all the work that’s still around…

I should mention that I am now Sun, having signed all paperwork a few weeks back. It just dawned on me when I picked up my ID card today from the Sun KL offices. No email address yet, but our @mysql.com addresses will continue to work (they’re on my business cards).

Which brings me to the fact that I am also sporting new business cards (no direct-line number, yet - still waiting on its creation), and they have an interesting logo on the back!

MySQL/Sun logo At the conference, if folk are still giving out “older” MySQL cards, keep them - they’re collector’s items now. Me? I’ll be bringing my new ones ;)

Technorati Tags: sun, …

A session at the MySQL Conference 2008 that I’d have loved to attend, would have been the Adopting and Adapting OSS at Shinsei Bank. As a case study, Shinsei Bank in Japan is a great MySQL customer and use case - they’re a bank. A pretty large bank…

Sadly, the session has been cancelled. Never fear, because at 4.25pm on Wednesday, the 16th of April 2008, there are seven other great sessions.

If you’re interested in web security, then look no further than Eli White’s talk titled Help, My Website Has Been Hacked! Now What? Eli works at Digg, and might have some invaluable practical advice for you.

If you’re more the systems administrator, you …

Well at least your MySQL database world.

As Paul eluded to, PrimeBase Technologies has a project to provide synchronous replication for MySQL in a High Availability environment. It is more then an idea, there is a plan.

Is it possible?
What are the use cases?
How can you use it?
Would you use it?

Some input to date. We need these questions and more, and we seeking more input for discussion.

Unfortunately the opportunity to hear any input during a presentation is left to the last day of the conference, so we have created a BoF session on Tuesday night for a round table discussion if necessary. We encourage people to bring specific cases and situations for feedback, the reasons why MySQL Replication, MySQL Cluster, DRBD/HeatBeat or any other solution does not satisfy your needs, and what …

The problem: You’re creating an (InnoDB) table with foreign key constraints:

CREATE TABLE a (
  b INT NOT NULL,
FOREIGN KEY b REFERENCES c(d)
) ENGINE=InnoDB;

and MySQL throws an ERROR 1005 (HY000): Can't create table ... (errno: 150)

In 95% of the cases, this means you need to create an index on c(d):

ALTER TABLE c ADD PRIMARY KEY (d)

Just a subjective observation, been through a few bookstores this arvo (sorry, afternoon - Australian ;-) and I tend to do a quick check of the computer section to see what MySQL books are there.
It appears that over the last year or perhaps even longer, fewer new MySQL books have come out, and fewer MySQL books hang around on the shelves. Less interest, I don't know.
O'Reilly's annual report on the book market probably has some insight into this but it's late in the evening here so I'm not going to delve into that right now.
Anyway, it's quite possible that the market is fairly saturated, and there are some good books out there covering most features and uses. So all that remains is new functionality, and there hasn't really been that much which warrants writing a completely new book about it. Stored procedures was probably the last such instance. Like, partitioning is interesting, but not for a full book. Falcon, diddums (at …

I started working on my upcoming talk at PGCon 2008 and realized that I haven't put my talk from PostgreSQL Conference East 2008  - PostgreSQL and Benchmarks online yet.

 More on the upcoming presentation later.

I'm hosting a MySQL Tour event in Helsinki, probably this is the last stop on the tour so it will end in the same city where MySQL got started. If you are nearby, please pop in!

***

MySQL Tour visits Open Tuesday in Helsinki May 6th

This winter we haven't had as many Open Tuesday meetings as we had last year,
but we will finish off the season with meeting Sun and MySQL on May 6th at
18:00, in the usual place Club Ahjo, Bulevardi 4, Helsinki.

read more

There are interesting posts these day about future of MySQL Replication by Brian Frank and Arjen.

I think it very interesting to take a look at a bit bigger picture using framework from Innovators Dilemma and Innovators Solution.

I’m not going to speak about disruption and commoditisation of Database …

Coming from Berlin and Hamburg meetups, I am about to board a plane for San Francisco and the MySQL Users Conference. I am looking forward to see a lot of familiar faces from the community and many still unfamiliar ones that I have been contacting in the latest weeks. New colleagues (plenty of them!) new community people, new business partners.
And the conference will also bring some surprises. The ones coming from MySQL will be old news for me (oh, the joy of being an insider!), but a few ones are still exciting because they will be in the making until the very last minute. Much meat will be on the grill. Stay tuned.
The program itself is interesting and charming. I will attend the sessions on my private schedule as a personal treat, enjoying the technology as a kid in a toy store.
And of course I will enjoy my tutorial on MySQL Proxy and the session on MySQL Sandbox. I will treat …

Updated On good advice from Sheeri I made a few comments clearer.

We have proposed that the integral “MySQL Community Photo Day” be on Thursday April 17 2008, the final day of the MySQL Users Conference.

Wear a t-shirt from an open source community project on Thursday, whether a PrimeBase PBXT one or your favorite open source project (of course I prefer the first option). Get your photo taken with the masses of community supporters. If your not attending this year, this doesn’t mean you can’t also contribute a photo yourself from what location you are from. Save a saving fund for next year but get us a photo.

It doesn’t have to just be Thursday, we will accept photos at any time before then. Upload a photo and win a prize. (Baron you definitely get chocolate)
We have created a Flickr group called “MySQL Community Photo Day” at …