Planet MariaDB

In a previous post, Using DBdeployer to manage MySQL, Percona Server, and MariaDB sandboxes, we covered how we use DBdeployer within the Support Team to easily create MySQL environments for testing purposes. Here, I will expand on what Peter wrote in Installing MySQL with Docker, to create environments with more than one node. In particular, […]… Read more

The much anticipated release of Galera Cluster 4 for MySQL 8 is now Generally Available. Please join Codership, the developers of Galera Cluster, and learn how we improve MySQL High Availability with the new features in Galera Cluster 4, and how you can benefit from using them. We will also give you an idea of […]… Read more

I haven’t been writing a lot of content lately. This is in part me being involved in several videos which have taken up the time I would normally use for blogging. I figured I would link to these in a single blog post. Communities, Lockdown and Burnout In early May I had a short interview … Continue reading LinuxJedi’s Recent Videos… Read more

MySQL backups can be made in several ways. Each method has pro’s and con’s. The post MySQL backup methods comparison appeared first on Federico Razzoli…. Read more

MySQL, arguably the most popular relational database, is used pretty extensively at the popular professional social network LinkedIn. At Percona Live ONLINE 2020, the company’s flagship event held online for the first time due to the Covid-19 pandemic, Karthik Appigatla from LinkedIN’s database SRE team discussed the company’s approach to securing their database deployment without […] The post Percona Live ONLINE Talk: Enhancing MySQL security at LinkedIn by Karthik Appigatla appeared first on Percona Community Blog…. Read more

There are many things to write about MySQL this week. It turned 25 years old, to begin with! Quite successful the first ever Percona Live ONLINE 24 hour conference also happened this week, and I’ve presented my talk there…But this is a blog of former MySQL Entomologist, so when I have nothing ready to share about something exciting or immediately useful, I write about MySQL bugs. This is the case today as well. I need more time to think about MySQL history and write down the details to complement my presentation etc. Previous post in this series appeared a month… Read more

Join Peter Zaitsev, CEO at Percona, as he discusses eBFT. eBPF is one of the most powerful instrumentation frameworks in modern Linux Kernel. In this presentation, we will cover eBPF basics as well as usage of Interactive eBPF tools, showing practical examples when and how they can help to resolve performance problems. Finally, we will […]… Read more

Long months of the pandemic lockdown have brought to life many great online events enabling the MySQL community to get together and stay informed about the very recent developments and innovations available to MySQL users. It isn’t over yet! Next Thursday, June 4th, Percona & ProxySQL are co-hosting the ProxySQL Tech Talks with Percona virtual […] The post Join ProxySQL Tech Talks with Percona on June 4th, 2020! appeared first on Percona Community Blog…. Read more

Aria is a MariaDB storage engine that is always used internally. Its pagecache is the equivalent of InnoDB buffer pool, and this article is about sizing it properly. The post Sizing Aria Pagecache appeared first on Federico Razzoli…. Read more

Open-source companies live by their community. Favorable buzz by community users is ultimately what’s made Percona software successful. Some users make further contributions in the form of expertise, source code, documentation, and more. As an open-source company in business for over 14 years, Percona welcomes contributions from our user community. Here’s how you can start […]… Read more

Choosing Backup and DR Strategies for your MariaDB Infrastructure Backup in simple terms is just copying data and retaining the same in persistent storage ( in logical / SQL or binary format ) to recover […] The post Choosing Backup and DR Strategies for your MariaDB Infrastructure appeared first on The WebScale Database Infrastructure Operations Experts…. Read more

Here in Percona’s Training department, we like to think that we instruct our learners on the best practices for all things MySQL-related. In addition to performance tuning, query optimization, and replication configurations, another important topic is backups. Let’s dive in and discuss some of the basics and best practices around backups for MySQL. Logical MySQL […]… Read more

Managing global counters in a multi-threaded system has always been challenging. They pose serious scalability challenges. Introduction of NUMA just increased the complexity. Fortunately multiple options have been discovered with hardware lending support to help solve/ease some of these issues. In this blog we will go over how we can make Global Counter NUMA SMART and also see what performance impact each of this approach has…. Read more

Earlier today I presented orchestrator on DB AMA. Thank you to the organizers Morgan Tocker, Liz van Dijk and Frédéric Descamps for hosting me, and thank you to all who participated! This was a no-slides, all command-line walkthrough of some of orchestrator‘s capabilities, highlighting refactoring, topology analysis, takeovers and failovers, and discussing a bit of […]… Read more

Join Alkin Tezusal, Percona Technical Expert, as he covers the past, present, and future of MySQL as an Open Source Database. During this webinar he will discuss: * Use cases of MySQL as well as edge cases of MySQL topologies using real-life examples and “war” stories * How scalability and proxy wars make MySQL topologies […]… Read more