The MariaDB Foundation is pleased to announce the releases of MariaDB C Client Library 2.0 and MariaDB JDBC Client 1.1.7

The MariaDB Client Library for C 2.0 is a major release which contains more than 70 bug fixes and a lot of new functions and features, e.g.

SSH support
Dynamic Columns API
Support for MinGW and Objective/C
Read-ahead cache

…and much more!

For a complete list of all new features please visit MariaDB Client Library for C 2.0.0 Release Notes

We are very proud for getting a tremendous amount of contributions: bug reports, ports, patches and suggestions which helped us a lot to improve the quality and to add new features. …

Continue reading “MariaDB Client Library for C 2.0 and Maria JDBC Client 1.1.7 released”

The MariaDB project is pleased to announce MariaDB ODBC Driver Beta – the start of the public beta testing phase of MariaDB ODBC Driver

MariaDB ODBC Driver is a standarized database driver for Windows platforms. It supports ODBC Standard 3.5 and can be used as a drop-in replacement for MySQL Connector/ODBC.

Maria ODBC Driver is licensed under the LGPL license. It is compatible to MySQL Connector/ODBC and supports both Unicode and ANSI mode.

MariaDB ODBC Driver is build on top of the MariaDB LGPL C library and uses binary prepared statement protocol for client server communication.

For more information please visit the MariaDB ODBC Driver page …

Continue reading “New kid on the block: MariaDB ODBC Driver 0.9.1-beta”

MariaDB 10 is nearing GA, and it makes sense to make sure that the test suite from MySQL 5.6 is merged into MariaDB 10. Svoj is doing a lot of this work, and then we like to look at features, especially ones that are deprecated upstream. We don’t do that on blogs, but on the maria-developers mailing list.

I bring to your attention: Intermediate status for test cases merge. We see that INSERT DELAYED and SHOW PROFILE for example are deprecated in MySQL 5.6. The only way for feedback to the MySQL team seems to be comments on Morgan’s blog.

…

Continue reading “Merging 5.6 test cases and thoughts on feature deprecation in MariaDB 10.0”

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]. …

Continue reading “MariaDB Eventually Consistent?”

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”

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]> …

Continue reading “Auto increments in Galera”

Last night, after my previous blog post, everyone in attendance at the SkySQL developer meeting in Barcelona gathered for dinner at El Cangrejo Loco, which, if my High School Spanish is working, translates as The Crazy Crab. After the excellent food, the tradition of singing at MySQL/MariaDB developer meetings was preserved.

Today the MariaDB developers in attendance at the SkySQL developer meeting in Barcelona got together to work on plans for MariaDB 10.1. We also paused for a group photo:

Many tasks have been identified for possible inclusion in 10.1. Some have already been marked as such in JIRA.

…

Continue reading “What do you want to see in MariaDB 10.1?”

Several MariaDB developers are attending SkySQL’s annual engineering meeting being held this week in Barcelona. While some of the discussions are SkySQL-specific (customers, internal projects, and so on), there are, naturally, lots of MariaDB discussions happening.

Patrik Sallner, CEO of SkySQL, opened the meeting this morning with a short presentation about SkySQL’s goals for 2014. While the plan includes standard business-like things that include growing the company and sales goals, the top two goals for 2014 are: