Planet MariaDB

Percona Server for MySQL 8.0.30-22 introduces several improvements for the LDAP plugin: SASL support, support for fallback servers, and support for LDAP-based authorization. All improvements are in technical preview. A description of the existing plugin features and usage instructions are available in the earlier blog post introducing the LDAP simple plugin, and in the Percona […]… Read more

What is a Delay Replica and how does it help? MySQL Replication is useful, easy to set up, and used for very different purposes. For example: split reads and writes run data mining or reporting processes on them disaster recovery To learn more, check out How Does MySQL Replication Work? It’s important to mention that […]… Read more

ProxySQL is a very useful tool for gaining high availability, load balancing, query routing, query caching, query rewriting, multiplexing, and data masking. It is a proven tool and is used largely in production. There can be an instance of ProxySQL using a lot of memory on the server. This post is related to one of […]… Read more

The need to audit who is using a database and their activities is crucial in many environments. This functionality is available in the free, open source Audit Plugin that is included in Percona Server for MySQL. The prerequisite for installing Percona’s Audit Log Plugin is to first install Percona Server for MySQL. Percona Server for […]… Read more

MariaDB supports several ways to compose strings dynamically. Some of them might be well-known, others aren't familiar to you. This article covers all the ways to compose strings…. Read more

While I am a huge fan of research papers presenting storage engines that claim to be better than RocksDB, I am always wary of the performance results. A paper can be great despite an imperfect performance evaluation, so pointing out the imperfections doesn't take away from the interesting ideas in the paper. Also, as a believer of the (C)RUM Conjecture I want to know how the new thing is better and worse, but papers mostly focus only on the better parts and don't highlight what isn't better.One factor that determines the truthiness of a database benchmark is the number of… Read more

Database-as-code service is a new concept and gaining some popularity in recent years. As we already know, we have deployment solutions for application code. Managing and tracking application changes are quite easy with tools like Git and Jenkins. Now this concept is applied in the database domain as well, assuming SQL as a code to […]… Read more

Participating in various community activities can be rewarding in different aspects. Many community members joined Hacktoberfest this year and contributed to various open source projects, and we would like to highlight the most active contributors to Percona software during this fantastic event. Each of them will receive a T-shirt and a mug with a unique […]… Read more

Data masking is a handy tool to obscure sensitive information.  Percona Server for MySQL is a free, fully compatible, enhanced, and open source drop-in replacement for any MySQL database. It provides superior performance, scalability, and instrumentation including data masking. With Percona Server for MySQL, you get the enterprise features without the cost.   So how does […]… Read more

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/C++ 1.1.2 RC release. Download Now Release Notes MariaDB … Continued… Read more

One of my hobbies is testing open source DBMS for CPU regressions and for that I want to compare perf between old and new versions of the DBMS. Depending on the DBMS it can be a challenge to build the old DBMS with the current (modern) compiler toolchain. Using open source frequently means compiling from source and compiling from source eventually means debugging a failed build. Alas, the proliferation of build tools means you are likely to be debugging a build tool you know little about. For me that included svn+MongoDB, cmake+MySQL, make/configure+MySQL, mvn+Linkbench, mvn+First_Robotics and make+RocksDB. Perhaps my debugging would… Read more

While the LAMP stack – Linux/Apache/MySQL/PHP – is not the dominant platform it was a decade ago, there are still many websites that depend on it. One of the pillars of this quartet had a milestone last week when PHP 8.0 passed into End Of Life status. While it will still have limited security issue […]… Read more

The Primary key is like the hero of a row, which has more beneficial features in the table while performing any task on the table. The DBA knows the importance of the primary key in the table and how to handle it. Notable features of having a primary key: From 8.0.30, no need to maintain … Continue reading Generate Invisible Primary Key (GIPK) MySQL 8.0 →… Read more

This has results for the insert benchmark using Postgres, InnoDB and MyRocks. For an overview of the insert benchmark see here and here. Some information on the performance summaries generated by my test scripts is here. I used small servers and ran the test at low concurrency (1 or 2 threads) for cached and IO-bound workloads. The insert benchmark has several phases and the interesting phases are: insert-only without secondary indexes, insert-only with 3 secondary indexes and then range queries with rate-limited inserts.Performance reports are provided for:Postgres versions 12.11, 13.7, 14.6 and 15.1: cached and IO-boundInnoDB 5.6.49, 5.7.35, 8.0.21 and 8.0.31: cached and IO-boundMyRocks 5.6.35 and 8.0.28: cached and IO-boundDisclaimer -… Read more

We all know that data is important, and some businesses need historical data to be available all the time. The problem is that queries on large tables perform poorly if they are not properly optimized. We get many customer requests in Managed Services to purge/archive large tables, and to achieve it, we use pt-archiver. Recently, […]… Read more