Blog

  • Scripts for migrating bug reporting from Launchpad to JIRA

    About two and a half years ago I wrote about how the MariaDB project moved bug reporting from Launchpad to JIRA. Every now and then I get contacted about how it was done and whether I would be willing to share the tools used for doing it and of course I’ve done that. Especially in one occasion the scripts were even further developed by one company that was in the process of doing exactly the same, i.e. moving bugs from […]

  • A few interesting findings on MariaDB and MySQL scalability, multi-table OLTP RO

    It’s been almost a year since I benchmarked MariaDB and MySQL on our good old 4 CPU / 32 Cores / 64 Threads Sandy Bridge server. There seem to be a few interesting things happened since that time.

    • MySQL 5.6.23 peak throughput dropped by ~8% compared to 5.6.14. Looks like this regression appeared in MySQL 5.6.21.
    • 10.0.18 (git snapshot) peak threads increased by ~20% compared to 10.0.9 and reached parity with 5.6.23 (not with 5.6.20 though).
    • 10.1.4 (git snapshot) and 5.7.5 are the champions (though 10.1.4 was usually 1-5% faster). Both have similar peaks @ 64 threads. They seem to be pushing this system limits, since both have capacity to scale more.
    • 5.7.6 has serious (~50%) scalability regression compared to 5.7.5. There is heavy LOCK_plugin mutex contention, which seem to be caused by query rewrite plugin framework. I couldn’t find way to disable it. Hope this will be fixed in coming releases.
  • MariaDB Galera Cluster 10.0.17 and 5.5.42 now available

    The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.17 and MariaDB Galera Cluster 5.5.42. Both are Stable (GA) releases.

    Download MariaDB Galera Cluster 10.0.17

    Release Notes Changelog What is MariaDB Galera Cluster?

    Download MariaDB Galera Cluster 5.5.42

    Release Notes Changelog What is MariaDB Galera Cluster?

    MariaDB APT and YUM Repository Configuration Generator

    See the Release Notes and Changelogs for detailed information on these releases.

    Thanks, and enjoy MariaDB!

  • Changes in the MariaDB Foundation board and management

    Year 2014 was an important year for the MariaDB project with the release of MariaDB 10.0. Adoption continued to grow both organically and by MariaDB being included both in the Red Hat Enterprise Linux and Suse Linux Enterprise Server distributions as the default database option. Ubuntu started providing MariaDB as an option since their release 14.04. MariaDB also came available in many cloud services, e.g. DBaaS in the Rackspace Cloud and Cloud Foundry. Those are just a few highlights. There […]

  • Table and tablespace encryption on MariaDB 10.1.3

    Note that this post is now outdated. See Table and tablespace encryption on MariaDB 10.1

    Introduction

    For the moment, the only engines that fully support encryption are XtraDB and InnoDB. The Aria storage engine also supports encryption, but only for temporary tables.

    MariaDB supports 2 different way to encrypt data in InnoDB/XtraDB:

    1. Specified table encryption: Only tables which you create with PAGE_ENCRYPTION=1 are encrypted. This feature was created by eperi.
    2. Tablespace encryption: Everything is encrypted (including log files). This feature was created by Google and is based on their MySQL branch.
  • MariaDB 10.0.17 and 10.1.3 now available

    The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.17 and MariaDB 10.1.3. MariaDB 10.0.17 is a Stable (GA) release. MariaDB 10.1.3 is a Beta release.

    Download MariaDB 10.0.17

    Release Notes Changelog What is MariaDB 10.0?

    Download MariaDB 10.1.3

    Release Notes Changelog What is MariaDB 10.1?

    MariaDB APT and YUM Repository Configuration Generator

    See the Release Notes and Changelogs for detailed information on these releases.

    Thanks, and enjoy MariaDB!

  • Causal Consistency

    Introduction

    Causal consistency [1] is one of the consistency criteria that can be used on distributed databases as consistency criteria.

    Distributed database provides causal consistency if read and write operations that are causally related are seen by every node of the distributed system in the same order. Concurrent writes may be seen in different order in diffrent nodes.  Causal consistency is waker than sequential consistency [2] but stronger than eventual consistency [3]. See earlier blog for more detailed description on […]

  • MariaDB at SCALE13x

    Come see us at SCALE13x in Los Angeles, February 19-22 2015, at the Hilton Los Angeles Airport. The schedule has Max Mether speaking on Friday and Colin Charles speaking on Saturday. MariaDB Corporation will also have a booth at the expo hall with giveaways, so come say hi to Marc Sherwood and Rod Allen. If you need a discount code, remember to use SPEAK and save some money!