MariaDB 10.0.15 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.0.15/

This is the sixth GA release of MariaDB 10.0, and 16th overall release of MariaDB 10.0.

This release has an important InnoDB/XtraDB fix, a new addition, security enhancements (and improvement) – all related to yaSSL, so be sure to check out these fixes if you’re running MariaDB 10.0, and not up to 10.0.15 yet. (MariaDB 10.0 is the current stable series of MariaDB. It is an evolution of the MariaDB 5.5 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6.)

Here are the main items of note:

1. This release fixes a serious bug in InnoDB and XtraDB that sometimes could cause a hard lock up of the server ( …

Fri, 2015-01-16 15:32guillaumelefranc

This new blog series will be about how to easily automate common MariaDB administration tasks using Ansible. We will showcase how to automatically install and configure software such as MariaDB server, MariaDB Galera and MaxScale with ease in reproducible environments.

What’s Ansible?

Ansible is an IT automation tool. It can configure systems, deploy software, and orchestrate more advanced IT tasks such as continuous deployments or zero downtime rolling updates.

Ansible’s goals are foremost those of simplicity and maximum ease of use. It also has a strong focus on security and reliability, featuring a minimum of moving parts, usage of OpenSSH for transport (with an accelerated socket mode and pull modes as alternatives), and a language that is designed around auditability by humans – even those not familiar with the program (source: Ansible …

Referring to the documentation, you may find how you can compile the udf-example.cc from the MySQL source distribution.

http://dev.mysql.com/doc/refman/5.6/en/udf-compiling.html

The article provides the steps for the compilation without downloading the full source distribution but creating your own external functions

We take the example from the UDF source "udf_example.c" downloaded from the following URL
https://github.com/twitter/mysql/blob/master/sql/udf_example.c

Pre-requiste
1. MySQL installation (e.g. /usr/local/mysql)
2. gcc (and gcc-c++) is installed.

The cflag to be used can be obtained by
mysql_config --cflags


To compile the source obtained (such as the one obtained from the above URL) -

 
The shared library is created 'udf_example.so'.   

Copy the …

This Log Buffer Edition covers blog posts from various bloggers of Oracle, SQL Server and MySQL.

Oracle:

Sync tables: generate MERGE using Unique constraint.

What Hardware and Software Do YOU Want Oracle to Build?

There were a number of new features introduced in Ops Center 12.2.2. One of the shiny ones is an expansion of the backup and recovery capabilities to include Proxy Controllers.

Want to Be a Better Leader? Answer One Question.

Managing a remote …

I've gathered the main critiques of MySQL / MariaDB stored procedures, and will try some defences.

Monoglots

The critique:

SQL/PSM is the standard 4GL and it was the work of Andrew Eisenberg. Andy based it on ADA. Unless you are military, you have never seen ADA. Be grateful it is dead.
-- Joe Celko, reminiscing about his days on the SQL standard committee

Actually I believe Mr Celko likes SQL/PSM, which is the standard that MySQL and MariaDB follow. Here at last is your chance to see some Ada code, and compare with MySQL code ...

Ada

MySQL

declare a: integer;
begin

  a := 0;
  loop
    a := a + 100;
    exit when a = 200;
  end loop;
  if a /= 300 then
    a := 400;
  else
    a …

In my recent travels, I’ve been speaking with database users at various meetups and trade shows worldwide. Very often, I got questions centering around the best use cases for our products, be it TokuDB, our MySQL storage engine, or, TokuMX, our distribution of MongoDB. Over 90% of the time, I responded Cloud, Big Data or both. You see, in the software industry we’re like kindergartners, we like things to fit into neat categories. If you know any software sales people, you’ll recognize this as a fitting analogy (at least in terms of energy and attention span), but I digress. This strategy helps allocate resources where they are most likely to make an impact, and, thus, optimize our return on investment. In this blog series, I’m going to go slightly against the grain and explain why the Fractal Tree makes databases work in these environments.

Before I get into more detail, let me …

New version of JSON UDF functions has been just released. This is maintenance release which only contains fix for 4 bugs:

74090/19821398 `INSTALL_JSONUDFS` ISSUES A WARNING DUE TO TRUNCATION OF `VERSION_COMPILE_OS`
74091/19692634 `JSON_DEEP_MERGE`: DEEP CRASH IN `MERGE_TREE`
74092/19692628 CRASH WITH SECOND-HAND NULL IN PARAMETERS
74097/19693198 `CREATE_NEW_VALUE`: STACK BUFFER OVERFLOW, %LLD CAN'T FIT IN CHAR[20]

Also 0.3 branch becomes stable branch and no new features will be pushed to this branch in future. Previous stable branch (0.2) removed from MySQL Labs website.

…

Thu, 2015-01-15 16:18dipti_joshi_g

When I started my career in early nineties, the Internet, the open source software movement and the Linux operating system were in their infancy and MariaDB and MySQL did not exist. Today open source is a mainstream software delivery mechanism, and web applications are built upon open source stacks which include Linux and MariaDB. Sybase was the first relational database I worked with - a then leading relational technology in early nineties. Four months ago, I joined the team at MariaDB - a now leading open source relational database company where fast and cutting edge innovations take place.

Our team at MariaDB works with many organizations that use MariaDB to drive their web applications. Our business users tell us that, their success lies in their ability to deliver a quality customer experience, control cost, support a growing user base and stay competitive with faster innovation. In terms of …

In the MySQL Labs version of MySQL version 5.7, there is a new HTTP plugin. The HTTP plugin documentation from the labs site provides this information (from MySQL Labs):

The HTTP Plugin for MySQL adds HTTP(S) interfaces to MySQL. Clients can use the HTTP respectively HTTPS (SSL) protocol to query data stored in MySQL. The query language is SQL but other, simpler interfaces exist. All data is serialized as JSON. This version of MySQL Server HTTP Plugin is a Labs release, which means it’s at an early development stage. It contains several known bugs and limitation, and is meant primarily to give you a rough idea how this plugin will look some day. Likewise, the user API is anything but finalized. Be aware it will change in many respects.

In …

My dear colleagues,  Liz van Dijk, Dimitri Vanoverbeke, Kenny Gryp, also known as the “Party Team” are organizing the “Fosdem MySQL & Friends Devroom Community Dinner” !

Like last year, we’ll be renting a private space to allow for easy socializing. However, in light of this year’s 20th Anniversary of MySQL in May, as well as MariaDB’s 5th Anniversary in February, we want to take things to the next level, and give the night a true community feel. Our new location is available to us until 2AM, and is part of the ICAB buildings, closer to the ULB (more detailed directions on the eventbrite page).

As such, prepare for an evening of food prepared for the Community, by the Community. That’s right, your hosts will be firing up the pizza …