Planet MariaDB Server
Monitor and alert on DDL and DCL changes in Amazon RDS for MySQL, Amazon RDS for MariaDB, and Amazon Aurora MySQL
Amazon Relational Database Service (Amazon RDS) monitoring and alerting using Amazon CloudWatch, Amazon RDS Performance Insights, and Amazon RDS Enhanced Monitoring is robust and secure, and often a top choice…
Making “tbl.utf8mb3_key_column=utf8mb4_expr” sargable
Short: Currently, a condition like tbl.utf8mb3_key_column=utf8mb4_expr is not sargable, that is, the optimizer can’t use it to construct index lookups with utf8mb3_key_column. But it’s possible to make it sargable, the…
Cost savings by migrating from MongoDB on Atlas to Self-Managed
Table of Contents In this article, we will delve into an intriguing aspect of identifying the optimal and cost-effective solution for hosting a MongoDB deployment.MongoDB clusters can be set up…
Percona Monitoring and Management 2.40 preview release
Percona Monitoring and Management 2.40 preview release Hello folks! Percona Monitoring and Management (PMM) 2.40 is now available as a preview release. We encourage you to try this PMM preview…
Combinatorial blowups can occur in Name Resolution, too.
Short: There are many places where (any) query optimizer has to take care to avoid combinatorial blowups of memory and/or processing time. But we had a real world query that…
A new chapter at MariaDB: Joining the Products Team
Announcing my transition to the Products team at MariaDB.
Is it possible for a DBA/DBE to earn 1 million USD annual compensation ?
Table of Contents My journey from Traditional RDBMS DBA to Opensource DBE/DBA My journey in the field of database administration (DBA) commenced in 2006 when I took on the role…
ANALYZE FORMAT=JSON now shows InnoDB buffer pool reads
Short: Starting from the latest MariaDB 10.6.15 and latest releases of other versions (yes, even stable ones), ANALYZE FORMAT=JSON prints counts of InnoDB page accesses and reads. Look for r_engine_stats.…
UCASE() is now sargable in MariaDB. LCASE() can’t be.
Short: UCASE(key_col)=… is now sargable in MariaDB. One can ignore the UCASE() call here, but only for a few collations. One might expect this to work for any _ci (case-insensitive)…
What is MariaDB?
An introduction to MariaDB, its features, and its unique advantages over MySQL.
Open Source And Recession – An Economic Outlook
Initially, I dropped an idea of writing this blog by reckoning the amount of time and energy required to perform research. However, my mentor Ramona Gerum motivated me and provided…
Dolphie, your real-time MySQL monitoring assistant
For as long as I can remember, Innotop has been the go-to terminal tool for real-time MySQL monitoring. It is an invaluable addition to any DBA’s toolkit, but unfortunately, it’s…
Introducing Amazon RDS for MariaDB 10.11 for up to 40% higher transaction throughput
MariaDB is a popular open-source high performance database. Amazon Relational Database Service (Amazon RDS) for MariaDB supports multiple major engine versions including 10.4, 10.5, 10.6. Today, Amazon RDS has announced support for…
Unveiling Tungsten Clustering & Tungsten Replicator v7.1.0: Explore the Power of DDGs, S3 Applier and the Innovative tpm cert Tool
Discover the future of database management with Tungsten Clustering & Tungsten Replicator v7.1.0. Explore Distributed Datasource Groups, the innovative tpm cert tool, S3 Applier, enhanced connector management, and more. Upgrade…
Unveiling Tungsten Clustering & Tungsten Replicator v7.1.0: Explore the Power of DDGs, S3 Applier and the Innovative tpm cert Tool
Discover the future of database management with Tungsten Clustering & Tungsten Replicator v7.1.0. Explore Distributed Datasource Groups, the innovative tpm cert tool, S3 Applier, enhanced connector management, and more. Upgrade…