Background
Eventual consistency is a consistency model used in many large distributed databases which requires that all changes to a replicated piece of data eventually reach all affected replicas; conflict resolution is not handled and responsibility is pushed up to the application author in the event of conflicting updates [13].
Eventual consistency is a specific form of weak consistency; the storage system guarantees that if no new updates are made to the object, eventually all accesses will return the last updated value [14]. If no failures occur, the maximum size of the inconsistency window can be determined based on factors such as communication delays, the load on the system, and the number of replicas involved in the replication scheme [3]. …
A MariaDB Howto authored by: Erkan Yanar.
This is a Howto about installing MariaDB Galera Cluster on Debian/Ubuntu. Because a lot of people were having problems installing MariaDB Galera Cluster, elenst from #maria on freenode forced me to write this Howto 🙂
Installing MariaDB Galera Cluster is in fact quite easy and actually kind of boring in the end. This Howto is written for (and tested on) on Debian 7.1 (Wheezy) and Ubuntu 12.04 (Precise).
What we need
In our setup we assume 3 nodes (node01, node02, node03) with one interface each. We assume following IP addresses: 172.16.8.5, 172.16.8.6, and 172.16.8.4. …
Continue reading “Installing MariaDB Galera Cluster on Debian/Ubuntu”
MariaDB is participating in the Google Summer of Code 2014. Students are encouraged to propose a project before the deadline (this Friday!).
This is our second year participating, and as always we have an ideas page available. We also have a list of things we think are achievable in JIRA – check out our gsoc14 tag.
In 2013, we had three projects, of which two are in MariaDB 10.0: PCRE regular expressions and Roles. The other will be targeted towards MariaDB 10.1. There’s nothing like having GSoC students participate and have their code in shipping products.
…
The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.9. This is a Release Candidate release.
Among other changes, XtraDB is now the default InnoDB implementation, Oracle’s InnoDB is included as a plugin and can be dynamically loaded if desired. Packages for Ubuntu 14.04 “trusty” and Debian “Sid” have also been added to the MariaDB Ubuntu and Debian repositories.
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. …
The MariaDB developers have made several releases in the past week. Rather than post about all of them separately, we decided to combine them into one post. Details for each release are available on their individual Release Notes and Changelog pages.
MariaDB 5.5.36
First up is MariaDB 5.5.36. This is a Stable (GA) release. Apart from general maintenance, bug fixes, and updates, TokuDB is now included in RPM packages for CentOS 6 on x86-64.
Release Notes Changelog What is MariaDB 5.5?
…
I’m happy to announce that a new version of the MariaDB Audit Plugin is available. Version 1.1.5 can be downloaded here. As you can see the Audit Plugin is available from SkySQL, who has developed the plugin.
However, now with the Audit Plugin being GA for a couple of months since 7th of November last year and customers using it in production, SkySQL has decided to contribute the Audit Plugin to the MariaDB project and I’m happy to tell you that starting from MariaDB versions 5.5.37 and 10.0.9 the Audit Plugin will be included by default. …
Continue reading “An update on the MariaDB Audit Plugin and a new version of it”
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”