Recently I got the opportunity to be a part of the windows team. We are (yes still are) using a microsoft (yes the same microsoft) product to handle one of our websites due to legacy bindings - user base, existing technology, backend team. My first encounter with microsoft on the enterprise end was when we were trying to use Microsoft Navision - supply chain management solution - in one of my

Take 50% Off COLLABORATE 13 Now Through Wednesday But you’ve got to act fast! If you’re not already one of the many joining the IOUG at COLLABORATE 13 – IOUG Forum, sign up today for your chance at attending for … Continue reading →

My take on the good, the bad, and the ugly of our Winter season, beside all the snow I’ve shoveled and blown to get in and out of my driveway, is:

The Good?

February brought us MySQL 5.6 GA (General Availability) and Ruby 2.0.0-p0. Mega thanks to the MySQL and Ruby teams! By the way, if you’ve always wanted to know a little about Ruby without a great deal of effort, you should check this awesome little 20 minute Ruby tutorial. Naturally, the best …

I've been interested in InnoDB compression for a while, and have been looking for a good use case at Flite where I could start using it.

Recently I found a perfect use case to start using InnoDB compression on a single table. This table gets a few hundred inserts per day, and each row stores up to 350 KB of serialized JSON in a LONGTEXT column.

Since I use innodb_file_per_table on MySQL 5.5, compressing the table was easy. I just executed 2 lines of DDL:

``` SET GLOBAL innodb_file_format=BARRACUDA;

ALTER TABLE reg_version ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16; ```

Of course I also added innodb_file_format = BARRACUDA to /etc/my.cnf to make the change permanent.

From my understanding, this …

MySQL has a long history since its birth 18 years ago when Monty Widenius and David Axmark started it. Planet MySQL started in 2004 and all its history is archived.  Let us dig in it. It is always good to look back at the past to get some lessons for the future. Here are the [...]

I've been interested in InnoDB compression for a while, and have been looking for a good use case at Flite where I could start using it.

Recently I found a perfect use case to start using InnoDB compression on a single table. This table gets a few hundred inserts per day, and each row stores up to 350 KB of serialized JSON in a LONGTEXT column.

Since I use innodb_file_per_table on MySQL 5.5, compressing the table was easy. I just executed 2 lines of DDL:

``` SET GLOBAL innodb_file_format=BARRACUDA;

ALTER TABLE reg_version ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16; ```

Of course I also added innodb_file_format = BARRACUDA to /etc/my.cnf to make the change permanent.

From my understanding, this …

ClouSE 1.0b.1.7 is released

OblakSoft is pleased to announce the release of Cloud Storage Engine (ClouSE) for MySQL Beta version 1.0b.1.7.  In this release we added support for a variety of environments to address the platform diversity of our growing customer base.

Here is the summary of changes that are included into 1.0b.1.7:

• Support for ClouSE on Microsoft Windows (limited preview)

Now ClouSE builds are available both for Linux and Microsoft Windows.  The cloud data format is the same across all platforms: Linux and Windows, 32-bit and 64-bit.  This allows for seamless transitions between machines, platforms and clouds.  ClouSE for Windows is currently available to a group of limited preview customers.  If you would like to sign up for the limited preview program please …

Oracle, SQL Server, and MySQL; these database technologies among various other similar innovations are running this world virtually and bloggers have got lot to say in this regard. This Log Buffer Edition is yet another voice in this arena.

Oracle:

Oliver Steinmeier is explaining the JDeveloper and Fusion Applications in a lucid way.

London prepares for a surge of developer brainpower during the Devoxx UK conference on Tuesday and Wednesday, March 26th and 27th, Yolande Poirer tells us.

It’s hard to believe that another year has passed from last RSA. But, indeed, time flies when you’re busy, I guess, …

Building clusters is usually a fun time. Here’s one of my setups at the Equinix LAX1 facility that is being used for VPN services, OpenVZ clustering, and general RADIUS and MySQL clustering integration. Once the clustering design is finalized, it’s still in flux state while I try out different setups, I’ll post some physical+logical architecture diagrams to show “How to Build a Fault Tolerant Infrastructure for Virtualized MySQL NDB Cluster + Python-based VPN systems.” Stay tuned for more.

I recently had the chance to talk to the San Francisco MySQL Users Group and any group that gets 80 plus regulars to attend meetings is impressive. That night they had 280 people RSVP! And a better than average percentage appears. Thanks to Theo, Mike and Erin — the organizers for the invite. I also had the chance to ask Erin O’Neill the secrets of how they run their meetings.