by Peter Zaitsev | Apr 3, 2020 | Database Trends, Insight for DBAs, MySQL
This is a three-part blog series. Part two is located here, and part three can be found here. There was no reason to plan for it, but the load on your system increased 100%, 300%, 500%, and your MySQL database has to support it. This is a reality many online systems...
by Brian Sumpter | Apr 1, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
While there is no magic bullet for MySQL 5.7 database tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. While much information has been published on this topic over the years, I...
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 Fernando Laudares Camargos | Mar 25, 2020 | Insight for DBAs, Percona Software, PostgreSQL
We recently helped migrate a production PostgreSQL database running on a given DBaaS platform… to another DBaaS platform. When it comes to vendor “lock-in”, some providers are easier (and even friendlier) to deal with than others, but it is never a...
by Rachel Pescador | Mar 24, 2020 | Cloud, Database Trends, Insight for DBAs, Percona Services
Over the past ten years, those in charge of running enterprise databases saw their focus shift from simply ensuring access and availability to overseeing architecture, design, and scalability. Site reliability engineers (SREs) and/or DBAs suddenly found themselves...
by Jake Davis | Mar 23, 2020 | Insight for DBAs, ProxySQL
Recently, a client of ours, Duolingo, was using Aurora was reaching the max connection limit of 16,000 (that is Aurora’s hard limit for all instance classes). In this case, Percona recommended implementing ProxySQL to manage connections (now their max connections only...
by Akira Kurogane | Mar 11, 2020 | Hardware and Storage, Insight for DBAs, Storage Engine
Abstract: Storage engine algorithmic gains have mostly settled and Moore’s law for CPU speed is bottoming out, but database performance still stands to increase ~10x thanks to continuing NAND Flash improvement, Optane, Flash-idiomatic SSD drives (e.g....
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 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 Jobin Augustine | Feb 13, 2020 | Insight for DBAs, PostgreSQL
As hardware and software evolve, the bottlenecks in a database system also shift. Many old problems might disappear and new types of problems pop-up. Old Limitations There were days when CPU and Memory was a limitation. More than a decade back, servers with 4 cores...
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 Brian Sumpter | Dec 19, 2019 | Cloud, Insight for DBAs, MySQL
As the world’s most popular open-source database, MySQL has been around the block more than a few times. Traditionally installed in on-premise data centers, recent years have shown a major trend for MySQL in the cloud, and near the top of this list is Amazon RDS....
by Michael Patrick | Oct 7, 2019 | Insight for DBAs
As a Technical Account Manager (TAM), I have seen many of our clients adopt a decentralized DBA Team. In many cases, this is an effort to better align the DBA Team with the Development Teams. This is an admirable and logical goal. As often happens, you often trade...
