by Vadim Tkachenko | Nov 5, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
In my talk on Percona Live (download the presentation), I spoke about how we can use Percona Kubernetes Operators to deploy our own Database-as-Service, based on fully OpenSource components and independent from any particular cloud provider.Today I want to mention an... by Vadim Tkachenko | Oct 22, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
One of the most exciting storage-related features in Kubernetes is Volume snapshot and clone. It allows you to take a snapshot of data volume and later to clone into a new volume, which opens a variety of possibilities like instant backups or testing upgrades. This... by Vadim Tkachenko | Oct 1, 2020 | Hardware and Storage, MongoDB, MySQL, Percona Software
Network volumes in Kubernetes provide great flexibility, but still, nothing beats local volumes from direct-attached storage in the sense of database performance.I want to explore ways to deploy both Percona Kubernetes Operators (Percona Kubernetes Operator for... by Vadim Tkachenko | Sep 16, 2020 | Benchmarks, Insight for DBAs, MongoDB
There is a special collection of database bugs when the system starts to perform worse when given more resources. Examples of such bugs for MySQL I have:Bug #15815 – This is where InnoDB on an 8-CPU system performed worse than on a 4-CPU system with increased... by Vadim Tkachenko | Sep 15, 2020 | Benchmarks, Insight for DBAs, MongoDB
Following my previous blogs on py-tpcc benchmark for MongoDB, Evaluating the Python TPCC MongoDB Benchmark and Evaluating MongoDB Under Python TPCC 1000W Workload, and the recent release of Percona Server for MongoDB 4.4, I wanted to evaluate 4.2 vs 4.4... by Vadim Tkachenko | Aug 27, 2020 | Benchmarks, Insight for DBAs, MySQL
Recently I posted about checkpointing in MySQL, where MySQL showed interesting “wave” behavior.Soon after Dimitri posted a solution with how to fix “waves,” and I would like to dig a little more into proposed suggestions, as there are some... by Vadim Tkachenko | Aug 14, 2020 | Benchmarks, 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 Recently, I published a series of posts on MySQL and MariaDB, where MariaDB 10.5.4 does not... by Vadim Tkachenko | Aug 14, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
Part one of this series can be found here: How Many innodb_buffer_pool_instances Do You Need in MySQL 8?Following up on my recent benchmark posts on MySQL and MariaDB, MySQL and MariaDB on Enterprise SSD Storage and How MySQL and MariaDB Perform on NVMe Storage, I... by Vadim Tkachenko | Aug 13, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
Following up on my recent benchmark posts on MySQL and MariaDB, MySQL and MariaDB on Enterprise SSD Storage and How MySQL and MariaDB Perform on NVMe Storage, I wanted to dig a little deeper and understand how different MySQL parameters affect performance.One of the... by Vadim Tkachenko | Jul 31, 2020 | Benchmarks, 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 Continuing with the same topic and evaluating new versions of MariaDB and MySQL on Enterprise SSD... by Vadim Tkachenko | Jul 30, 2020 | Benchmarks, 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 MySQL and MariaDB on NVMe Storage – The Great Equalizer Continuing with the... by Vadim Tkachenko | Jul 29, 2020 | Benchmarks, MariaDB, MySQL
Continuing with the checkpointing topic I restarted a month ago with MongoDB and followed with PostgreSQL, I wanted to check how MySQL and MariaDB perform.It was actually some time when I last looked into MySQL in this regard, so I am curious how new MySQL versions... by Vadim Tkachenko | Jul 28, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, PostgreSQL
Continuing with the checkpointing topic I started a month ago with my blog post MongoDB Checkpointing Woes, this time I want to review how PostgreSQL performs in this area. After this, I will be taking a look at MySQL and MariaDB. If anything, it will be fair not only... by Vadim Tkachenko | Jul 27, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, MariaDB, MySQL
There were two new releases in the OpenSource Analytical Databases space, which made me want to evaluate how they perform in the Star Schema Benchmark.I covered Star Schema Benchmarks a few times before: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB... by Vadim Tkachenko | Jun 25, 2020 | Benchmarks, Insight for DBAs, MongoDB, Percona Software
In my recent post Evaluating MongoDB Under Python TPCC 1000W Workload with MongoDB benchmarks, I showed an average throughput for a prolonged period of time (900sec or 1800sec), and the average throughput tended to smooth and hide problems.But if we zoom in to 1-sec... by Vadim Tkachenko | Jun 24, 2020 | Benchmarks, Insight for DBAs, MongoDB, Percona Software
Following my blog post Evaluating the Python TPCC MongoDB Benchmark, I wanted to evaluate how MongoDB performs under workload with a bigger dataset. This time I will load a 1000 Warehouses dataset, which in raw format should equal to 100GB of data.For the comparison,... by Vadim Tkachenko | Jun 15, 2020 | Benchmarks, MongoDB, Percona Software
I was looking for a tool that could evaluate MongoDB performance under a complex workload, besides simple key-value operations that benchmarks like YCSB provides.That’s why the paper “Adapting TPC-C Benchmark to Measure Performance of Multi-Document... by Vadim Tkachenko | Jun 8, 2020 | Cloud, MongoDB, Percona Software
Unless you are using Amazon Aurora or RDS, setting up clustering software still can be complicated and that’s why we want to offer options to simplify database cluster management in Amazon AWS. This time I will be looking at Percona Kubernetes Operators, for... by Vadim Tkachenko | May 15, 2020 | MySQL, Percona Software
Percona XtraDB Cluster 8.0 comes with an upgraded Galera 4.0 library, which provides a new feature – streaming replication. Let’s review what it is and when it might be helpful.Previous versions of Percona XtraDB Cluster with Galera 3.x had a limitation in... by Vadim Tkachenko | Apr 16, 2020 | MySQL, Percona Software
Percona XtraDB Cluster 8.0 is in the final stretch before GA release and we have pre-release packages available for testing, and 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...