Brian Aker, a brilliant helpful duder, who I learn a lot from. Gives a great talk about what is NoSQL explained in a way for database guys. I warn you, there are some points in this video where you can't hear Brian due to the audience "participation" but you should get the content.

As a part of Global Ignite Week I will be doing an updated "Guide to NoSQL". Ignite Seattle will be taking place at the King Theater in Bell Town next Thursday, March 4th.

I'm hoping for better audio this time :)

Applying binary logs to a MySQL instance is not particularly difficult, using the mysqlbinlog command line utility:

$> mysqlbinlog mysql-bin.000003 > 03.sql
$> mysql < 03.sql

Turning off binary logging for a session is not difficult, from the MySQL commandline, if you authenticate as a user with the SUPER privilege:

mysql> SET SESSION sql_log_bin=0;

However, sometimes you want to apply binary logs to a MySQL instance, without having those changes applied to the binary logs themselves. One option is to restart the server binary logging disabled, and after the load is finished, restart the server with binary logging re-enabled. This is not always possible nor desirable, so there’s a better way, that works in at least versions 4.1 and up:

The mysqlbinlog utility has the --disable-log-bin option. All the option does is add the SET …

Changes (as compared to 3.71) include:

Features:
* The number of builds for Linux has been increased to the double number of what it was before.  In addition to the builds based on glibc version 2.3 we now distribute builds based on glibc 2.5.  Also we add builds for use with even older glibc 2.3 based Linux that what we had before. There are now builds based on both glibc-2.3.2  and 2.3.4 (the one based on 2.3.4 is the one we had before). We had a few  reports of random crashes (typically occurring up to a few times per week) occurring on recent 64 bit CentOS servers and in one case also a RHEL5.  The glibc 2.5-based build fixes this. Although we only had such reports on 64 bit Linux of  ‘Red Hat Family’ we also included 64 bit tar.gz for all Linux platforms and 32 bit RPM builds.  The general advice on which build (glibc 2.3-based versus 2.5-based) should be …

Just a note that my personal blog resides on lentz.com.au/blog/

The story is this… I first started my blog when at MySQL AB, the Community Relations gig. It was a mix of personal and MySQL-related stuff, and hosted at LiveJournal. Last year we managed to migrate all the LiveJournal data to the Open Query blog instance, but naturally there it’s not really suitable to write about non-OQ stuff. So I’ve cloned that instance and am deleting the posts that are really only OQ/MySQL-related. Some business/development topics that refer to MySQL as an example will stay.

In any case, this allows me to scribble about my (bio)diesel car, gardening, cooking, bushwalking and all that without bothering the Open Query blog readers Those of you who are interested can subscribe to both. Easy!

A recent survey found that the most used BI tool isn’t what you might think (e.g. Business Objects, Pentaho, Cognos, Jaspersoft, etc.) – it’s Microsoft Excel. And I suppose that’s not so surprising given spreadsheets are the main communication medium for financial and general business analysis.

If you use Excel in this manner, you should know that you can use Excel’s data import capabilities to directly query (via the MySQL ODBC driver) and pull data from Read More...

Before I write an actual introductionary blog-post about Embedded PBXT's (or just "EPBXT"), I'd like to drop some lines to teach you how to get started with Embedded PBXT today. Currently, there is no binary version of EPBXT available, so you will have to build it from bzr directly.

Your system has to meet the following requirements for doing so:

• protobuf >= 2.2 installed and working, especially protoc is in your $PATH -- Embedded PBXT will not check existence for protobuf, so you have to install and check this on your own beforehand
• make, gcc, etc. installed

In general, if you can successfully build drizzled and mysql on your box, compiling epbxt should work fine, too.

To kick-start the compilation process, there is a special makefile which automates the building process.

# wget …

Looking around on Google for a webpage test script returns a lot of results. Some of them are useful, some are not. In particular, for Python, the scripts on the first page of results are minimal and lacking a useful copy and paste / ready to go script that will answer the question “is my webpage available?”. So I decided to write a quick one that will give you the return code and email you as an alert if the page does not return with a 200 code (successful). You can find the script here. Update: the webserver was trying to execute the script as a .py file so I just changed it to .txt – for it to work you will want to change the .txt extension to a .py extension after you download it.

If you are familiar with Python scripting, this script could easily be modified to post to a form so that you can test a MySQL transaction (or other transactional DB) …

For those of you on the O’Reilly MySQL conference list you will no doubt see this email, but for readers here is the important bits.

Oracle Executive Will Speak at O’Reilly MySQL Conference & Expo
Edward Screven to Answer Questions re: Future of MySQL

Sebastopol, CA, February 24, 2010—Wonder about the future of MySQL? Curious about what Oracle plans for the open source database software? Expect answers when Edward Screven, Oracle’s chief corporate architect and leader of the MySQL business, speaks at the O’Reilly MySQL Conference & Expo, scheduled for April 12-15, at the Santa Clara Convention Center and the Hyatt Regency Santa Clara.

Edward Screven reports to CEO Larry Ellison, and he drives technology and architecture decisions across all Oracle products to ensure that product directions are consistent with Oracle’s overall strategy. He’ll discuss the current and future state of …

It is a pleasure to announce that Kontrollbase – the MySQL analytics and performance monitoring webapp for MySQL servers – has a new sponsor. Network Redux is located in Portland, Oregon and offers enterprise quality dedicated and managed hosting as well as cloud services. Thomas Brenneke contacted me to discuss his interest in utilizing the [...]