The latest from the MySQL community

How will today's tough economy impact open source software contributions by third-party developers? READ MORE

What is the future of Drizzle? What sort of assumptions are you making?

Hardware

On the hardware front I get a lot of distance saying "the future is 64bit, multi-core, and runs on SSD". This is a pretty shallow answer, and is pretty obvious to most everyone. It suits a sound bite but it is not really that revolutionary of a thought. To me the real question is "how do we use them".

64bit means you have to change the way you code. Memory is now flat for the foreseeable future. Never focus on how to map around 32bit issues and always assume you have a large, flat, memory space available. Spend zero time thinking about 32bit.

If you are thinking "multi-core" then think about it massively. Right now adoption is at the 16 core point, which means that if you are developing software today, you need to be thinking about multiples of 16. I …

Hey, all. Petr Pisl, the technical lead for PHP support in NetBeans, and I will be giving a MySQL University webinar tomorrow entitled "Working With PHP and MySQL in NetBeans." We'll be demonstrating the PHP and database tooling features available in NetBeans.

The webinar is live, and you can ask questions via a chat-based interface. It's at 9:00 am San Francisco time, you can see what that is in your local time here.

The webinar is limited to 20 people, so it will be first come, first serve. Apologies about the small "classroom" size -- MySQL University just started using …

On a large data migration project that I am currently spearheading, we have a large installed userbase of over 2 million users running on a social networking engine. The schema has been redesigned from scratch, and code is being written to match the new schema, using the all-powerful MySQL database as the system to manage all that data.

Since this social network is global, we need good and reliable location information. The current location model is flawed and full of holes, so we have chosen AssemblySys‘ data to replace it.

We are not using AssemblySys’ schema, as we’ve rolled our own. I’ve designed our new schema to be hierarchial in nature, treating all locations on the planet as ‘nodes’ with a tree relationship, with “Earth” being the parent of all nodes. This model allows us to account for all countries and their idiosyncratic …

I'm pleased to announce the release of DBD::mysql 4.009! A couple fixes are included with this release:

* Fix to re-enable TAKE_IMP_DATA_VERSION. Still have to ensure DBI version 1.607 or higher in the test suite (Daniel Frett, myself)
* Fix to escaped single quotes throwing off bind param detection. Patch from Zhurs (zhurs@yandex.ru -- Spasibo!), new test modified to use Test::More (myself)

Thanks/Spasibo for the help from Daniel Frett and Zhurs as well as all those who report bugs!

The file:

The uploaded file

DBD-mysql-4.009.tar.gz

has entered CPAN as

file: $CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.009.tar.gz
size: 125168 bytes
md5: 1115dcc2560191bfaed09baf6aa7e183

Found at:

…

Today, the site was officially launched!

Soon, we will make the beta version of Jet Profiler for MySQL available to selected users! Contact us if you are interested.


Comments

Just finished up O’Reilly’s Backup & Recovery by W. Curtis Preston.  The title is wide-reaching, covering backups at the operating system as well as on all the popular database platforms, including Oracle, MySQL, Postgres, Sybase, SQL Server and DB2.  Preston has an amazing grasp of a spectrum of technologies and platforms, and as an Oracle & MySQL DBA myself, I’d use this as my backup reference text any day.

I’ve posted my review of Backup and Recovery over at Amazon.

This week Pentaho released version 2.0 of its BI Suite, and it contains two major features that the mondrian community will love.

First, the Pentaho User Console, a web-based environment where end users can create, view, save, and share BI content. Content is arranged into folders, and includes operational reports created with Pentaho Reports, and dimensional analytics created with Pentaho Analysis (mondrian). Users can also create subscriptions to receive reports regularly by email. PUC is simple and elegant. I predict that it will quickly become the face of Pentaho for end users.


Second, the Pentaho Aggregate Designer, which automatically creates a set of aggregate tables to accelerate a mondrian schema. I believe that …

Yesterday, we concluded our third annual “MySQL Kundenkonferenz” in Munich. We had a record number [1] of participants, 255 on the re-count including hosts. I had the pleasure to deliver the welcome speech and to moderate the event. Personally, I thoroughly enjoyed the day and it was my distinct impression that the expectations of the participants were more than met.

The external setting of the conference was Hilton Munich City on Rosenheimerstraße, close to Munich’s culture centre Gasteig — and just one S-Bahn stop away from home for me. Excellent facilities.

The start was delayed slightly due to our high-latency registration process, which prompts us to go …

Yesterday I visited the MySQL Customer Conference in Munich, as I did last year. The agenda was quite similar to last year's agenda, but I was really surprised how much Sun hardware and software products were integrated (forced?) into most of the not so technical talks.

All in all the conference was okay, but not as good as last year.