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. Thank you!.

MariaDB Client Library for C is fully …

Want to use C#/.NET with Sphinx? This blog post will tell you how to do it. Check it out. Sphinx with C#/.NET Here are your options: use SphinxSE. This option makes sense only if you already use MySQL server and you want to use Sphinx via the MySQL server… It has it’s advantages and disadvantages. [...]

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

The MariaDB project is pleased to announce a special preview release of MariaDB 10.0.9 with significant performance gains on FusionIO devices. This is is a beta-quality preview release.

Download MariaDB 10.0.9-FusionIO preview

Background

The latest work between MariaDB and FusionIO has focused on dramatically improving performance of MariaDB on the high-end SSD drives produced by Fusion-IO and at the same time delivering much better endurance for the drives themselves. Furthermore, FusionIO flash memory solutions increase transactional database performance. MariaDB includes specialized improvements for FusionIO devices, leveraging a feature of the NVMFS filesystem on these popular, high performance solid state disks. Using this feature, MariaDB 10 can eliminate some of the overhead within the InnoDB storage engine …

On Thursday MySQL technology saw a huge boost. It’s hard for anyone now to argue that MySQL isn’t in the game of extreme scalability and performance, which some NoSQL vendors have been using as a tagline for the last years. To see four of the largest MySQL and MariaDB users come together to bootstrap a branch of MySQL for extreme scaling needs is simply fantastic. The improvements done inside these companies will now be available to the rest of the community. In all fairness Facebook and Twitter, in particular, have been making their improvements publicly available also before. Google has also made some improvements available publicly over the years and have lately been active in the MariaDB project with code reviews, bug fixes and other patches. But broadening the public contributions further and combining it all, is new.

Engineering of MySQL technology happens in many places. Aside from Oracle and the companies behind WebScaleSQL, …

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. However with MariaDB, especially with the feedback plugin enabled, we have an additional layer of …

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 few examples of eventually consistent systems:

• DNS
• Asynchronous master/slave replication on an RDBMS e.g. MariaDB
• memcached in front …

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. We need three packages installed on all nodes:

• rsync
• galera
• mariadb-galera-server

As Galera does not ship with the distribution repositories, go for the …

In this blog post, we’ll talk about how Jobma improved search for their users by switching from MySQL fulltext search to Sphinx. Enjoy! What is Jobma? Jobma is a new job portal based solely on Video Resumes, which permits job seekers to quickly and directly reach potential employers. The hiring process is easier with the help [...]

Recently, 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, Part 4, Part 5 and …