by Vadim Tkachenko | Apr 14, 2020 | MySQL, Percona Software
Percona XtraDB Cluster 8.0 is on the final stretch before GA release, and we have pre-release packages available for testing.I wanted to see how Percona XtraDB Cluster 8.0 performs in CPU and IO-bound scenarios, like in my previous posts about MySQL Group... by Vadim Tkachenko | Apr 10, 2020 | Benchmarks, MySQL
In this post, I want to evaluate Group Replication Scaling capabilities in cases when we increase the number of nodes and increase user connections. While this setup is identical to that in my post “Evaluating Group Replication Scaling Capabilities in... by Vadim Tkachenko | Apr 9, 2020 | Benchmarks, MySQL
In this blog, I want to evaluate Group Replication Scaling capabilities to handle several writers, that is, when the read-write connection is established to multiple nodes, and in this case, two nodes. This setup is identical to my previous post, Evaluating Group... by Vadim Tkachenko | Apr 8, 2020 | Benchmarks, MySQL
In this blog, I want to evaluate Group Replication Scaling capabilities in cases when we increase the number of nodes and increase user connections.For testing, I will deploy multi-node bare metal servers, where each node and client are dedicated to an individual... by Vadim Tkachenko | Apr 3, 2020 | MongoDB, MySQL, Percona Software
We recently released an experimental version of percona-dbaas command-line tool with the goal of significantly simplifying the deployment of database instances in Kubernetes.We have Kubernetes Operators for Percona XtraDB Cluster and Percona Server for MongoDB, which... by Vadim Tkachenko | Mar 31, 2020 | MySQL
Working on a weekend project, I became familiar with the SQL keyword “LATERAL”, which I had not used before because it was only introduced recently in MySQL 8.0.14, so I wanted to share how it can be used.Some references on this topic:Lateral... 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... by Vadim Tkachenko | Feb 3, 2020 | Insight for DBAs, Insight for Developers, MySQL
It’s been a while since I wrote about ClickHouse, there are a lot of new features that are worth mentioning, and for this, I recommend to follow the Altinity Blog but today I want to look at the improved integration of ClickHouse and MySQL.There are two... by Vadim Tkachenko | Jan 23, 2020 | MySQL, Percona Software
From the initial release, one of the biggest complaints I had about Group Replication is that it allowed “stale” reads and there was no way to prevent them or to even know that you read “stale” data. That was a huge limitation. Thankfully,... by Vadim Tkachenko | Jan 17, 2020 | MySQL, Percona Software
Percona Server for MySQL 8.0.18 ships all functionality to run Group Replication and InnoDB Cluster setups, so I decided to evaluate how it works and how it compares with Percona XtraDB Cluster in some situations.For this I planned to use three bare metal nodes, SSD... by Vadim Tkachenko | May 9, 2019 | MySQL, Percona Software
In my previous post Running MySQL/Percona Server in Kubernetes with a Custom Config I’ve looked at how to set up MySQL in Kubernetes to utilize system resources fully. Today I want to measure if there is any performance overhead of running MySQL in Kubernetes,... by Vadim Tkachenko | Apr 3, 2019 | MySQL, Percona Software
As we continue the development of our Percona Operators to simplify database deployment in Kubernetes (Percona Server for MongoDB Operator 0.3.0 and Percona XtraDB Cluster Operator 0.3.0), one very popular question I get is: how does deployment in Kubernetes affect... by Vadim Tkachenko | Feb 25, 2019 | Benchmarks, MySQL
In this post, I want to explore a way to establish 100,000 connections to MySQL. Not just idle connections, but executing queries.100,000 connections. Is that really needed for MySQL, you may ask? Although it may seem excessive, I have seen a lot of different setups... by Vadim Tkachenko | Feb 22, 2019 | Benchmarks, MySQL
Percona Server for MySQL 8.0 comes with enterprise grade total data encryption features. However, there is always the question of how much overhead – or performance penalty – comes with the data decryption. As we saw in my networking performance post, SSL... by Vadim Tkachenko | Feb 21, 2019 | Benchmarks, MySQL
MySQL 8.0.15 performs worse in sysbench oltp_read_write than MySQL 5.7.25Initially I was testing group replication performance and was puzzled why MySQL 8.0.15 performs consistently worse than MySQL 5.7.25.It appears that a single server instance is affected by a... by Vadim Tkachenko | Feb 19, 2019 | Benchmarks, MySQL
Network is a major part of a database infrastructure. However, often performance benchmarks are done on a local machine, where a client and a server are collocated – I am guilty myself. This is done to simplify the setup and to exclude one more variable (the... by Vadim Tkachenko | Feb 7, 2019 | MySQL, Storage Engine
In my webinar How To Rock with MyRocks I briefly mentioned the column families feature in MyRocks, that allows a fine tuning for indexes and primary keys.Let’s review it in more detail.To recap, MyRocks is based on the RocksDB library, which stores all data in... by Vadim Tkachenko | Jan 14, 2019 | Hardware and Storage, Insight for DBAs, Insight for Developers, MySQL, Percona Software, Storage Engine, Webinars
Please join Percona’s Chief Technology Officer, Vadim Tkachenko, as he presents How to Rock with MyRocks on Thursday, January 17th at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). View the Recording MyRocks is a new storage engine from Facebook and is available in... by Vadim Tkachenko | Oct 31, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Percona Software
Percona announces the planned release of Percona Server for MongoDB 4.0, the latest version of the company’s free, enhanced, drop-in replacement for MongoDB Community Edition. Percona Server for MongoDB 4.0 includes all the features of MongoDB Community... by Vadim Tkachenko | Oct 24, 2018 | MongoDB
As you may have heard, MongoDB recently changed the license for MongoDB Community version from AGPL to SSPL. In order to better serve our users and customers, we’d like to ask about your plans.Please select the answer that best describes your current thinking as...