Continuity of power

Last night my residential area lost power for about 2 hours, between 2-4 am. This reminded me of something, and there’s analogies to MySQL infrastructure. Power companies have over recent years invested a lot of money in making the supply more reliable. But, it does fail occasionally still.
From my perspective, the question becomes: is it [...]

|

Do you use MySQL 5.x stored procedures/functions, or triggers?

That’s the current Open Query quickpoll. Thanks.
You can also post a comment to clarify your yes/no vote, either on the poll page or here.

|

Time-share computing is back!

I kid you not. Let’s quote http://en.wikipedia.org/wiki/Time-sharing
“Time-sharing is sharing a computing resource among many users by multitasking. Its introduction in the 1960s, and emergence as the prominent model of computing in the 1970s, represents a major historical shift in the history of computing. By allowing a large number of users to interact simultaneously on a [...]

|

When a backup is not, and when a restore is a failure

Since writing and speaking a bit more about the “relax! a failure is not an emergency” concept, more and more people approach me with interesting horror stories. I’m scribbling a few backup-related ones here for your enjoyment – and naturally there are important lessons.
Story 1: A place makes backups that get shipped off-site, interstate even. [...]

|

What to do with the Falcon engine?

Keep it. Make sure it gets correctly positioned in the coming months.
It appears that with the Oracle acquisition, the reason-to-exist for Falcon is regarded as gone (a non-Oracle-owned InnoDB replacement), previously seen as a strategic imperative – much delayed though.
But look, each engine has unique architectural aspects and thus a niche where it does particularly [...]

|

Open Database Alliance

This alliance is an excellent step, showing the maturity, breadth and depth of expertise for MySQL related services! Of course Open Query is an active early member, with our training and subscription services, and initiatives like the OurDelta builds project.
Kudos to MontyW and PeterZ for driving this further while at the MySQL Conference last month.

|

MySQL User Groups on meetup.com – sponsorship – ask Open Query

This is about the ending of the sponsorship of the mysql.meetup.com user groups by Sun/MySQL and their suggested move to Facebook.
If people want to move to Facebook, that’s fine. For those who want to stay but don’t have the local funding, I have an offer for you. Contact Open Query, and we’ll sponsor your group [...]

|

Visiting Darwin/NT

From this Tuesday 12 May until Sunday 17 May I’m going to be in Darwin (Northern Territory, Australia), teaching custom MySQL training days for a medical research institute.

DarLUG has been extinct for a while, but perhaps there are some local Linux/OSS people reading this? Please do drop me a line if you’d like to catch up [...]

|

When raisins and sultanas are grapes too

Do you sometimes see a commercial for breakfast cereal (in print or on TV) showing grapes in between the flakes and other ingredients? There are no grapes in the actual product, so you may wonder why that is not false advertising. The answer is hyperbole, or in marketing/advertising terminology: puffery.
Raisins and sultanas (what you call ‘em [...]

|

Joomla Day Brisbane

After the morning and afternoon tutorials today by Andrew Eddie (Joomla dev lead), tomorrow is Joomla Day – Brisbane Joomla Users Group where I’ll be doing talk as well.
I’ve already noticed that Joomla users are a slightly different crowd. Joomla is a pretty powerful CMS with many modules/extensions, just like Drupal which runs the Open [...]

|