Planet MariaDB

With the release of MariaDB Community Server 10.5, we continue what we started with our first divergence from MySQL, adding… Read more »… Read more
By Max Mether
2020-07-02
MariaDB Cluster is a Multi Master replication system built from MariaDB Server, MySQL wsrep patch and Galera wsrep provider.   Galera is based on synchronous (or ‘virtually synchronous’) replication method, which ensures the data applied to other nodes before it is committed. Having the same data on all nodes means that node failures can be easily tolerated, and no data is lost. It is also easier to failover to another node, since all the nodes are up to date with the same data. It is fair to say that MariaDB Cluster is a high availability solution that can achieve high uptime… Read more
By agus
2020-07-02
Source: SeveralNines
Thank you for the many submissions to our Call for Papers, and to your insightful replies to our Call for Attendees. Based on the CfA replies and other feedback given to us, we could draw a few conclusions. […] The post MariaDB Server Fest CfP extended until Wed 15 July 2020 appeared first on MariaDB.org…. Read more
By Kaj Arnö
2020-07-02
“Running MySQL on selected NUMA node(s)” looks pretty straightforward but unfortunately it isn’t. Recently, I was faced with a situation that demanded running MySQL on 2 (out of 4) NUMA nodes…. Read more
By Krunal Bauskar
2020-07-02
Source: MySQL on ARM
MariaDB has recently launched its new DBaaS offering, SkySQL. It might be a surprise to some, but this has been an anticipated move from MariaDB as they have been actively pushing state of the art products for enterprise services over the last few years and have been actively competing with the large market vendors. Prior to the SkySQL launch,  MariaDB has been working on containers and Helm Charts as far back as 2018. SkySQL offers database availability to multiple regions when setting up and launching your database instance. What is MariaDB SkySQL? MariaDB SkySQL is a DBaaS offering which means… Read more
By Paul Namuag
2020-07-01
Source: SeveralNines
One of the most common errors encountered in the MySQL world at large is the infamous Error 1040: [crayon-5efcd3bde80a7726559946/] What this means in practical terms is that a MySQL instance has reached its maximum allowable limit for client connections.  Until connections are closed, no new connection will be accepted by the server. I’d like to […]… Read more
By Tate McDaniel
2020-07-01
Source: Percona
Data breaches seem to be a daily occurrence, so much so that seeing an article about the latest company to fall victim draws little attention outside of those immediately impacted. That is of course unless that company is yours and data security is your responsibility! While companies continue to invest heavily in fortifying networks with […]… Read more
By David Quilty
2020-07-01
Source: Percona
In real life, there are frequent cases where getting a running application to work correctly is strongly dependent on consistent write/read operations. This is no issue when using a single data node as a provider, but it becomes more concerning and challenging when adding additional nodes for high availability and/or read scaling.  In the MySQL […]… Read more
By Marco Tusa
2020-07-01
Source: Percona
In general, databases store data in row format and use SQL as query language to access it, but this storage method is not always the best in terms of performance, it depends on the workload itself. If you want to get statistical data, you should most probably use another kind of database storage engine. In this blog, we will see what Columnar Storage is and, to be more specific, what MariaDB ColumnStore is, and how to install it to be able to process your big data in a more performant way for analytical purposes. Columnar Storage Columnar Storage is a… Read more
By Sebastian Insausti
2020-06-30
Source: SeveralNines
The 10.5 release of MariaDB Community Server which includes ColumnStore columnar storage engine is now available as an image on… Read more »… Read more
By Rob Hedgpeth
2020-06-30
In this blog post, we will briefly explore the OS tool strace. It is not widely used due to its performance impacts, and we don’t recommend using it in production. Still, it is amazing at helping you understand some things that happen in MySQL, where the OS is involved, and as a last case resource […]… Read more
By Leonardo Bacchi Fernandes
2020-06-30
Source: Percona
While there is no magic bullet for MySQL tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. While much information has been published on this topic over the years, I wanted to break down some of the more critical settings that anyone […]… Read more
By Brian Sumpter
2020-06-30
Source: Percona
Last year, I made the first post in a small series, which aimed to highlight unique features of Percona Server for MySQL, by discussing binlog_space_limit option. Today, I am going to discuss another important type of log available in MySQL that is enhanced in Percona Server for MySQL – the slow query log. The reason […]… Read more
By Przemysław Malkowski
2020-06-29
Source: Percona
MariaDB Server 10.5 is a fresh, new, and stable version from MariaDB that was released on June, 24th 2020. Let’s take a look at the features that it will bring us. More Granular Privileges With MariaDB 10.5 some changes regarding the privileges are coming. Mainly, SUPER privilege has been split into several new privileges that allows to set more granular control over what actions are allowed for given users and what are not. Below is the list of the new privileges that are available in MariaDB 10.5: BINLOG ADMIN BINLOG REPLAY CONNECTION ADMIN FEDERATED ADMIN READ_ONLY ADMIN REPLICATION MASTER ADMIN… Read more
By krzysztof
2020-06-29
Source: SeveralNines
Security Threat Tool (STT) is the new Percona Monitoring and Management (PMM) feature. It provides the ability to run automated security checks across all of your databases and detect potential security problems. For example: empty or default passwords, weak security settings, outdated database versions, misconfiguration, but also more complex and tricky issues. Security checks developed […]… Read more
By Artem Gavrilov
2020-06-29
Source: Percona