Planet MariaDB

Short version: JSON Path in MariaDB is now documented: https://mariadb.com/kb/en/jsonpath-expressions/ It supports a subset of JSON Path from SQL:2016. The subset is close to what MySQL supports. It does have an extension to do recursive searches. The search for matches is done “on the fly”, without constructing the document tree. Longer version: I got interested…More… Read more

New MariaDB releases come with regular intervals. Releasing a new version is a balance between new functionality and bugfixes on one side, and stability on the other. […] The post MariaDB Server MiniFest Wed 9.12.2020 appeared first on MariaDB.org…. Read more

C++ developers can now use the native MariaDB Connector/C++ to connect their applications to MariaDB Server on premises and in the cloud on MariaDB SkySQL…. Read more

My second talk at the MariaDB Fest was ANALYZE for statements: MariaDB’s hidden gem (slides, video). It also has a comparison with MySQL, with its EXPLAIN ANALYZE feature. MariaDB’s ANALYZE supports more kinds of statements, and a basic test has shown it has a lower CPU overhead for workloads with tight loops. I believe this…More… Read more

It’s time to resume blogging. Starting with a bit of stale news: yours truly had two talks at MariaDB Fest . The first one was the Optimizer Trace Walkthrough (video, slides). The talk covers Optimizer Trace in MariaDB and it has a comparison with MySQL’s Optimizer Trace. One interesting thing I’ve learned while presenting was…More… Read more

If I ask you if running EXPLAIN on the query can change your database, you will probably tell me NO; it is common sense. EXPLAIN should show us how the query is executed, not execute the query, hence it can’t change any data. Unfortunately, this is the case where common sense does not apply to […]… Read more

Kubernetes operators are meant to simplify the deployment and management of applications. Our Percona Kubernetes Operator for Percona XtraDB Cluster serves the purpose, but also provides users the flexibility to fine-tune their MySQL and proxy services configuration. The document Changing MySQL Options describes how to provide custom [crayon-5fbbf7ef80d2a698888219-i/] configuration to the operator. But what would […]… Read more

At work, I am in an ongoing discussion with a number of people on the Observability of Outliers. It started with the age-old question “How do I find slow queries in my application?” aka “What would I want from tooling to get that data and where should that tooling sit?” As a developer, I just […] The post On the Observability of Outliers appeared first on Percona Community Blog…. Read more

Good news for MySQL users wishing to upgrade to MariaDB: MariaDB 10.5.7 onwards understands formerly-incompatible MySQL JSON fields! This blog entry explains how to install and use them. […] The post Making MariaDB understand MySQL JSON appeared first on MariaDB.org…. Read more

In the first quarter of 2021 (expected late January), Percona is slated to release a version of Percona Monitoring and Management (PMM) v2 that will include all of the critical functionality users of PMM v1 have come to know and love over the years. While PMM v2 has some major improvements over its v1 sibling, […]… Read more

It’s release roundup time here at Percona! Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download. Today’s post […]… Read more

Because upgrading from MariaDB 10.4 to MariaDB 10.5 (non-clustered) seems not to be a problem [ 1 ] we take the challenge and try to create a receipt based on the MariaDB 10.3 to MariaDB 10.4 Galera Cluster upgrade documentation [ 3 ]: Before you start Before you begin with the upgrade you should consider a few things: Downgrade is officially not supported! [ 4 ] It might work, or not. So you should have taken a proper an clean backup before you start with the upgrade and you should be sure the restore works as well! It is recommended… Read more

Because upgrading from MariaDB 10.4 to MariaDB 10.5 (non-clustered) seems not to be a problem [ 1 ] we take the challenge and try to create a receipt based on the MariaDB 10.3 to MariaDB 10.4 Galera Cluster upgrade documentation [ 3 ]: Before you start Before you begin with the upgrade you should consider a few things: Downgrade is officially not supported! [ 4 ] It might work, or not. So you should have taken a proper an clean backup before you start with the upgrade and you should be sure the restore works as well! It is recommended… Read more

Don’t miss out! Join Peter Zaitsev, Percona CEO, as he discusses Linux Performance measurement. In this webinar, Peter will look at typical mistakes measuring or interpreting Linux Performance. He’ll discuss whether you should use LoadAvg to assess if your CPU is overloaded or Disk Utilization to see if your disks are overloaded. In addition, he’ll […]… Read more

In my former Blog Post Partial Table or Schema restore from mariabackup full backup we worked out the basics of a partial restore of a table into a MariaDB database instance. An now we use this know-how to try the same procedure on a Galera Cluster. The backup is done in the exact same way as described in the mentioned article. We can even use the backup made there. For the restore we use the following procedure: Prepare and Restore a table # BACKUPDIR="/home/mysql/bck/qamariadb105/daily" # DATADIR="/home/mysql/database/magal-105-a/data" # SCHEMA="world" # TABLE="City" # mariabackup –prepare –export –databases="${SCHEMA}" –tables="${TABLE}" –datadir=${DATADIR} –target-dir=${BACKUPDIR} But now… Read more