Lets start by considering a scenario where records are being inserted in a single auto-increment table via different nodes of a multi-master cluster. One issue that might arise is ‘collision’ of generated auto-increment values on different nodes, which is precisely the subject of this article.
As the cluster is multi-master, it allows writes on all master nodes. As a result of which a table might get same auto-incremented values on different nodes on INSERTs. This issue is discovered only after the writeset is replicated and that’s a problem!
Galera cluster suffers with the similar problem.
Lets try to emulate this on a 2-node Galera cluster :
1) On node #1:
MariaDB [test]> …
The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.35. This is a Stable release.
See the Release Notes and Changelog for detailed information on this release and the Galera page in the MariaDB Knowledge Base for general information about MariaDB Galera Cluster.
Download MariaDB Galera Cluster 5.5.35
Release Notes Changelog About MariaDB Galera Cluster
Thanks, and enjoy MariaDB! …
Continue reading “MariaDB Galera Cluster 5.5.35 Now Available”
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.
Release Notes Changelog What is MariaDB 10.0?
See also: The final piece of the puzzle.
Thanks, and enjoy MariaDB! …
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.
…
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. …
A very happy new year to you from the MariaDB Foundation. Since I last wrote in June the Foundation has been doing plenty of work on everyone’s behalf.
First there’s the extensive technical work that Monty wrote about, which has been carried out by the team the Foundation employs who all work for Monty. He would like to grow that team a little, so your donations — or even corporate sponsorship or membership — would be especially welcome at the moment. With the move of the Monty Program staff he used to employ over to SkySQL, there’s no longer any cross-subsidy between consulting work and the fix-sustain-build mission of the Foundation’s core team, so we depend completely on donations and corporate support to make that happen. …
The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.35. This is a Stable (GA) release. See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 5.5? page in the MariaDB Knowledge Base for general information about the MariaDB 5.5 series.
Release Notes Changelog What is MariaDB 5.5?
…
The availability of the node.js binding for MariaDB’s non-blocking client library together with the GIS capabilities of MariaDB inspired me to make an example of using node.js and MariaDB to import so-called GPX tracks to a MariaDB database and then show them on a map. GPX tracks are what are stored by many GPS devices including running watches and smartphones.
My project makes use of MariaDB’s non-blocking client library together with the node.js platform and on top of that uses the GIS functionality found in MariaDB 5.5 and 10.0.
To start with let’s go through the software and components I’m using:
- Node.js – The popular Node.js platform built on Chrome’s JavaScript runtime.
…