In this blog post, well look at why we deprecated MongoRocks in Percona Server for MongoDB 3.6, and provide some guidance on switching from MongoRocks to WiredTiger. On April 24, 2018, Percona announced the availability of Percona Server for MongoDB 3.6. If you read the blog post announcing the release, you probably saw the following [&]

The post Why We’ve Deprecated MongoRocks in Percona Server for MongoDB 3.6 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/10/why-weve-deprecated-mongorocks-in-percona-server-for-mongodb-3-6/

In this blog post, well look at why we deprecated MongoRocks in Percona Server for MongoDB 3.6, and provide some guidance on switching from MongoRocks to WiredTiger. On April 24, 2018, Percona announced the availability of Percona Server for MongoDB 3.6. If you read the blog post announcing the release, you probably saw the following [&]

The post Why We’ve Deprecated MongoRocks in Percona Server for MongoDB 3.6 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/10/why-weve-deprecated-mongorocks-in-percona-server-for-mongodb-3-6/

In this blog post, well look at why we deprecated MongoRocks in Percona Server for MongoDB 3.6, and provide some guidance on switching from MongoRocks to WiredTiger. On April 24, 2018, Percona announced the availability of Percona Server for MongoDB 3.6. If you read the blog post announcing the release, you probably saw the following [&]

The post Why We’ve Deprecated MongoRocks in Percona Server for MongoDB 3.6 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/10/why-weve-deprecated-mongorocks-in-percona-server-for-mongodb-3-6/

Yes, it does! In this blog post, I am going to share my recent experiences with ProxySQL and how important the database software version number can be. Migration I was working on a migration to Percona XtraDB Cluster (PXC) with ProxySQL, fortunately on a staging environment first so we could catch any issues (like this one). We [&]

The post Does the Version Number Matter? appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/09/does-the-version-number-matter/

In this blog, I will show you how to install PMM on Linode as a low-cost database monitoring solution. Many of my friends use Linode to run their personal sites, as well as small projects. While Linode is no match for Big Cloud providers in features, it is really wonderful when it comes to cost [&]

The post Deploying PMM on Linode: Your $5-Per-Month Monitoring Solution appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/08/deploying-pmm-at-linode-your-5-per-month-monitoring-solution/

In this blog, I will show you how to install PMM on Linode as a low-cost database monitoring solution. Many of my friends use Linode to run their personal sites, as well as small projects. While Linode is no match for Big Cloud providers in features, it is really wonderful when it comes to cost [&]

The post Deploying PMM on Linode: Your $5-Per-Month Monitoring Solution appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/08/deploying-pmm-at-linode-your-5-per-month-monitoring-solution/

It’s easy to enable Amazon RDS remote access when launching an Amazon RDS instance, but there can be many issues. I created this blog as a guide describing the various issues/configurations we might encounter. As the first step, we need to select a VPC where we will launch our Amazon RDS instance. The default VPC [&]

The post How to Enable Amazon RDS Remote Access appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/08/how-to-enable-amazon-rds-remote-access/

It’s easy to enable Amazon RDS remote access when launching an Amazon RDS instance, but there can be many issues. I created this blog as a guide describing the various issues/configurations we might encounter. As the first step, we need to select a VPC where we will launch our Amazon RDS instance. The default VPC [&]

The post How to Enable Amazon RDS Remote Access appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/08/how-to-enable-amazon-rds-remote-access/

Please join Percona’s CEO, Peter Zaitsev as he presents MySQL Troubleshooting and Performance Optimization with PMM on Wednesday, May 9, 2018, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBAs. The databases powering your applications [&]

The post Webinar Wednesday, May 9, 2018: MySQL Troubleshooting and Performance Optimization with Percona Monitoring and Management (PMM) appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/07/webinar-mysql-troubleshooting-performance-optimization-percona-monitoring-and-management/

Please join Percona’s CEO, Peter Zaitsev as he presents MySQL Troubleshooting and Performance Optimization with PMM on Wednesday, May 9, 2018, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBAs. The databases powering your applications [&]

The post Webinar Wednesday, May 9, 2018: MySQL Troubleshooting and Performance Optimization with Percona Monitoring and Management (PMM) appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/07/webinar-mysql-troubleshooting-performance-optimization-percona-monitoring-and-management/

Please join Percona’s CEO, Peter Zaitsev as he presents MySQL Troubleshooting and Performance Optimization with PMM on Wednesday, May 9, 2018, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBAs. The databases powering your applications [&]

The post Webinar Wednesday, May 9, 2018: MySQL Troubleshooting and Performance Optimization with Percona Monitoring and Management (PMM) appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/07/webinar-mysql-troubleshooting-performance-optimization-percona-monitoring-and-management/

Please join Percona’s CEO, Peter Zaitsev as he presents MySQL Troubleshooting and Performance Optimization with PMM on Wednesday, May 9, 2018, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBAs. The databases powering your applications [&]

The post Webinar Wednesday, May 9, 2018: MySQL Troubleshooting and Performance Optimization with Percona Monitoring and Management (PMM) appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/07/webinar-mysql-troubleshooting-performance-optimization-percona-monitoring-and-management/

As part of my benchmarks of binary logs, I’ve decided to check how the recently released MySQL 8.0 performance is affected in similar scenarios, especially as binary logs are enabled by default. It is also interesting to check how MySQL 8.0 performs against the claimed performance improvements in redo logs subsystem. I will use a [&]

The post How Binary Logs Affect MySQL 8.0 Performance appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/04/how-binary-logs-affect-mysql-8-0-performance/

As part of my benchmarks of binary logs, I’ve decided to check how the recently released MySQL 8.0 performance is affected in similar scenarios, especially as binary logs are enabled by default. It is also interesting to check how MySQL 8.0 performs against the claimed performance improvements in redo logs subsystem. I will use a [&]

The post How Binary Logs Affect MySQL 8.0 Performance appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/04/how-binary-logs-affect-mysql-8-0-performance/

As part of my benchmarks of binary logs, I’ve decided to check how the recently released MySQL 8.0 performance is affected in similar scenarios, especially as binary logs are enabled by default. It is also interesting to check how MySQL 8.0 performs against the claimed performance improvements in redo logs subsystem. I will use a [&]

The post How Binary Logs Affect MySQL 8.0 Performance appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/04/how-binary-logs-affect-mysql-8-0-performance/

I want to take a closer look at MySQL performance with binary logs enabled on different filesystems, especially as MySQL 8.0 comes with binary logs enabled by default. As part of my benchmarks of the MyRocks storage engine, I’ve noticed an unusual variance in throughput for the InnoDB storage engine, even though we spent a [&]

The post How Binary Logs (and Filesystems) Affect MySQL Performance appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/04/how-binary-logs-and-filesystems-affect-mysql-performance/

I want to take a closer look at MySQL performance with binary logs enabled on different filesystems, especially as MySQL 8.0 comes with binary logs enabled by default. As part of my benchmarks of the MyRocks storage engine, I’ve noticed an unusual variance in throughput for the InnoDB storage engine, even though we spent a [&]

The post How Binary Logs (and Filesystems) Affect MySQL Performance appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/04/how-binary-logs-and-filesystems-affect-mysql-performance/

I want to take a closer look at MySQL performance with binary logs enabled on different filesystems, especially as MySQL 8.0 comes with binary logs enabled by default. As part of my benchmarks of the MyRocks storage engine, I’ve noticed an unusual variance in throughput for the InnoDB storage engine, even though we spent a [&]

The post How Binary Logs (and Filesystems) Affect MySQL Performance appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/04/how-binary-logs-and-filesystems-affect-mysql-performance/

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. The week after Percona Live Santa Clara 2018 tends to be much quieter, aided by the fact that I took a few days away during Labor Day. The next thing to look out for is [&]

The post This Week in Data with Colin Charles 38: Percona Live Europe 2018 and PostgreSQL appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/04/this-week-in-data-with-colin-charles-38/

So, after a whirlwind few days, Percona Live 2018 has been and gone. There was a great energy about the conference, and it was fantastic to meet so many open source database enthusiasts and supporters. A few things that I experienced: Your great willingness to share knowledge. It was a fantastic place to learn for [&]

The post Percona Live 2018 Community Report appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/04/percona-live-2018-community-report/