Planet MariaDB

MySQL is heavily tunable and some of the configuration can have significant impact on its performance. During my experiment for numa scalability I encountered one such configuration. Default configuration tends to suggest heavy contention for write workload but once tuned it helps scale MySQL by more than 2x…. Read more

FromDual has the pleasure to announce the release of the new version 1.1.0 of its popular FromDual Ops Center focmm, a Graphical User Interface (GUI) for MariaDB, MySQL and compatible databases. The FromDual Ops Center for MariaDB and MySQL (focmm) helps DBA's and System Administrators to better manage their MariaDB, MySQL and compatible databases farms. Ops Center makes DBA and Admins life easier! The main task of Ops Center is to support you in your daily MariaDB, MySQL and compatible databases operation tasks. More information about FromDual Ops Center you can find here. Download The new FromDual Ops Center for… Read more

This blog post should act as the second part in the series of blogs about indexes in MySQL. In the first part in the blog post series about MySQL indexes we have covered quite a lot of things including what they are, what do they do, what are their types, how to choose optimal data types and MySQL character sets for indexes that you use, we went through the benefits and drawbacks of using indexes in MySQL, we told you how to choose the best index to use, how to improve query performance and make sure your indexes are actually… Read more

Indexes in MySQL are a very complex beast. We have covered MySQL indexes in the past, but we have never taken a deeper dive into them – we will do that in these series of blog posts. This blog post should act as a very general guide to indexes while the other parts of these series will dive a little bit deeper into these subjects.  What are Indexes? In general, as already noted in a previous blog post about indexes, an index is an alphabetical list of records with references to the pages on which they are mentioned. In MySQL,… Read more

Percona Backup for MongoDB (PBM) has reached a new step with the release of version 1.5.0 today, May 13th, 2021. Azure Blob Storage Support Now you can use Azure Blob Storage as well as S3-compatible object stores. Configuration example: [crayon-609d16938f370442691684/] Preference Weight for Backup Source Nodes Until now PBM would use a secondary as a […]… Read more

A survey of 200 IT decision-makers from medium to large enterprises was conducted in Q1 of 2021 by Vanson Bourne and sponsored by Percona in advance of Percona Live ONLINE 2021, which started today!  Percona Live Online represents dozens of projects, communities, and tech companies, and features more than 150 expert speakers across 200 sessions. […]… Read more

Percona Live ONLINE 2021 starts today!   Representing dozens of projects, communities, and tech companies, and featuring more than 150 expert speakers across 200 sessions, there’s still time to register and attend.  Register and Attend Percona latest product announcements focus on Percona’s open source DBaaS preview, and new Percona Kubernetes Operators features. During Percona Live ONLINE […]… Read more

Last year I started my lame attempts to apply different Linux dynamic tracing tools and approaches to frequent events like memory allocations. In this blog post I already described how to use perf to add user probe to trace malloc() calls with the number of bytes requested. Unfortunately this approach is not practical for production use for more than several seconds.Recently I plan with bpftrace a lot and so far ended up with an easy way to trace calls and call stacks, and was on my way to trace only outstanding allocations and care only about memory areas not yet… Read more

Good news is that the MariaDB Foundation and members of the MariaDB community are participating in Percona Live Online on the 12th – 13th of May, and we are excited to interact with you there. … Continue reading "MariaDB at Percona Live Online" The post MariaDB at Percona Live Online appeared first on MariaDB.org…. Read more

Running MongoDB in Kubernetes with Percona Operator is not only simple but also by design provides a highly available MongoDB cluster suitable for mission-critical applications. In the latest 1.8.0 version, we add a feature that implements Point-in-time recovery (PITR). It allows users to store Oplog on an external S3 bucket and to perform recovery to […]… Read more

It’s release roundup time again here at Percona! Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download. Today’s […]… Read more

Lessons Learned – Learning from those who blazed the trail! Another cool thing I like about attending conferences is learning from how other companies and people overcame problems, how they run their systems, and figure out problems that I may run into in the future. Secretly I also want to validate how I have done […]… Read more

After upgrading to ClusterControl 1.8.2, you should get the following notification banner: What's up with that? It is a depreciation notice of the current user management system in favor of the new user management system handled by the ClusterControl controller service (cmon). When clicking on the banner, you will be redirected to the user creation page to create a new admin user, as described in this user guide. In this blog post, we are going to look into the new user management system introduced in ClusterControl 1.8.2, and to see how it is different from the previous ones. Just for… Read more

Just last week we had a Galera Cluster for MySQL streaming replication feature deep dive webinar, by the person that implemented it – Seppo Jaakola. In fact, if you haven’t already read the entire story, we encourage you to read: Galera Streaming Replication: Too Big A Bite Can Choke Your Cluster. We also have the […]… Read more

MindsDB is an AutoML framework that lets software engineers do machine learning, without having to go through the whole data science pipeline. Additionally, MindsDB has done a seamless integration with MariaDB, by making use of the Connect Storage Engine. … Continue reading "Webinar: AI in MariaDB with MindsDB" The post Webinar: AI in MariaDB with MindsDB appeared first on MariaDB.org…. Read more