by Michael Coburn | Aug 1, 2018 | Cloud, MongoDB, Monitoring, MySQL, Percona Events, Percona Software
PMM (Percona Monitoring and Management) is a free and open-source platform for managing and monitoring MySQL and MongoDB performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis...
by Vadim Tkachenko | Aug 1, 2018 | Benchmarks, Insight for DBAs, MySQL, Open Source, Storage Engine
The main focus of a previous blog post was the performance of MyRocks when using fast SSD devices. However, I figured that MyRocks would be beneficial for use in cloud workloads, where storage is either slow or expensive. In that earlier post, we demonstrated the...
by Tate McDaniel | Jul 31, 2018 | Cloud, MySQL, Webinars
Please join Autodesk’s Senior DevOps Engineer, Sanjeet Deshpande, Autodesk’s Senior Database Engineer, Vineet Khanna, and Percona’s Sr. MySQL DBA, Tate McDaniel as they present Migrating to AWS Aurora, Monitoring AWS Aurora with PMM on Wednesday, August...
by Peter Zaitsev | Jul 30, 2018 | Insight for DBAs, MySQL, Webinars
Please join Percona’s CEO, Peter Zaitsev as he presents Using MySQL for Distributed Database Architectures on Tuesday, July 31st, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now In modern data architectures, we’re increasingly moving from...
by Dmitriy Kostiuk | Jul 27, 2018 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.4.16-2.14 on July 27, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source, and highly-scalable database...
by Colin Charles | Jul 27, 2018 | MariaDB, MongoDB, MySQL, Storage Engine
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. OSCON happened last week and was incredible. It is true there was less of a database focus, and a lot more topics covered....
by Yves Trudeau | Jul 26, 2018 | Insight for DBAs, MySQL
The choice of good InnoDB primary keys is a critical performance tuning decision. This post will guide you through the steps of choosing the best primary key depending on your workload. As a principal architect at Percona, one of my main duties is to tune customer...
by Adamo Tonete | Jul 24, 2018 | Insight for DBAs, MongoDB, Webinars
Please join Percona’s Senior Support Engineer, Adamo Tonete as he presents MongoDB Sharding 101 – Geo-Partitioning on Thursday, July 26th, 2018 at 12:30 PM PDT (UTC-7) 3:30 EDT (UTC-4). Register Now In this webinar, we will discuss the common shard keys and...
by Dov Endress | Jul 23, 2018 | Insight for DBAs, MySQL, Webinars
Please join Percona Senior MySQL DBA for Managed Services, Dov Endress, as he presents XA Transactions on Wednesday, July 25th, 2018 at 12:00 PM PDT (UTC-7) / 3:00 PM EDT (UTC-4). Register Now Distributed transactions (XA) are becoming more and more vital as...
by Francisco Bordenave | Jul 20, 2018 | Insight for DBAs, Insight for Developers, MySQL
Welcome to the third part of this series. I’m glad you’re still reading, as hopefully this means you find this subject interesting at least. Previously we presented the first two components of MySQL InnoDB Cluster: Group Replication and MySQL Router and...
by Adamo Tonete | Jul 18, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Open Source, Percona Software, Webinars
Please join Percona’s Senior Support Engineer, Adamo Tonete as he presents MongoDB Sharding 101 on July 19th, 2018, at 12:30 PM PDT (UTC-7) / 3:30 PM EDT (UTC-4). Register Now This tutorial is a continuation of advanced topics for the DBA. In it, we will share...
by Colin Charles | Jul 18, 2018 | Insight for DBAs, Insight for Developers, MariaDB, MySQL, Open Source, Webinars
Please join Percona’s Chief Evangelist, Colin Charles as he presents as he presents MariaDB 10.3 vs. MySQL 8.0 on Wednesday, July 18th, 2018, at 9:00 AM PDT (UTC-7) / 12:00 PM EDT (UTC-4). Register Now Technical considerations Are they syntactically similar?...
by Peter Zaitsev | Jul 18, 2018 | Benchmarks, Insight for DBAs, MySQL, Open Source, Percona Software
If you’re reading consumer SSD reviews and using them to estimate SSD performance under database workloads, you’d better stop. Databases are not your typical consumer applications and they do not use IO in the same way. Let’s look, for example, at this excellent...
by Dmitriy Kostiuk | Jul 16, 2018 | Percona Software, ProxySQL
ProxySQL 1.4.9, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL...
by Francisco Bordenave | Jul 16, 2018 | Insight for DBAs, MySQL, Open Source
MySQL InnoDB Cluster is an Oracle High Availability solution that can be easily installed over MySQL to provide high availability with multi-master capabilities and automatic failover. In the previous post we presented the first component of InnoDB Cluster, group...
by Colin Charles | Jul 13, 2018 | MariaDB, MySQL, Percona Live
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Hello again after the hiatus last week. I’m en route to Portland for OSCON, and am very excited as it is the...
by Vadim Tkachenko | Jul 13, 2018 | Benchmarks, MySQL, Percona Software
Recently, Dimitri published the results of measuring MySQL 8.0 on Intel Optane storage device. In this blog post, I wanted to look at this in more detail and explore the performance of MySQL 8, MySQL 5.7 and Percona Server for MySQL using a similar set up. The Intel...
by Alexander Rubin | Jul 12, 2018 | Benchmarks, MySQL
MySQL stored procedures, functions and triggers, are tempting constructs for application developers. However, as I discovered, there can be an impact on database performance when using MySQL stored routines. Not being entirely sure of what I was seeing during a...
by Dmitriy Kostiuk | Jul 11, 2018 | MongoDB, Percona Events, Percona Live, Percona Software
Percona announces the release of Percona Server for MongoDB 3.6.5-1.3 on July 11, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source, and highly-scalable database...
by Vadim Tkachenko | Jul 11, 2018 | Benchmarks, MySQL, Percona Software
Ever since AMD released their EPYC CPU for servers I wanted to test it, but I did not have the opportunity until recently, when Packet.net started offering bare metal servers for a reasonable price. So I started a couple of instances to test Percona Server for MySQL...
