A new build of the Tungsten Replicator is now available. As you probably know from reading this blog Tungsten Replicator provides advanced open source replication for MySQL. There is also a commercial extension to support Oracle. Tungsten Replicator 1.0.1 includes a number of important improvements.

• Much better performance -- Current benchmark results show throughput of up to 650 inserts per second using a single slave apply thread. We are well on the way to our goal of 1000 inserts per second.
  
• Simplified management -- Replicator administration has been largely reduced to two commands: online and offline. There is an option to go online automatically at startup, which further simplifies operation and makes it easy for the replicator to operate as a service.
  
• Easy-to-use consistency checks. You just type …

If MySQL's core server development and release process has been somewhat of a frustration to the userbase over the past few years, clearly another part of the ecosystem has thrived in ways which brought exciting fruit to the Expo part of this year's conference. MySQL has become a hub of innovation in both transactional and analytics databases in ways which have turned many of my concerns to enthusiasm.

I've already discussed the technologies for data analytics on MySQL, in particular Infobright's storage engine technology. This year I took the opportunity to learn a bit more about their appliance-based competitor Kickfire as well, and it certainly looks like a solid product. I still don't completely understand what the "SQL chip" in their appliance does, but certainly the combination of a special-purpose columnar …

“If you keep doing what you’ve always done, you’ll keep getting what you’ve always gotten.”

Jim Rohn
Motivational speaker and author

I wasn't able to spend the whole day at the Drizzle Developer Day, which was held at the Sun campus on the day after the MySQL Conference, but it was interesting none the less.I enjoyed discussing stuff with Monty Taylor and Stewart Smith and was able to show them some ideas which I hope will inspire more innovation in Drizzle. I would have liked to have had some time to chat with Brian Aker some

Just quickly dropping the PDF version of the slides of my presentation at this year's MySQL Conference.
Enjoy!

Just quickly dropping the PDF version of the slides of my presentation at this year's MySQL Conference.
Enjoy!

I have published the very first sharable Drizzle Amazon Machine Image (AMI) for AWS EC2, based on the good feedback from my discussion at the Drizzle Developer Day on what options we should try.

This first version is a 32bit Developer instance, showcasing Drizzle and all necessary developer tools to build Drizzle from source.

What you will find on drizzle-ami/intrepid-dev32 - ami-b858bfd1

Ubuntu 8.10 Intrepid 32 bit base server installation:

• build tools
• drizzle dependencies
• bzr 1.31.1

From the respective source trees the following software is available:

• drizzle 2009.04.997
• libdrizzle 0.0.2
• gearman 0.0.4
• memcached 1.2.8
• libmemcached 0.28

Drizzle has been configured with …

Now at LinuxFest NW listening to John Locke's talk about the Hacking business model

John Locke is owner of Freelock Computing, a small business in Seattle who is concentrating his business around Drupal. (Drupal is a tool that allows you to quickly develop web sites). John is following many of the same principles that are described in the Hacking business model that Zak Greant and I created based on our experience with the early days of MySQL Ab. …

I recently noticed several new books based on GlassFish Server, like Yuli's book on Java EE and DBs, Using MySQL and GlassFish and Antonio's book on Java EE 6 with GF v3. Looking a bit more I also found that David also has a new book on NetBeans 6 and Java EE 5 (w/ GF) and Adam has one on the …

As I described yesterday, Open Query is doing some tests on SSDs and other devices pretending to be harddisks (SANs, battery-backed RAID controllers, etc). To aid this, I wrote a small tool to test the different kind of I/O operations MySQL would/could do, which is not quite the same as what other general purpose apps would do, and also not what other test tools measure. For instance, it tries Direct I/O as well as fsync() after each write, and also it a range of different I/O block sizes.

In a nutshell, it’s aimed to do what MySQL does, without MySQL! Testing lots of different setups for this particular purpose (even with fantastic tools like MySQL Sandbox) is a complete pest, and changing InnoDB page size requires a recompile. While Percona has tried a larger page size in the past and decided it wasn’t worth it (the default is 16K), I thought it worthwhile to include …