Announcing the opening of the Percona Live Europe Open Source Database Conference 2018 in Frankfurt, Germany call for papers. It will be open from now until August 10, 2018. Our theme this year is Connect. Accelerate. Innovate. As a speaker at Percona Live Europe, you’ll have the opportunity to CONNECT with your peers—open source database [&]

The post Percona Live Europe 2018 Call for Papers is Now Open appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/10/percona-live-europe-2018-call-for-papers-open/

Since MySQL 5.7 we have a new player in the field, MySQL InnoDB Cluster. This is an Oracle High Availability solution that can be easily installed over MySQL to get High Availability with multi-master capabilities and automatic failover. This solution consists in 3 components: InnoDB Group Replication, MySQL Router and MySQL Shell, you can see [&]

The post InnoDB Cluster in a nutshell  Part 1 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/09/innodb-cluster-in-a-nutshell-part-1/

Percona announces the release of Percona Toolkit 3.0.11 on July 6, 2018. Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL®, MongoDB® and system tasks that are too difficult or complex to perform manually. With over 1,000,000 downloads, Percona [&]

The post Percona Toolkit 3.0.11 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/06/percona-toolkit-3-0-11-is-now-available/

Percona announces the release of Percona Toolkit 3.0.11 on July 6, 2018. Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL®, MongoDB® and system tasks that are too difficult or complex to perform manually. With over 1,000,000 downloads, Percona [&]

The post Percona Toolkit 3.0.11 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/06/percona-toolkit-3-0-11-is-now-available/

In the last few days, there has been information released about yet another alleged data leak, placing in jeopardy “&[the] personal information on hundreds of millions of American adults, as well as millions of businesses.” In this case, the “victim” was Exactis, for whom data collection and data security are core business functions. Some takeaways [&]

The post Another Day, Another Data Leak appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/06/another-day-another-data-leak/

In this blog, we will see how to configure Percona Monitoring and Management (PMM) monitoring for a MongoDB cluster. Its very simple, like adding a replica set or standalone instances to PMM Monitoring.  For this example, I have used docker to create PMM Server and MongoDB sharded cluster containers. If you want the steps I used [&]

The post Configuring PMM Monitoring for MongoDB Cluster appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/05/configuring-pmm-monitoring-mongodb-cluster/

Amazon RDS Aurora (MySQL) provides its own low latency replication. Nevertheless, there are cases where it can be beneficial to set up replication from Aurora to an external MySQL server, as Amazon RDS Aurora is based on MySQL and supports native MySQL replication. Here are some examples of when replicating from Amazon RDS Aurora to [&]

The post How to Set Up Replication Between AWS Aurora and an External MySQL Instance appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/04/how-to-setup-replication-between-aws-aurora-external-mysql-instance/

In this post we will review the most important Linux settings to adjust for performance tuning and optimization of a MySQL database server. Well note how some of the Linux parameter settings used OS tuning may vary according to different system types: physical, virtual or cloud. Other posts have addressed MySQL parameters, like Alexanders blog MySQL 5.7 [&]

The post Linux OS Tuning for MySQL Database Performance appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/03/linux-os-tuning-for-mysql-database-performance/

GTID replication has made it convenient to setup and maintain MySQL replication. You need not worry about binary log file and position thanks to GTID and auto-positioning. However, things can go wrong when pointing a slave to a different master. Consider a situation where the new master has executed transactions that havent been executed on [&]

The post Fixing ER_MASTER_HAS_PURGED_REQUIRED_GTIDS when pointing a slave to a different master appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/02/fixing-er_master_has_purged_required_gtids-when-pointing-a-slave-to-a-different-master/

GTID replication has made it convenient to setup and maintain MySQL replication. You need not worry about binary log file and position thanks to GTID and auto-positioning. However, things can go wrong when pointing a slave to a different master. Consider a situation where the new master has executed transactions that havent been executed on [&]

The post Fixing ER_MASTER_HAS_PURGED_REQUIRED_GTIDS when pointing a slave to a different master appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/07/02/fixing-er_master_has_purged_required_gtids-when-pointing-a-slave-to-a-different-master/

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. There have been two big pieces of news this week: the release of MongoDB 4.0 and the fact that Facebook has migrated the Messenger backend over to MyRocks. MongoDB 4.0 is stable, with support for [&]

The post This Week in Data with Colin Charles 44: MongoDB 4.0 and Facebook MyRocks appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/30/this-week-in-data-with-colin-charles-44-mongodb-4-0-and-facebook-myrocks/

Percona announces the release of Percona XtraDB Cluster 5.7.22-29.26 (PXC) on June 29, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.7.22-29.26 is now the current release, based on the following: Percona Server for MySQL 5.7.22 Galera/Codership WSREP API Release 5.7.21 Galera Replication library 3.23 Deprecated The following variables [&]

The post Percona XtraDB Cluster 5.7.22-29.26 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/29/percona-xtradb-cluster-5-7-22-29-26-is-now-available/

In MySQL 8.0 there are two new features designed to support lock handling: NOWAIT and SKIP LOCKED. In this post, well look at how MySQL 8.0 handles hot rows. Up until now, how have you handled locks that are part of an active transaction or are hot rows? Its likely that you have the application attempt [&]

The post MySQL 8.0 Hot Rows with NOWAIT and SKIP LOCKED appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/29/mysql8-hot-rows-with-nowait-skip-locked/

In MySQL 8.0 there are two new features designed to support lock handling: NOWAIT and SKIP LOCKED. In this post, well look at how MySQL 8.0 handles hot rows. Up until now, how have you handled locks that are part of an active transaction or are hot rows? Its likely that you have the application attempt [&]

The post MySQL 8.0 Hot Rows with NOWAIT and SKIP LOCKED appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/29/mysql8-hot-rows-with-nowait-skip-locked/

In MySQL 8.0 there are two new features designed to support lock handling: NOWAIT and SKIP LOCKED. In this post, well look at how MySQL 8.0 handles hot rows. Up until now, how have you handled locks that are part of an active transaction or are hot rows? Its likely that you have the application attempt [&]

The post MySQL 8.0 Hot Rows with NOWAIT and SKIP LOCKED appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/29/mysql8-hot-rows-with-nowait-skip-locked/

The need to recover a database back to a certain point in time can be a nerve-racking task for DBAs and for businesses. Can this be simplified? Could it be made to work faster? Can we recover to a given point in time with zero loss of transactions/records? Fortunately, the answer to these questions is [&]

The post Faster Point In Time Recovery (PITR) in PostgreSQL Using a Delayed Standby appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/28/faster-point-in-time-recovery-pitr-postgresql-using-delayed-standby/

Troubleshooting crashes is never a fun task, especially if MySQL does not report the cause of the crash. For example, when MySQL runs out of memory. Peter Zaitsev wrote a blog post in 2012: Troubleshooting MySQL Memory Usage with a lots of useful tips. With the new versions of MySQL (5.7+) and performance_schema we have the [&]

The post What To Do When MySQL Runs Out of Memory: Troubleshooting Guide appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/28/what-to-do-when-mysql-runs-out-of-memory-troubleshooting-guide/

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 for MySQL and MongoDB servers to ensure that your data works as efficiently as possible. In release 1.12, we invested our efforts in the following areas: Visual Explain in [&]

The post Percona Monitoring and Management 1.12.0 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/27/percona-monitoring-and-management-1-12-0-is-now-available/

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 for MySQL and MongoDB servers to ensure that your data works as efficiently as possible. In release 1.12, we invested our efforts in the following areas: Visual Explain in [&]

The post Percona Monitoring and Management 1.12.0 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/27/percona-monitoring-and-management-1-12-0-is-now-available/

As PostgreSQL based applications scale, the need to implement connection pooling can become apparent sooner than you might expect. Since, PostgreSQL to date has no built-in connection pool handler, in this post Ill explore some of the options for implementing connection pooling. In doing so, well take a look at some of the implications for application [&]

The post Scaling PostgreSQL with PgBouncer: You May Need a Connection Pooler Sooner Than You Expect appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/27/scaling-postgresql-with-pgbouncer-you-may-need-a-connection-pooler-sooner-than-you-expect/