Planet MariaDB

In our first part of the Pgpool-II series, the Installation and Configuration of Pgpool-II were discussed. This part will focus on one prominent feature of Pgpool-II, which is Load Balancing/Query Routing.  What is Load Balancing? load balancing is the process of distributing a set of tasks over a set of resources (computing units), with the … Continue reading Load Balancing/Query Routing using PGPOOL-II ( Part-II) →… Read more

The MariaDB Foundation will be hosting a Server Fest on Thursday 17 November 2022. This time it’ll be a hybrid event, harnessing the energy that comes from many of the participants being present in person. … Continue reading "MariaDB Server Fest 17 Nov 2022" The post MariaDB Server Fest 17 Nov 2022 appeared first on MariaDB.org…. Read more

Tungsten Connector, the highly customizable, intelligent database proxy for the Tungsten Stack, provides finely-grained options for selecting the right data source to execute SQL requests against. These options include: Quality of Service: request a primary or a replica Maximum replica latency: select replica that are most up-to-date Site-Affinity: specify which AZ or site the node should be part of, by order of preference Node selection: point a specific node that should be picked if available Negative affinity: exclude a whole site or given node For customers that have a hand on their application and wish to add intelligence and fine-grain… Read more

Many years ago I sat next to a Couchbase exec at a VLDB event and was explained on how awesome their new storage engine was especially when compared to RocksDB. That new engine was based on ForestDB and while the idea was interesting the engine was never finished. On the bright side I got to meet the clever person who invented the ForestDB algorithm and had fun evaluating the perf claims (blog posts A, B, C, D).At last, Couchbase has a new storage named Magma. The VLDB paper is worth reading, the engine design is interesting and the product is… Read more

Storage engines for OLTP focus on storing small objects and by small object I mean sizeof(object) = sizeof(page). Given the growth of the document model we need some OLTP storage engines to be efficient and performant for larger objects. What might that mean? The rest of this post is speculation by me. I am far from an expert on this topic and will try to be careful. The topic would make for an interesting conference paper.This post is more truthy then true. It has speculation, unanswered questions and likely has several mistakes or things I omitted because I was not aware… Read more

Here 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 […]… Read more

Autumn brought new cool features and improvements to Percona Monitoring and Management (PMM) in V2.31. Enhanced user experience with the updated main menu, Alerting, and better PostgreSQL autovacuum observability with the new Vacuum dashboard are the major themes that we focused on in this release. Check out our Release Note of 2.31 for the full […]… Read more

Geo locations are a cornerstone of modern applications. Whether you’re a food delivery business or a family photographer, knowing the closest “something” to you or your clients can be a great feature. In our ‘Scaling and Optimization’ training class for MySQL, one of the things we discuss is column types. The spatial types are only […]… Read more

We are pleased to announce the preview release of the MariaDB 10.11 series, MariaDB 10.11.0. Candidate features for MariaDB 10.11 Preview releases are designed to get features into the hands of users more quickly, and should not be used for production. … Continue reading "MariaDB 10.11.0 preview release now available" The post MariaDB 10.11.0 preview release now available appeared first on MariaDB.org…. Read more

The microservice architecture is not a new pattern but has become very popular lately for mainly two reasons: cloud computing and containers. That combo helped increase adoption by tackling the two main concerns on every infrastructure: Cost reduction and infrastructure management. However, all that beauty hides a dark truth: The hardest part of microservices is […]… Read more

Monthly Percona Developer Meetup What is this? This new meetup is your chance to get a behind-the-scenes view and to interact directly in person with our engineers. You can jump into the session and discuss with our engineers without any barriers in between. If you do have questions, new ideas, enhancements, or are just curious to learn more, you’re welcome to join our call. We’ll discuss development practices, tools, projects, frameworks, and many more engineering-focused topics we are working on at Percona…. Read more

Troubleshooting performance degradation caused by pileup of queries stuck in “Waiting for table flush” state in MySQL and MariaDB. The post MySQL / MariaDB: Waiting for table flush appeared first on Shattered Silicon…. Read more

September was and is an extremely fruitful month (especially for the black-hat hackers) for news about data leaks and breaches: Uber suffers computer system breach, alerts authorities GTA 6 source code and videos leaked after Rockstar Games hack Revolut breach: personal and banking data exposed In this blog post, we want to remind you how […]… Read more

When you develop an application you expect success, and often success comes with growth problems.  These problems especially show themselves in the area of data storage, where being stateful is not as easy to scale as the stateless parts of the application. There are several stages of approaching database scalability: Configuration and query optimization. This […]… Read more

Mydumper supports streaming of backups right from version 0.11.3 and the latest version Mydumper 0.12.3 it enabled its support for compressed streaming backup. This was the most awaited feature added to Mydumper, making it a more powerful tool for data migration to RDS or Cloud. If you are hearing mydumper for the first time, then … Continue reading Stream MySQL data with mydumper →… Read more