I enjoyed InSync09 conference and the networking opportunities there — great place to meet bunch of good old friends and make some new ones. The content of the presentations and direction where Oracle is going to provided some interesting food for thoughts on Oracle’s strategy and how it’s going to make money with all those acquisitions they’ve done recently including current Oracle-Sun deal.

My take now is that Oracle’s focus is integration of all those products. It’s absolutely clear that Oracle won’t be able to merge so many different product lines together. It’s difficult and time consuming task and customers often suffer during this transition process. Oracle does not want its customer suffer — it’s the best way to shrink their customer base.

What Oracle intends to do now is to …

I’m shifting away from LiveJournal. It lacks ability to search and otherwise peruse archived blog posts. And of course it’s only me, while Open Query has more people.

From now on the posts will be at http://openquery.com/blog/ and this is aggregated to Planet MySQL as a group blog. You may have already seen Walter posting from his seat at the MySQL Conf. All posts and comments from my LJ blog have been migrated to WordPress, thanks to magic performed by young Akash Mehta. Unfortunately the comment threading can’t be exported.

The full export means that my personal posts are now also present at Open Query, although I may move those elsewhere later. The existing blog entries on LJ will stay for a while at least, although I do have to pay for the LiveJournal subdomain to keep the URLs alive.

A little sidenote …

Dump and load the schemas (one for universal and one for the shards).

Note – this post is a footnote for my MySQL users conference presentation Sharding Using Spockproxy: A Sharding-only Version of MySQL Proxy.  

Dumping the schema is fairly straight forward using mysqldump.  There are two issues: we need to separate the “universal” tables from the sharded tables and you need to decide what to do about auto_increment.

Separating the tables is simple if you have your shard_table_directory table set up the way you like it then run:

SELECT group_concat(table_name, SEPARATOR ‘ ‘) FROM shard_table_directory WHERE status = ‘federated’;

and

SELECT group_concat(table_name, SEPARATOR ‘ ‘) FROM shard_table_directory WHERE status = ‘universal’;

and keep …

For those of you attending the MySQL conference and saw our CEO’s keynote will have heard that Kickfire has just launched a data warehousing contest for the MySQL community.

The contest will run through the end of May. MySQL users can submit their entries online at www.kickfire.com. The entrants will be judged by a panel of experts including Peter Zaitsev from Percona. Here’s Peter’s note on Kickfire and the contest:

“Kickfire promises to substantially improve the performance of data warehousing queries, combining the power of their SQL Chip’s data flow architecture, a column-based storage engine and a custom query optimizer. It’s great to see them giving back to the community with this data warehousing contest.”

To learn more about the contest you can click …

Video for the presentation at the 2009 MySQL Camp:
InnoDB Database Recovery Techniques
Peter Zaitsev (Percona)

Description:
Have you ever had Innodb database corrupted or have deleted data accidentally and want it back ? This session will go through various approaches you can use to get most of your data back using MySQL build in features as well as third party open source tool.

This session speaks about Innodb database recovery techniques (apart from recovering from back).

First we will discuss various types of Innodb corruption and data loss scenarios ranging from user error to hardware failures.

read more

Finished my presentation earlier this afternoon. I had a better audience than last year and there was interest in the download URL for the source tarballs so I hope to see people hacking on it soon.The link to the presentation is here.There has been lots of good communication with staff from MySQL^WSun Microsystems^W^WOracle so maybe we shall see this code to begin to be integrated soon. In other

At MySQL Conference & Expo 2009, I will be giving a presentation on Q4M tomorrow (Apr. 22) from 11:55am. If you are interested in using a simple, fast message queue as part of your system, please come to the session.

Details: Using Q4M: A Message Queue Storage Engine for MySQL

On the next day (Apr. 23), I will be doing another presentation at Percona Performance Conference, held at the same location. In the presentation, I will describe the techniques (mainly MySQL UDFs) used to squeeze maximum performance out from MySQL used in Pathtraq, one of the largest web access stats service in Japan.

Details: …

Video for the presentation at the 2009 MySQL Conference:

High Performance Ruby on Rails and MySQL
David Berube (Berube Consulting)

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/6942

read more

Now that MySQL 5.4 (internally code named performance version or summit) is officially released, I can tell you that I used MySQL 5.4 alpha for my Nehalem scaling studies in my earlier blog - MySQL Scalability on Nehalem systems (Sun Fire X4270). I am waiting to get hold of a 4 socket Nehalem system to see we scale; but that will have to wait for the MySQL conference to get over.

Allan managed to get slightly higher Sysbench Read-Only numbers than mine using the latest MySQL 5.4. Interestingly Solaris does better than Linux. Probably a bug since many of the optimizations in MySQL 5.4 are OS independent. But then a lot can happen in 12 months