February is turning out to be a busy month. I’ll be giving a talk about MariaDB at the SkySQL Solutions Day in Hamburg, alongside Sergei Golubchik. This happens February 1 2013.

I’ll also be in Brussels for FOSDEM and presenting at the MySQL & Friends devroom. Here I will talk about MHA and how you can get automated MySQL failover. I’ll also be hanging out at the CentOS booth with Karanbir Singh giving away MariaDB stickers all weekend. If you’re at FOSDEM, don’t forget to sign up for the …

openSUSE 12.3 is getting closer and closer and probably one of the last changes I pushed for MySQL was switching the default MySQL implementation. So in openSUSE 12.3 we will have MariaDB as a default.

If you are following what is going on in openSUSE in regards to MySQL, you probably already know, that we started shipping MariaDB together with openSUSE starting with version 11.3 back in 2010. It is now almost three years since we started providing it. There were some little issues on the way to resolve all conflicts and to make everything work nicely together. But I believe we polished everything and smoothed all rough edges. And now everything is working nice and fine, so it’s time to change something, isn’t it? So let’s take a look of …

We are very honoured to have been asked to give a “state of the MySQL” keynote presentation at the Percona Live MySQL Conference and Expo in April.

While this will not be in any way an official “state of the dolphin” presentation, I think it is fitting given the expansion of the MySQL ecosystem that the Percona Live event includes an independent perspective on the state of MySQL. The full title of the presentation – MySQL, YourSQL, NoSQL, NewSQL – the state of the MySQL ecosystem – reflects that.

We want to present an independent perspective on the health of the MySQL ecosystem in 2013, drawing on our research and analysis, as well as the views of the participants in that ecosystem.

You have …

yum

It’s often pain to guess package names when you need to install stuff on, lets say, CentOS. So there is a list, although maybe not full, of what I needed to get another VM build and run MariaDB server and to execute at least some tests on it (all done via yum install):

cmake
gcc
ncurses-devel
bison
g++
gcc-c++
aclocal
automake
libtool
perl-DBD-MySQL
gdb
libaio-devel
openssl-devel

Same in one line, for lazy me:
sudo yum install cmake gcc ncurses-devel bison g++ gcc-c++ perl-DBD-MySQL gdb libaio-devel openssl-devel

To install bzr (if it’s not in the official repo):

su -c ‘rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-2.noarch.rpm’
(check the architecture)

and then can use yum install
bzr

Another story (taken …

We're looking forward to spreading the MySQL, MariaDB & Cloud message further in Finland this year!

Talouselämä, the largest Finnish business publication today published their list of the Top 20 Startup companies in Finland. The selection was made from approximately 100 applications from companies based in Finland. 

read more

The MariaDB Java Client 1.1.0 has been released. You can download it here.

This version focused on fixing all known database metadata bugs and ConnnectorJ incompatibilities. Specific fixes include:

• Consistent, compatible with ConnectorJ handling of JDBC catalogs vs schemas vs databases
• Implementation of several missing methods in DatabaseMetaData
• Better handling of statement timeouts
• OSGi-specific entries have been added to MANIFEST.MF so it can be used in OSGi environments
• Added support for dumpQueriesOnException=true in the JDBC URL
• Added support for IPv6 addresses in the connector
• Added SSL support
• and more…

See the Release Notes and …

I've created a graph about the MySQL version history.

It's mysql-graph-history on github.


Please let me know if this is correct or if I'm forgetting some versions.

In May of last year I blogged about MariaDB 10.0 for the first time. We received some feedback, digested it, and I further explained MariaDB 10.0. Now, with the first Alpha of MariaDB 10.0 out and a new year just beginning, now is a good time to explain a little bit more, especially about MariaDB 10.0 and MySQL 5.6 as I and others in the MariaDB project get asked a lot about the differences between them.

First, here are some details as to why we didn’t just take MySQL 5.6 as a base and create something that would have been called MariaDB 5.6. These details haven’t been widely shared before:

1. The file structure of the codebase in MySQL 5.6 has changed. Single code files have been split into several and code has been …

Our customised training courses for the MySQL & MariaDB databases help your team learn exactly what they need to know

Since SkySQL’s inception, training has been an integral part of the services we provide. Training isn’t just something we offer, but an intrinsic aspect of our business model as we evolve into an all-inclusive service and product provider. And customized onsite training is the best way your team learns what your specific team needs to know.

read more

There have been a number of comments that Amazon RDS does not allow users access to MySQL replication capabilities (for example here and here).  This is a pity. Replication is one of the great strengths of MySQL and the lack of it is a show-stopper for many users.  As of the latest build of Tungsten Replicator half of this problem is on the way to being solved. You can now set up real-time replication from an external MySQL master into an Amazon RDS instance.

In the remainder of this article I will explain how to set up Tungsten replication to an Amazon RDS slave, then add a few thoughts …