by Peter Zaitsev | Jul 10, 2018 | MySQL, Percona Software
The common wisdom with database performance management is that a “cold” database server has poor performance. Then, as it “warms up”, performance improves until finally you reach a completely warmed up state with peak database performance. In other words, that to get...
by Bronwyn Campbell | Jul 10, 2018 | MySQL, Open Source, Percona Events, Percona Live, Percona Software
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. The conference takes place November 5–7. Our theme this year is Connect. Accelerate. Innovate....
by Francisco Bordenave | Jul 9, 2018 | Insight for DBAs, MySQL
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...
by Michael Coburn | Jul 6, 2018 | MariaDB, MongoDB, MySQL, Percona Events, Percona Software
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...
by David Busby | Jul 6, 2018 | MongoDB, MySQL, Percona Software, Security
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...
by Vinodh Krishnaswamy | Jul 5, 2018 | MongoDB, Percona Software
In this blog, we will see how to configure Percona Monitoring and Management (PMM) monitoring for a MongoDB cluster. It’s very simple, like adding a replica set or standalone instances to PMM Monitoring. For this example, I have used docker to create PMM Server...
by Alexander Rubin | Jul 4, 2018 | Cloud, Insight for DBAs, MySQL
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....
by Spyros Voultepsis | Jul 3, 2018 | Insight for DBAs, MySQL, Percona Software
In this post, we will review the most important settings for Linux performance tuning to adjust for optimization of a MySQL database server. We’ll note how some of the Linux parameter settings used OS tuning may vary according to different system types:...
by Jaime Sicam | Jul 2, 2018 | Insight for DBAs, MySQL
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...
by Colin Charles | Jun 30, 2018 | MariaDB, MongoDB, MySQL, PostgreSQL, Storage Engine
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...
by Dmitriy Kostiuk | Jun 29, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
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...
by Arunjith Aravindan | Jun 29, 2018 | MySQL
In MySQL 8.0 there are two new features designed to support lock handling: NOWAIT and SKIP LOCKED. In this post, we’ll 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?...
by Avinash Vallarapu | Jun 28, 2018 | Insight for DBAs, PostgreSQL
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?...
by Alexander Rubin | Jun 28, 2018 | MySQL, Percona Software
Troubleshooting crashes is never a fun task, especially if MySQL does not report the cause of the crash. For example, when a MySQL memory issue shows up. Peter Zaitsev wrote a blog post in 2012: Troubleshooting MySQL Memory Usage with lots of useful tips. With the new...
by Michael Coburn | Jun 27, 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 Fernando Laudares Camargos | Jun 27, 2018 | Benchmarks, PostgreSQL
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 it...
by Lorraine Pocklington, Community Manager | Jun 27, 2018 | Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, PostgreSQL, Security, Webinars
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...
by Aayushi Mangal | Jun 26, 2018 | Insight for DBAs, MongoDB, Percona Software
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...
by Sveta Smirnova | Jun 26, 2018 | Insight for DBAs, Insight for Developers, MariaDB, MySQL, Percona Software, Webinars
Please join Percona’s Principal Support Escalation Specialist Sveta Smirnova as she presents Troubleshooting Best Practices: Monitoring the Production Database Without Killing Performance on Wednesday, June 27th at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register...
by Vadim Tkachenko | Jun 25, 2018 | Cloud, MySQL, Percona Software, ProxySQL
Kubernetes, and its most popular distribution OpenShift, receives a lot of interest as a container orchestration platform. However, databases remain a foreign entity, primarily because of their stateful nature, since container orchestration systems prefer stateless...
