Percona Monitoring and Management (PMM) 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 for MySQL® and MongoDB® servers to ensure that your data works as efficiently as possible. This release offers two new features for both the MySQL Community and Percona Customers: [&]

https://www.percona.com/blog/2018/10/10/percona-monitoring-and-management-pmm-1-15-0-is-now-available/

Probably not well known but quite an important optimization was introduced in MySQL 5.6 – reduced overhead for “read only transactions”. While usually by a “transaction” we mean a query or a group of queries that change data, with transaction engines like InnoDB, every data read or write operation is a transaction. Now, as a [&]

https://www.percona.com/blog/2018/10/10/instrumenting-read-only-transactions-in-innodb/

Probably not well known but quite an important optimization was introduced in MySQL 5.6 – reduced overhead for “read only transactions”. While usually by a “transaction” we mean a query or a group of queries that change data, with transaction engines like InnoDB, every data read or write operation is a transaction. Now, as a [&]

The post Instrumenting Read Only Transactions in InnoDB appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/10/instrumenting-read-only-transactions-in-innodb/

The MongoDB® replica set is a group of nodes with one set as the primary node, and all other nodes set as secondary nodes. Only the primary node accepts “write” operations, while other nodes can only serve “read” operations according to the read preferences defined. In this blog post, well focus on some MongoDB replica set scenarios, and [&]

The post MongoDB Replica set Scenarios and Internals appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/10/mongodb-replica-set-scenarios-and-internals/

The MongoDB® replica set is a group of nodes with one set as the primary node, and all other nodes set as secondary nodes. Only the primary node accepts “write” operations, while other nodes can only serve “read” operations according to the read preferences defined. In this blog post, well focus on some MongoDB replica set scenarios, and [&]

https://www.percona.com/blog/2018/10/10/mongodb-replica-set-scenarios-and-internals/

This is the last post in our series on building an enterprise-grade PostgreSQL set up using open source tools, and well be covering monitoring. The previous posts in this series discussed aspects such as security, backup strategy, high availability, connection pooling and load balancing, extensions, and detailed logging in PostgreSQL. Tomorrow, Wednesday, October 10 at 10AM EST, [&]

The post PostgreSQL Monitoring: Set Up an Enterprise-Grade Server (and Sign Up for Webinar Weds 10/10&) appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/09/postgresql-monitoring-set-up-an-enterprise-grade-server-and-sign-up-for-webinar-weds-10-10/

This is the last post in our series on building an enterprise-grade PostgreSQL set up using open source tools, and well be covering monitoring. The previous posts in this series discussed aspects such as security, backup strategy, high availability, connection pooling and load balancing, extensions, and detailed logging in PostgreSQL. Tomorrow, Wednesday, October 10 at 10AM EST, [&]

https://www.percona.com/blog/2018/10/09/postgresql-monitoring-set-up-an-enterprise-grade-server-and-sign-up-for-webinar-weds-10-10/

Please join Percona’s Product Manager for Percona Server for MongoDB, Jeff Sandstrom; Sr. Tech Ops Architect for MongoDB, Tim Vaillancourt; and Mesosphere’s Senior Director of Community and Evangelism, Matt Jarvis, on Thursday, October 11, 2018 at 10:00 AM PDT (UTC–7) / 1:00 PM EDT (UTC–4), as they demonstrate how to build highly scalable Internet of [&]

https://www.percona.com/blog/2018/10/09/highly-scalable-iot-architectures/

Please join Percona’s Product Manager for Percona Server for MongoDB, Jeff Sandstrom; Sr. Tech Ops Architect for MongoDB, Tim Vaillancourt; and Mesosphere’s Senior Director of Community and Evangelism, Matt Jarvis, on Thursday, October 11, 2018 at 10:00 AM PDT (UTC–7) / 1:00 PM EDT (UTC–4), as they demonstrate how to build highly scalable Internet of [&]

The post Upcoming Webinar Thurs 10/11: Build Highly Scalable IoT Architectures with Percona Server for MongoDB appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/09/highly-scalable-iot-architectures/

The second alpha build of Percona XtraBackup 8.0.2 is now available in the Percona experimental software repositories. Note that, due to the new MySQL redo log and data dictionary formats, the Percona XtraBackup 8.0.x versions will only be compatible with MySQL 8.0.x and Percona Server for MySQL 8.0.x. This release supports backing up Percona Server [&]

The post Announcement: Second Alpha Build of Percona XtraBackup 8.0 Is Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/09/announcement-second-alpha-build-of-percona-xtrabackup-8-0-is-available/

The second alpha build of Percona XtraBackup 8.0.2 is now available in the Percona experimental software repositories. Note that, due to the new MySQL redo log and data dictionary formats, the Percona XtraBackup 8.0.x versions will only be compatible with MySQL 8.0.x and Percona Server for MySQL 8.0.x. This release supports backing up Percona Server [&]

https://www.percona.com/blog/2018/10/09/announcement-second-alpha-build-of-percona-xtrabackup-8-0-is-available/

The release of MySQL 8.0 has brought a lot of bold implementations that touched on things that have been avoided before, such as added support for common table expressions and window functions. Another example is the change in how AUTO_INCREMENT (autoinc) sequences are persisted, and thus replicated. This new implementation carries the fix for bug [&]

The post Persistence of autoinc fixed in MySQL 8.0 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/08/persistence-of-autoinc-fixed-in-mysql-8-0/

The release of MySQL 8.0 has brought a lot of bold implementations that touched on things that have been avoided before, such as added support for common table expressions and window functions. Another example is the change in how AUTO_INCREMENT (autoinc) sequences are persisted, and thus replicated. This new implementation carries the fix for bug [&]

The post Persistence of autoinc fixed in MySQL 8.0 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/08/persistence-of-autoinc-fixed-in-mysql-8-0/

In this penultimate post from our series on building an enterprise-grade PostgreSQL environment we cover the parameters we have enabled to configure detailed logging in the demo setup we will showcase in our upcoming webinar. Detailed logging in PostgreSQL and log analyzer Like other RDBMS, PostgreSQL allows you to maintain a log of activities and error [&]

The post Detailed Logging for Enterprise-Grade PostreSQL appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/08/detailed-logging-for-enterprise-grade-postresql/

In this penultimate post from our series on building an enterprise-grade PostgreSQL environment we cover the parameters we have enabled to configure detailed logging in the demo setup we will showcase in our upcoming webinar. Detailed logging in PostgreSQL and log analyzer Like other RDBMS, PostgreSQL allows you to maintain a log of activities and error [&]

The post Detailed Logging for Enterprise-Grade PostreSQL appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/08/detailed-logging-for-enterprise-grade-postresql/

In this current series of blog posts we have been discussing various relevant aspects when building an enterprise-grade PostgreSQL setup, such as security, back up strategy, high availability, and different methods to scale PostgreSQL. In this blog post, well get to review some of the most popular open source extensions for PostgreSQL, used to expand [&]

The post PostgreSQL Extensions for an Enterprise-Grade System appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/05/postgresql-extensions-for-an-enterprise-grade-system/

In this current series of blog posts we have been discussing various relevant aspects when building an enterprise-grade PostgreSQL setup, such as security, back up strategy, high availability, and different methods to scale PostgreSQL. In this blog post, well get to review some of the most popular open source extensions for PostgreSQL, used to expand [&]

The post PostgreSQL Extensions for an Enterprise-Grade System appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/05/postgresql-extensions-for-an-enterprise-grade-system/

In this blog post, we will learn what MongoDB chained replication is, why you might choose to disable it, and the steps you need to take to do so. What is chain replication? Chain Replication in MongoDB, as the name suggests, means that a secondary member is able to replicate from another secondary member instead [&]

The post MongoDB-Disable Chained Replication appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/05/mongodb-disable-chained-replication/

In this blog post, we will learn what MongoDB chained replication is, why you might choose to disable it, and the steps you need to take to do so. What is chain replication? Chain Replication in MongoDB, as the name suggests, means that a secondary member is able to replicate from another secondary member instead [&]

The post MongoDB-Disable Chained Replication appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/05/mongodb-disable-chained-replication/

When deciding on your backup strategy, one of the key components for Point In Time Recovery (PITR) will be the binary logs. Thankfully, the mysqlbinlog command allows you to easily take binary log backups, including those that would otherwise be encrypted on disk using encrypt_binlog=ON. When [crayon-5bbe4e3a03770277735682-i/]  is used with [crayon-5bbe4e3a0377a788388861-i/]  then it will retrieve binary logs [&]

The post The Importance of mysqlbinlog version appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/04/the-importance-of-mysqlbinlog-version/