Planet MariaDB Server

This post explains the impact of compression for write-heavy workloads with universal compaction in RocksDB. With an LSM you can spend on CPU to save on space. For leveled compaction I normally use no compression for L0, L1 and L2 because compressing them has a small impact on space but costs a lot in CPU and write stalls. My advice for universal compaction is similar — don't compress everything.tl;drFor fillseq (load in key order) the insert rates are better with less compression, so no compression beats LZ4 and LZ4 beats ZSTD because with stronger compression there are more write stalls…. Read more
By Mark Callaghan
2024-05-24
Source: Small Datum
MySQL and MariaDB are two major open source database management systems that share a common codebase and history. MariaDB started as a MySQL fork in 2009 to provide an alternate database version following Oracle’s acquisition of MySQL.While MariaDB has many features and has grown in popularity among users seeking a more open and community-driven development […]… Read more
By David Quilty
2024-05-23
Source: Percona
A lot of people use Meanwell power supplies as the replacements for the poor quality ones that came with the Amiga. Typically, the 50W variants such as the RPT-60B are used because it fits nicely inside an original Amiga power supply. I wanted to see if I could use a 75W PSU for heavily upgraded […]… Read more
By LinuxJedi
2024-05-23
Summary In this blog, part of a series of “Recently a Customer Asked” posts for Tungsten University, we explore the reason for the occasional Tungsten Replicator OFFLINE:ERROR state when applying to AWS Redshift, along with possible steps to compensate for the issue. The Question How do we handle the occasional Tungsten Replicator OFFLINE:ERROR state when applying to AWS Redshift? We see Errno 104 Connection reset by peer messages. The Reason It appears that there was a transient error with s3cmd, which is used to upload files to AWS S3 as part of the process to load data into RedShift. For this specific customer, the… Read more
By flashg
2024-05-22
Today at the Nutanix .NEXT conference in Barcelona, Spain, we announced the upcoming general availability of MariaDB Enterprise Server on … Continued… Read more
By Andrew McIntyre
2024-05-21
If you were to ask me the question, “Would it be possible to set up a replicate filter within the Percona XtraDB Cluster?” my immediate response would be to question you right back. Why would you even want the cluster nodes to have different data when you’re using a synchronous replication cluster? That’s because, instinctively, […]… Read more
By Edwin Wang
2024-05-20
Source: Percona
The 27th is fast approaching but you can still signup to our live webinar where we will be exploring the benefits of time series data using MariaDB ColumnStore…. Read more
By gill
2024-05-20
Source: Vettabase
We’re excited to announce SkySQL has joined the MariaDB Foundation as a Silver sponsor. SkySQL is the first and only database service designed, built and optimised specifically for MariaDB Server. … Continue reading "SkySQL is our new Silver sponsor!" The post SkySQL is our new Silver sponsor! appeared first on MariaDB.org…. Read more
By Anna Widenius
2024-05-20
We are pleased to announce the general availability (GA) of MariaDB Connector/J 3.4. MariaDB Connector/J 3.4 is the newest version … Continued… Read more
By Diego Dupin
2024-05-17
The MariaDB Foundation is pleased to announce the availability of MariaDB 10.11.8, MariaDB 10.6.18, MariaDB 10.5.25 and MariaDB 10.4.34, the latest stable releases in their respective long-term series (maintained for five years from their first stable release dates), as well as MariaDB 11.2.4, MariaDB 11.1.5 and MariaDB 11.0.6, the latest stable releases in their respective short-term series (maintained for one year). … Continue reading "MariaDB 11.2.4, 11.1.5, 11.0.6, 10.11.8, 10.6.18, 10.5.25, 10.4.34 now available" The post MariaDB 11.2.4, 11.1.5, 11.0.6, 10.11.8, 10.6.18, 10.5.25, 10.4.34 now available appeared first on MariaDB.org…. Read more
By Ian Gilfillan
2024-05-17
Both MariaDB and MySQL have been around a long time now, and there is always a difficult balance between maintaining compatibility whilst also solving security issues that arise. … Continue reading "MariaDB Dump File Compatibility Change" The post MariaDB Dump File Compatibility Change appeared first on MariaDB.org…. Read more
By Andrew Hutchings
2024-05-17
Many applications have dozens and sometimes even thousands of CRUD screens (Create, Read, Update, and Delete)…. Read more
2024-05-17
AI was everywhere at Intel Vision this week in London. Nearly every keynote and breakout presentation was centred around AI. I had the honour of being interviewed by Intel’s jovial Chief Commercial Officer Christoph Schell, who is just about as stereotypically German as his former neighbour from Stuttgart Jürgen Klopp (whom he referenced on-stage), namely: not at all. … Continue reading "MariaDB Vector at Intel Vision – AI Everywhere" The post MariaDB Vector at Intel Vision – AI Everywhere appeared first on MariaDB.org…. Read more
By Kaj Arnö
2024-05-17
MariaDB Performance Schema is a powerful tool designed to monitor and analyze the performance of your MariaDB server. It provides … Continued… Read more
By Aman Singh
2024-05-16
Selecting the appropriate database technology for your needs is crucial for ensuring compatibility with existing applications and infrastructure, optimizing application performance, and reducing costs. With so many different choices available, it can be difficult to make such a decision!This blog post provides a head-to-head comparison of MariaDB vs. PostgreSQL, MongoDB, and MySQL, highlighting their similarities […]… Read more
By David Quilty
2024-05-16
Source: Percona