End of the week notice to let everyone know that Kontrollbase 2.0.1 revision 206 is now available for download. Effectively the same issues have been addressed as in the previous post about rev-205 but now you don’t have to use subversion as the tar.gz file is available. As usual you can find the download here: [...]

Topics for this podcast:

*-DoD memo and official use and consideration of open source
*EnterpriseDB updates its Postgres Plus Server, gets Red Hat investment
*Latest in Linux from Canonical’s Ubuntu and Red Hat Enterprise Linux, Deltacloud
*Roundup of Oracle-Sun-MySQL developments and perspectives

iTunes or direct download (25:30, 5.8 MB)

For those of you running the SVN version of Kontrollbase (vs the .tar.gz version) you can download the super awesome new revision 205. This version brings the following changes from the last binary release (194). Keep in mind it also changed the alerts_def table on one of the alert entries. Please apply the sql alter [...]

Well, what a soft launch it has been.
Some people have asked:

When are you going to get a website? Errr…. Soon! We soft launched a bit early, due to some “leaking information” but figured heck, it’s open source let’s let it all out. Soon enough, I swear!

Where can I download DynamoDB? Errr… you can’t yet cause we haven’t finished our build/QA/certification process.

However, since DynamoDB is the alter ego business suit wearing brother of LucidDB, just download the 0.9.2 release if you want to get a sense of what DynamoDB is.

There are 3 built binaries (Linux 32, Linux 64, and Windows 32): http://sourceforge.net/projects/luciddb/files/luciddb/luciddb-0.9.2/ and you can find installation instructions …

Let’s get ready to rumble! Providing cloud services (a la Amazon AWS) is a business of slim margins. Because of this, cloud vendors are more than happy to exploit open source to keep their costs low. However, what happens when they siphon off support business from the open source vendors themselves? The cloud vendor becomes the single point of contact/support for the entire collection of tools, so who needs a support contract with the individual open source vendors? What revenue crumbs does this leave for the FOSS companies to live on? Not much.

The latest example of this trend is Amazon’s Relational Database Services (RDS). It is essentially a packaging and automation of vanilla MySQL. They automate set-up and administration. They also restrict things like slaves and replication, …

If you’re running Apple’s OSX 10.5 or possibly lower versions as well you will inevitably notice that the Kontrollbase perl scripts complain about various things that are not an issue on Linux. As follows:

ROOT-(root@g5)-(/private/var/www/html/kontrollbase/bin)-ROOT ROOT-(0)> ./kontroll-query_cache_preload.pl Bareword "O_RDWR" not allowed while "strict subs" in use at ./kontroll-query_cache_preload.pl line 45. Bareword "O_EXCL" not allowed while "strict subs" in use [...]

For very personal reasons that don’t belong in this article, I decided a few weeks ago that it’s time for me to move on. The year and a half that I worked for Pythian have been a wonderful experience, and this is article is my tribute to this great company.

The MySQL Team

Being able to work side by side with two MySQL experts like Sheeri Cabral and Augusto Bott has been a great experience. I have learned a lot, not only about MySQL, but also about what a great DBA should be like. Both of them are recognized MySQL Community members and regular speakers at the MySQL Users Conference and other events. Sheeri has been named MySQL Community Member of the Year twice in a row. Both are a guarantee of excellent service.

My Predictions For Pythian

…

First, the back story. One of the MEM developers asked me today about an interesting problem:

We have graphs in MEM that can be generated against an arbitrary time range in the UI - even for a year or more if the data is not purged. Currently MEM does not do any kind of rolling up of the data (in an RRD style), and pulls graph data from each agent/instance on a 1 minute interval. So if you wanted to pull, for instance, the last 3 months worth of data in to a graph - the server back end basically goes back to the database and requests all of the rows - all ~43,829 of them, oh, and that’s for each series - and then calculate deltas on the server side if need be (we store raw values), and stuffs the data in to a graphing library to draw the graph.

Further, graphs are only of a limited (but adjustable) size on the …

Welcome to the 167th edition of Log Buffer, the weekly review of database blogs.

Since all that OOW news forced Gerry to give them short shrift last week, let’s begin with blogs on . . . 

SQL Server

Jeremiah Peschka gets our week going with his refresher introduction to SQL Server system databases.

Likewise, Pinal Dave reviews the difference between candidate keys and primary key.

…

So InnoDB is now, from 5.1.38, distributed with MySQL. It is still not enabled by default though. What this means is that there are 2 InnoDB implementations that comes with your MySQL installation. The old-school standard one, which is compiled in with the MySQL binary and is enabled by default, and one plugin.

The plugin comes as a DLL, and to load it, you have to do two things:
- Disable the builtin InnoDB Engine.
- Load the plugin.
To do this, on windows with a standard configuration, you edit the my.ini file and add the following two lines:
ignore_builtin_innodb
plugin_load=innodb=ha_innodb_plugin.dll

And that's about it, if you restart MySQL now, the plugin version of InnoDB will be used. So, what is new in the plugin then? Many things, actually, some rather cool features, a bunch of performance and scalability improvements and some enhancements to the operational aspect.
…