Insight for DBAs

Help Drive the Future of Percona XtraDB Cluster

Percona XtraDB Cluster

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 4, with substantial improvements made by our development team.
Improvements and New Features […]

Read more

How Container Networking Affects Database Performance

How Container Networking Affects Database Performance

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 replication systems that can be made to work effectively in a containerized world.
One of the […]

Read more

DBA Concerns About Next-Gen, Non-Volatile Memory Storage Products

DBA Concerns Memory Storage

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. OpenChannel, Zoned Namespaces), KeyValue SSD, etc. The downside is each storage engine revolution historically has broken encapsulation/reuse and […]

Read more

ClickHouse Versus MySQL Handling of Double Quotes

ClickHouse MySQL Double Quotes

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 equivalent:

Shell

mysql> select * from performance_schema.global_variables where variable_name=’max_connections’;
+—————–+—————-+
| […]

Read more

A Hidden Gem in MySQL: MyRocks

using MyRocks in MySQL

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 LSM-tree, thus granting it some distinctive features compared […]

Read more