MariaDB 10.1 not only contains tons of new features, it has also
been polished to deliver top performance. The biggest improvement
has been achieved for scalability on massively multithreaded
hardware.
The following numbers show the throughput for a simplified
sysbench OLTP benchmark on MariaDB-10.1.8 compared to
MariaDB-10.0.21:
| OLTP clients | MariaDB-10.0.21 | MariaDB-10.1.8 | increase |
|---|---|---|---|
| 160 | 398124 | 930778 | 135% |
| 200 | 397102 | 1024311 | 159% |
| 240 | 395661 | 1108756 | 181% |
| 320 | …
With the release of 10.1.8, MariaDB takes a next step. MariaDB 10.1 is now considered a stable release.
MariaDB 10.1 has a couple of main themes:
During the last few years there have been many request for more security features in MariaDB. Actually it’s a trend in general. Since open source software is getting more attractive all the time, more functionality is wanted in areas where proprietary software typically has been leading. This is especially true for databases. In addition data privacy is a very hot topic.
The big new thing in security for MariaDB 10.1 is a complete data at rest encryption solution. The encryption that now is in use originates from Google’s encryption patch. It has now been migrated into MariaDB 10.1. The …
[Read more]A common way to implement point in time recovery capability is:
to regularly do a full backup of a database, and to save the binary logs of that database (or from its master if doing backups on a slave).
When point in time recovery is required you need to:
restore a backup, and apply the binary logs up to the point of recovery.
(Step # 2 and # b above are the ones that will be simplified
A while ago I wrote a blog post about time series database requirements that has been amazingly popular. Somewhere close to a dozen companies have told me they’ve built custom in-house time series databases, and that blog post was the first draft of a design document for it.
One of the things I said in the post was that I had no use for the “tagging” functionality I’ve seen in time series databases such as OpenTSDB. I’ve since reconsidered, although I think the functionality I now want is a bit different.
What does it mean to “tag” metrics? Typically, many time series databases let you add name=value pairs (tags) to individual time series points (observations). For example, you measure CPU usage to be 59% at 3:41PM on host inst413, and you tag this measurement as “shard=81” because inst413 holds data for shard 81. …
[Read more]
Recently I blogged about identifying necessary index changes when
changing the character set for a MySQL database. In this
follow-up post I want to talk about general schema changes that
you should consider when changing your character set from latin1
to utf8, from utf8 to utf8mb4, etc. The main issue is with long
VARCHAR columns and columns with columns with length
limits that are enforeced in bytes rather than characters.
The manual points out the main areas where you may have trouble:
A TINYTEXT column can hold up to 255 bytes, so it can hold up to 85 3-byte or 63 4-byte characters. Suppose that you have a TINYTEXT column that uses utf8 but must be able to …
This Log Buffer edition works it way through some of the coolest blog posts from Oracle, SQL Server and MySQL of the past week.
Oracle:
On September 21st, we released Percona XtraDB Cluster 5.6.25. This is the first PXC release supporting proxy-protocol that has been included in Percona Server since 5.6.25-73.0.
With this blog post, I want to promote a new feature that you may have ignored.
Let’s start with a description of the use case:
Architecture Overview:
HAProxy is configured like this:
listen 3307-active-passive-writes 0.0.0.0:3307
mode tcp
balance …[Read more]
Join us for this live webinar on Tuesday, October 27th, led by our colleague Art van Scheppingen, Senior Support Engineer at Severalnines. Art recently joined us from Spil Games in Amsterdam, where he was Head of Database Engineering. He’ll be discussing and demonstrating the new release of ClusterControl and will be available for questions on its new features.
Register here for Asia PAC / Europe MEA timezones
Register here for Latin AMER / North AMER timezones
This is our …
[Read more]Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on October 15th 2015. Binaries are available from downloads area or from our software repositories.
Based on Percona Server 5.6.26-74.0 including all the bug fixes in it, Galera Replicator 3.12, and on …
[Read more]Update 2016-01-30: restarting the IO_THREAD might be considered useful in some situations (avoiding MDEV-9138). Look for "in contrast, if the IO thread was also stopped first" in MDEV-6589 for more information.
In a previous post, I listed some sequences of commands that you should not run on a MariaDB slave that is lagging and which is using the GTID protocol. Those are the following (do not
