Buy Percona ServicesBuy Now!

Fixing ER_MASTER_HAS_PURGED_REQUIRED_GTIDS when pointing a slave to a different master

 | July 2, 2018 |  Posted In: GTID, MySQL, Replication

gtid auto position

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 haven’t been executed on […]

Read More

This Week in Data with Colin Charles 44: MongoDB 4.0 and Facebook MyRocks

 | June 30, 2018 |  Posted In: MariaDB, MongoDB, MyRocks, MySQL, PostgreSQL

Colin Charles

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 […]

Read More

Percona XtraDB Cluster 5.7.22-29.26 Is Now Available

 | June 29, 2018 |  Posted In: Events and Announcements, High-availability, MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL

Percona XtraDB Cluster 5.7

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 […]

Read More

Percona Monitoring and Management 1.12.0 Is Now Available

 | June 27, 2018 |  Posted In: Amazon RDS, AWS, Database Monitoring, Events and Announcements, MongoDB, MySQL, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL, PMM

Percona Monitoring and Management

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 […]

Read More

Scaling PostgreSQL with PgBouncer: You May Need a Connection Pooler Sooner Than You Expect

 | June 27, 2018 |  Posted In: Benchmarks, PostgreSQL

PostgreSQL connection pools

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 I’ll explore some of the options for implementing connection pooling. In doing so, we’ll take a look at some of the implications for application […]

Read More

Webinar 6/28: Securing Database Servers From External Attacks

 | June 27, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, PostgreSQL, Replication, Security, Technical Webinars

securing database servers

Please join Percona’s Chief Evangelist Colin Charles on Thursday, June 28th, 2018, as he presents Securing Database Servers From External attacks at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now   A critical piece of your infrastructure is the database tier, yet people don’t pay enough attention to it judging by how […]

Read More

MongoDB Explain – Using PMM-QAN for MongoDB Query Analytics

 | June 26, 2018 |  Posted In: .PMM QAN, EXPLAIN, MongoDB, Percona Monitoring and Management, PMM

MongoDB explain plan with PMM-QAN

In this blog post, we will walk through PMM-Query Analytics for MongoDB. We will see how to analyze MongoDB query performance; review the initial parameters that we need to check; and find out how to compare MongoDB query performance with and without indexes with the help of EXPLAIN plan. The Percona Monitoring and Management QAN (PMM-QAN) dashboard […]

Read More

Percona’s widely read Percona Database Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.