Ideas, releases, practical guides, and perspectives from the people building with MySQL.
This week I’ve been writing based on my linux.conf.au 2014 talk, which you can watch the recording of.
Also see Part 1, Part 2, Part 3 and Part 4. My feed feel off Planet MySQL for a bit so you may have missed those posts.
Now we head into the era of acquisitions… there have been a few in …
[Read more]February 13, 2014 By Severalnines
Galera is slowly but surely establishing itself as a credible replacement for traditional MySQL master-slave architectures.
The benefits are clear - a true multi-master InnoDB setup with built-in fail-over, potentially across data centers.
But how do you migrate? Does the schema or application change? What are the limitations? Can migration be done online, without service interruption? What are the potential risks, and how to address those?
Webinar: Migrating to MySQL, MariaDB Galera and/or Percona XtraDB Cluster
Tuesday, March 11th 2014
Register now - Europe/MEA/APAC
[Read more]MariaDB 10.0.8 was recently released as RC ("Release Candidate"), and is available for download here:
https://downloads.mariadb.org/mariadb/10.0.8/
This is the first RC release of MariaDB 10.0. It is primarily a bug-fix and polishing release, and all features planned for MariaDB 10.0 GA are included in this release.
There were 6 notable changes in MariaDB 10.0.8:
I have just implemented MASTER_GTID_WAIT() in MariaDB 10.0. This can be used to give a very elegant solution to the problem of stale reads in replication read-scaleout, without incuring the overheads normally associated with synchronous replication techniques. This idea came up recently in a discussion with Stephane Varoqui, and is similar to the concept of Lamport logical clock described in this Wikipedia article.
I wanted to describe this, hoping to induce people to test and maybe start using this, as it is a simple but very neat idea, actually.
A very typical use of MariaDB/MySQL …
[Read more]The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.8. This is a Release Candidate release.
See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 10.0? page in the MariaDB Knowledge Base for general information about the MariaDB 10.0 series.
[Read more]
It's my pleasure to be presenting at SCaLE
12X on the subject of real-time data loading from MySQL to Hadoop.
This is the first public talk on work at Continuent that
enables Tungsten Replicator to move transactions from
MySQL to HDFS (Hadoop Distributed File System). I will
explain how replication to Hadoop works, how to set it up, and
offer a few words on constructing views of MySQL data using tools
like Hive.
As usual with replication everything we are doing on Hadoop
replication is open source. Builds and documentation will
be publicly available …
MariaDB 5.5.35 was recently released (it is the latest MariaDB 5.5), and is available for download here:
https://downloads.mariadb.org/mariadb/5.5.35/
This is a maintenance release, and so there are not too many big changes of note. However, there are a couple items worth mentioning:
I’ve continued building on my MariaDB GIS and node.js example application that I wrote about two weeks back, https://blog.mariadb.org/node-js-mariadb-and-gis/. The application shows how to load GPX information into MariaDB, using some MariaDB GIS functionality, and making use of the node.js platform together with MariaDB’s non-blocking client.
With the GPX data converted into GIS points in the MariaDB database, I wanted to further expand a little on both the GIS aspect and also look at how some additional data could be shown in the application by using jQuery’s Ajax calls to update a piece of the web based application UI.
To start with, an interesting thing to do when you have a bunch of GIS points in a …
[Read more]
This third post in this series of blogs about MaxScale is finally
getting where you want to go: Install and configure MaxScale. The
first blog in this series was an overview of
what MaxScale is and the second about how to set up a Cluster of
MariaDB servers, using MariaDB Replication, for MaxScale to
access. But now it's time to introduce MaxScale.
If you skipped the second post as you already know how to set up
MariaDB with Replication and all that, be remineded that I will
use the same Linux server setup as outlined there even for the
MaxScale server and for a client to do some testing, and I
recommend you stick with that for now (for MariaDB itself you can
use any relevant setup you want, MaxSCale doesn't …
Today we upgraded the PCRE library bundled with MariaDB-10.0 to PCRE-8.34. This PCRE release includes some improvements, fixes for better stability and performance, and gives more compatibility with the Perl regular expressions.
I’d like to give details on the PCRE changes that especially affected MariaDB.
PCRE now includes support
for [[:<:]] and [[:>:]]
as used in the BSD POSIX library (written by Henry Spencer) to
mean “start of word” and “end of word“,
respectively. This is a good news for those project (like
MariaDB) migrating from the Henry Spencer’s library to PCRE, as
this non-standard syntax seemed to be used quite widely. Many
thanks to Philip Hazel and the PCRE team who kindly added this
extension into …