Planet MariaDB Server

Years ago, it was extremely common to store user-uploaded images and other multimedia contents in a database. This practice became less common over time, but I still hear questions like: would it be a bad idea to store images in our database? Or, more specifically: how bad would it be to store images in a database? In this article, we’ll discuss the pros and cons. TL;DR: No, you shouldn’t store images in a database. But it’s a very simple solution, so in your team is undersized or your website is trivial, keep reading. Pros Yes, there are obvious pros in… Read more

One of the standout features of Oracle PL/SQL is the associative array — a versatile and efficient in-memory data structure that developers rely on for fast temporary lookups, streamlined batch processing, and dynamic report generation. … Continue reading "Bringing Oracle’s Associative Arrays to MariaDB" The post Bringing Oracle’s Associative Arrays to MariaDB appeared first on MariaDB.org…. Read more

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Node.js 3.4.4 GA release. Release Notes MariaDB Connector/Node.js MariaDB […]… Read more

MySQL Analysis: With an AI-Powered CLI Tool As DBAs with MySQL we often live on a Linux terminal window. We also enjoy free options when available. This post shows an approach that allows us to stay on our terminal window and still use an AI-powered tool. You can update to use other direct AI providers but I set this example up to use aimlapi.com as it brings multiple AI models to your terminal for free with limited use or very low cost for more testing. Note: I'm not a paid spokesperson for AIMLAPI or anything – this is just an… Read more

Welcome to this first installment of the blog series, which explores how PostgreSQL and MySQL deal with different aspects of relational databases. As a long-time open source database administrator, I have always been fascinated by the differences in how these two databases handle various challenges and how DBAs who know one of these technologies often […]… Read more

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Node.js 3.4.3 GA release. Release Notes MariaDB Connector/Node.js MariaDB […]… Read more

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Java 3.5.4 release. Release Notes and Changelogs MariaDB Connector/Java […]… Read more

We are delighted to welcome Hetzner as a Gold Sponsor of the MariaDB Foundation! Hetzner’s exceptional commitment to supporting our infrastructure has a direct and strategic impact on our operations. … Continue reading "Hetzner Becomes Gold Sponsor of the MariaDB Foundation: Powering Our Build Infrastructure" The post Hetzner Becomes Gold Sponsor of the MariaDB Foundation: Powering Our Build Infrastructure appeared first on MariaDB.org…. Read more

Toying around with MariaDB : query cache editionMariaDB’s query cache , as explained here is a legacy memory-based mechanism which stores the results of SELECT queries to avoid recalculating them when identical queries are executed again. When a SELECT query is run, MariaDB first checks if the result already exists in the cache and returns it directly if found, which significantly improves performance for repetitive queries. The cache is automatically maintained ensuring data consistency in returned results.It is easy to setup with two simple parameters and an optional third to prevents some typos, untrimmed spaces and comments to get in the way, as follows :query_cache_type… Read more

At Percona, we operate on the premise that full transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form, report back on any issues or bugs you might encounter along the way. We constantly update our bug reports and monitor other boards to ensure we have the latest information, but we wanted to make it a little easier for you to keep track of the most critical ones. This post is a central… Read more

We are proud to welcome Nextcloud GmbH to the MariaDB Foundation sponsor family as a Silver Sponsor. As the world’s most popular privacy-focused platform for secure file sharing, collaboration, and communication, Nextcloud stands as a pillar of digital sovereignty — a value that resonates deeply with MariaDB Foundation’s mission. The post Nextcloud joins MariaDB Foundation as Silver Sponsor, strengthening the European open source backbone appeared first on MariaDB.org…. Read more

At Percona, we’ve always been dedicated to providing robust, open source solutions that meet our users’ evolving needs. Percona XtraDB Cluster (PXC) stands as a testament to this commitment, offering a highly available and scalable solution for your MySQL and Percona Server for MySQL deployments. We understand that database high availability is critical for your […]… Read more

The MariaDB Foundation is pleased to announce the availability of a preview of the MariaDB 12.1 series. MariaDB 12.1 will be a rolling release. … Continue reading "MariaDB 12.1 preview available" The post MariaDB 12.1 preview available appeared first on MariaDB.org…. Read more

Write a blog post in the style of a top 1% senior MySQL DBA. Topic: Percona Earns Kubernetes Certified Services Provider Status for All Three Major Open Source Databases…. Read more

Percona Everest is a free and open source tool for running and managing databases like PostgreSQL, MySQL, and MongoDB inside Kubernetes. It simplifies things by providing three ways to work with your databases: a web interface (UI), a set of commands (API), and direct access through Kubernetes itself using built-in tools like kubectl. > Note: […]… Read more