Open Query | Exceptional Services for MySQL at a Fixed Budget.

Site/Newsletter

For Your Bookshelf

#openquery on Twitter

February 2010 - MySQL and MariaDB News

Posted Tue, 09/02/2010 - 12:29 by arjen

Hi, and welcome to the February 2010 issue of the Open Query Newsletter.

In this issue:

short news
remote services extended with system administration
MariaDB 5.1, where MySQL production innovation is happening!
upcoming training schedule - upcoming events
tip: OQGRAPH Engine for hierarchies and social networks

Support Overview

At Open Query, we believe that it's wiser to help before trouble occurs, and to prevent it.

You really can't prevent servers from failing in some way, in the end they all do. But you can make your infrastructure more resilient, and this mainly requires smarts and expertise, not a massive budget, or components with an "enterprise" label which actually does not even mean they are suitable for your particular needs,
Knowledge and skills. Through our training courses, and knowledge transfer during consulting and support engagements, we help you learn to help yourself more. We don't keep secrets. If you want to become a guru in this realm, that's cool with us.
Let us assist you throughout your design, development, deployment and maintenance phases. We charge sensible rates as we value ongoing engagements and appreciate that the economy has not been kind to all. Let us help you relax, when you trust that a failure is not an emergency.

Or in the words of legendary aviatrix Amelia Aerhart: to worry is to add another hazard.

OQGRAPH Engine for MySQL, MariaDB and Drizzle

visual representation of a graph structure (PD via wikipedia) The Open Query GRAPH engine (OQGRAPH) is a computation engine allowing hierarchies and more complex graph structures to be handled in a relational fashion. In a nutshell, tree structures and friend-of-a-friend style searches can now be done using standard SQL syntax, and results joined onto other tables.

No server modifications or SQL syntax extensions are necessary, the engine is implemented as a clean engine plugin for MySQL, MariaDB 5.1 and above, and Drizzle - this means that a standard server binary (mysqld) can be used, and the OQGRAPH plugin loaded at runtime. For MySQL 5.0 (which has no plugin capability) it has to be compiled in, we provide OurDelta builds.