by Carlos Tutte | Mar 26, 2020 | Insight for DBAs, MySQL, Percona Software
Disclaimer: The following blog post does not try to provide a solution for split-brain situations, and the example provided is for demonstrative purposes only. Inconsistencies resulting from a split-brain scenario might possibly be more complex than the one shown, so...
by Marco Tusa | Mar 26, 2020 | Benchmarks, MySQL, Open Source
What You May Not Know About Random Number Generation in Sysbench Sysbench is a well known and largely used tool to perform benchmarking. Originally written by Peter Zaitsev in early 2000, it has become a de facto standard when performing testing and benchmarking....
by Peter Zaitsev | Mar 25, 2020 | Monitoring, MySQL, Percona Software
Last week I did a webinar on MySQL Troubleshooting and Performance Optimization with Percona Monitoring And Management v2 (PMM2). There was a tremendous amount of interest and many more questions than I could answer, so I’m answering them in this blog post instead. Q:...
by Borys Belinsky | Mar 19, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
Percona is happy to announce the experimental release of Percona XtraDB Cluster 8.0. This is a major step for tuning Percona XtraDB Cluster to be more cloud- and user-friendly. This is the second experimental release that combines the updated and feature-rich Galera...
by Tyler Duzan | Mar 18, 2020 | Insight for DBAs, MongoDB, MySQL, Percona Software
Percona has been investing in building and releasing Operators for Kubernetes to run traditional databases in a cloud-native fashion. The first two Kubernetes operators were for Percona Server for MongoDB and Percona XtraDB Cluster, chosen because they both feature...
by David Quilty | Mar 9, 2020 | MySQL, Webinars
In this talk, we’ll walk through RocksDB technology and look into situations where MyRocks is a good fit versus other engines such as InnoDB. We will go over internals, benchmarks, and the tuning of MyRocks engine. We will also explore the benefits of using...
by Ceri Williams | Mar 6, 2020 | MySQL, Open Source, ProxySQL
In the MySQL ecosystem, orchestrator is the most popular and well-respected high availability and topology management tool, integrating well with other solutions such as ProxySQL. It facilitates automatic (or manual) discovery, refactoring and recovery of a replicated...
by Peter Zaitsev | Mar 4, 2020 | Insight for DBAs, MySQL
If you’re a MySQL user trying ClickHouse, one thing which is likely to surprise – and annoy you – is the handling of Double Quotes. In MySQL, you can use both double quotes and single quotes to quote strings, and as an example, these two queries are...
by David Quilty | Mar 4, 2020 | Monitoring, MySQL, Percona Software, Webinars
As a MySQL DBA, the databases powering your applications need to handle changing traffic workloads while remaining responsive and stable so you can deliver an excellent user experience. Optimizing MySQL performance and troubleshooting MySQL problems cost-efficiently...
by Peter Zaitsev | Feb 28, 2020 | Monitoring, MySQL, Percona Software
There are a lot of things I love about Prometheus; its data model is fantastic for monitoring applications and PromQL language is often more expressive than SQL for data retrieval needs you have in the observability space. One thing, though, I hate about Prometheus...
by Peter Zaitsev | Feb 25, 2020 | MySQL, Storage Engine
Sometimes, you may experience “ERROR 1034: Incorrect key file” while running the ALTER TABLE or CREATE INDEX command: Shell mysql> alter table ontime add key(FlightDate); ERROR 1034 (HY000): Incorrect key file for table 'ontime'; try to repair it 12 mysql> alter...
by Alkin Tezuysal | Feb 20, 2020 | Insight for DBAs, MariaDB, MySQL, Storage Engine
In this blog post, we will share some experiences with the hidden gem in MySQL called MyRocks, a storage engine for MySQL’s famous pluggable storage engine system. MyRocks is based on RocksDB which is a fork of LevelDB. In short, it’s another key-value store based on...
by Robert Golebiowski | Feb 19, 2020 | MySQL, Percona Software, Security
In the last blog post of this series, we discussed in detail how Master Key encryption works. In this post, based on what we already know about Master Key encryption, we look into how Master Key rotation works. The idea behind Master Key rotation is that we want to...
by David Quilty | Feb 19, 2020 | Insight for Developers, MySQL, Percona Software, Webinars
This talk covers some of the challenges we sought to address by creating a Kubernetes Operator for Percona XtraDB Cluster, as well as a look into the current state of the Operator, a brief demonstration of its capabilities, and a preview of the roadmap for the...
by Ivan Groenewold | Feb 17, 2020 | MySQL, Open Source
by Corrado Pandiani | Feb 13, 2020 | Insight for DBAs, MySQL, Percona Software
This is the second part of a two-articles series. In the first part, we introduced the Common Table Expression (CTE), a new feature available on MySQL 8.0 as well as Percona Server for MySQL 8.0. In this article, we’ll present the Recursive Common Table...
by Corrado Pandiani | Feb 10, 2020 | Insight for DBAs, MySQL, Percona Software
This blog is the first part of a two-articles series. In this article, I’m going to introduce the Common Table Expression (CTE), a new feature available on MySQL 8.0, as well as Percona Server for MySQL 8. What is a Common Table Expression? We can define a CTE...
by Vadim Tkachenko | Feb 7, 2020 | Cloud, MySQL, Percona Software
As our Percona Kubernetes Operator for Percona XtraDB Cluster gains in popularity, I am getting questions about its performance and how to measure it properly. Sysbench is the most popular tool for database performance evaluation, so let’s review how we can use it...
by David Quilty | Feb 7, 2020 | Insight for Developers, MongoDB, MySQL, PostgreSQL, Webinars
Most applications use databases, yet many fail to follow even the most basic best practices, resulting in poor performance, downtime, and security incidents. In this presentation, we will look into the foundational best practices you as a Developer should know about...
by Peter Zaitsev | Feb 5, 2020 | Insight for Developers, MariaDB, MySQL
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source, production-ready, and enterprise-grade MySQL alternative. Learn More I did a MariaDB Observability talk at MariaDB Day in Brussels, which I roughly based on the...
