Some of you have noticed Kickfire, a new sponsor at this year’s MySQL Conference and Expo. Like Keith Murphy, I have been involved with them for a while now. This article explains the basics of how their technology is different from the current state of the art in complex queries on large amounts of data. Kickfire is developing a MySQL appliance that combines a pluggable storage engine (for MySQL 5.

On his way to MySQL Users Conference Andrew will stop by in Moscow, Russia and give a talk about Sphinx current features, development plans, and deployment use cases.

Interesting enough the meeting will take place at Moscow State University, Computer Science Faculty - my "Alma Mater" in the same building and even same room which I used to study.

P.S Andrew will stay for some time in the SF Bay Area after MySQL Users Conference so if there is anyone who would like to meet Andrew in person let me know. Depending on number of people interested I would try to setup date and space.

Entry posted by peter | No comment

Add to: …

Today, I missed on an awesome opportunity: to play golf later this month with Scott McNealy. Scott held the title of 'best golfer among top executives' for eight straight years.

I was made the offer to play golf today at our weekly manager's meeting. Why will I miss it? Because I will be in California, speaking at the MySQL Conference.

There are several Sun related interesting events happening in New York during the time I will be in California for the MySQL conference. This would have been a great chance for me to mingle with the top executives and talent at Sun.

I feel sad for missing this opportunity but very excited as the …

Yesterday, I had a very yummy lunch (Seared Halibut at Gotham Bar and Grill) with a team from Sun including Al Ballerini, Anthony Mazzei, Steve Spitz and Vasu Prakash.

The discussions were very interesting and informational. Some of the topics (that I am allowed to discuss publicly) were PNFS, QFS, LDAP for large scale authentication, Sun's new servers developed with Fujitsu and Sun's storage solutions.

Architecture wise, I was able to gain some more insight into UltraSparc T1/T2, Sparc M series, and M1 vs M2 architecture. Yes, there was clarification needed every time someone said T2 and T1 to differentiate T1000s and T2000s from …

If you’re managing a variety of different MySQL servers, it’s hard sometimes to know if a problem you’re experiencing is being caused by a bug or if it’s a different issue altogether.  I really like what our Enterprise Tools’ team has done in the latest release of the Enterprise Monitor - they’ve now got an Upgrade Advisor that scans your MySQL server farm and tells you if a particular server needs to be upgraded with respect to critical issues (crash bugs, security, etc.)  You can schedule this to occur on a regular basis so you don’t have to remember to do it.  Nice. 

Check out Rob Young’s dev zone article for more details. 

Well, it’s that time of the year to get excited again!  Anyone involved in the MySQL world obviously knows our big User Conference is coming up April 14 – 17 in Santa Clara, and this year Jay Pipes and crew have outdone themselves again by working with our great community, customers, and partners to put together an outstanding series of sessions, tutorials, BOF’s, and more. 

As usual, it’s going to be tough to make decisions on which sessions and such to attend, so if you’re a MySQL DBA, Architect, Performance Analyst, or other MySQL sysadmin, I thought I’d try to help and point you to some sessions that I know are going to help you in your DBA job.  Rather than break it down by subject matter/discipline like I did last year, I thought I’d work through each day and try and highlight some of the sessions that I don’t think you’re going to want to miss.

Tutorial day

Those of you having or …

Now that the GA (General Availability) release of MySQL Workbench is coming up it is a good point in time to discuss what the commercial Standard Edition subscription will be all about and what will be covered by it. While I am not a lawyer I will try to explain the ideas behind the concept. Please make sure to read the subscription details when you get it.

Key points:

• USD 99
• Single seat license (license packs for a large number of seats (>30) possible)
• Software never expires
• Includes all updates of Standard Edition for a full year

The Basics

After the official launch you will be able to buy subscriptions in the MySQL Online Shop. Apart from payment with standard credit cards it has been updated to also allow for PayPal payment. A subscription will cost USD 99 (good for people in Euro countries, I know) and is valid for a single seat. If you are a bigger …

Properties:

Description:

One of the Peter's "what to …

It is interesting to read RedmondDeveloper News’s take on Oracle’s attitude to open source this morning, especially this paragraph quoting Monica Kumar, Oracle’s senior director for Linux and open source product marketing:

“”We haven’t seen our customers asking for open source databases,” she told me. “Not many customers are interested in looking into the code and mucking around with it, and making changes to it. All they care about is ‘give me the best support, give me the lowest price of entry’.” For that Kumar pointed to Oracle Express.”

It is difficult to disagree with the second part of Monica’s statement. Cost savings are routinely cited as the biggest driver for open source database adoption, while the lack of robust support is the biggest barrier to open source adoption.

Certainly these were the findings of our …

While I was updating my blog recently, I read the top part of it which said "My adventures in database developing". I realized that I have really neglected database developing with all my research into other programming languages.
So I was trying to play around with SQL statements to brush up on my skills.

Luckily (or unluckily), someone at my work, a java developer, needed to do a data export and thought that I can do it in 1 SQL line. He said.... and I quote "You only need 1 SQL line. Whats the problem?".
Whenever I hear the "whats the problem" line, there usually is one.
So, with him having great confidence in my SQL-ing ability or a complete misunderstanding of database developing, I was forced to do the data export.

I realized early on that it would take a long time. Just to start off, I needed like 20+ columns, but each column was a row somewhere in 4 different tables.

…