Buy Percona ServicesBuy Now!

Upcoming Webinar Thurs 9/27: Best Practices Using Indexes in MongoDB

 | September 25, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB, Technical Webinars

Best Practices Using Indexes in MongoDB

Please join Percona’s Principal Architect Alex Rubin as he presents Best Practices Using Indexes in MongoDB on Thursday, September 27th at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now   Indexes support the efficient execution of queries in MongoDB. Without indexes, MongoDB must perform a collection scan, i.e. scan every document in […]

Read More

Securing PostgreSQL as an Enterprise-Grade Environment

, and  | September 21, 2018 |  Posted In: Events and Announcements, Insight for DBAs, Insight for Developers, PostgreSQL, Security

PostgreSQL enterprise-grade security

In this post, we review how you can build an enhanced and secure PostgreSQL database environment using community software. We look at the features that are available in PostgreSQL that, when implemented, provide improved security. As discussed in the introductory blog post of this series, in our webinar of October 10, 2018 we highlight important […]

Read More

Upcoming Webinar Wed 9/19: Percona Server for MongoDB vs MongoDB Enterprise

 | September 17, 2018 |  Posted In: Insight for Developers, MongoDB, Percona Monitoring and Management, Percona Server for MongoDB, Technical Webinars

MongoDB Enterprise Advanced

Please join Percona’s Senior Support Engineer, Adamo Tonete, as he presents Percona Server for MongoDB vs MongoDB Enterprise on Wednesday, September 19th, 2018, at 12:30 PM PDT (UTC-7) / 3:30 PM EDT (UTC-4). Register Now   In this webinar we will evaluate MongoDB Community, MongoDB Enterprise Advanced, and Percona Server for MongoDB side-by-side to better inform […]

Read More

PostgreSQL Webinar Wed Oct 10th – Enterprise-Grade PostgreSQL: Built on Open Source Tools

, and  | September 14, 2018 |  Posted In: Insight for DBAs, Insight for Developers, PostgreSQL, Technical Webinars

Enterprise PostgreSQL built with open source tools

Please join Percona’s PostgreSQL Support Technical Lead,  Avinash Vallarapu; Senior Support Engineer, Fernando Laudares; and Senior Support Engineer, Jobin Augustine, on Wednesday, October 10th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4), as they demonstrate an enterprise-grade PostgreSQL® environment built using a combination of open source tools and extensions. Register Now “We […]

Read More

How To Deploy PMM on Linode With StackScripts

 | September 11, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Percona Monitoring and Management, PMM

rebuiild from a StackScript

In my previous blog post, I showed how to deploy Percona Monitoring and Management (PMM) on Linode manually. It is pretty simple, but with a little coding it can be done even more easily using StackScripts Here’s how: 1. Click on the “Add a Linode” and pick a Linode type you want to deploy. 2. Click on […]

Read More

MongoDB: Investigate Queries with explain() and Index Usage (part 2)

 | September 6, 2018 |  Posted In: Insight for Developers, MongoDB, open source databases, Percona Server for MongoDB

MongoDB explain() method optimization tool

This is the second part of a two parts series. In MongoDB: index usage and MongoDB explain() we introduced the main index types supported by MongoDB, and how to create and use them. In this second article, we are going to see some examples on how to use explain() method to investigate queries. Do you […]

Read More

MongoDB: index usage and MongoDB explain() (part 1)

 | September 4, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB, open source databases, Percona Server for MongoDB

MongoDB index types

In this two part series, I’m going to explain explain. No, the repetition is not a pun or a typo. I’m talking about explain(), the most useful MongoDB feature to investigate a query. Here, I’ll introduce the index types available in MongoDB, their properties and how to create and use them. In the next article we’ll […]

Read More

Is It a Read Intensive or a Write Intensive Workload?

 | August 30, 2018 |  Posted In: Database Monitoring, Insight for DBAs, Insight for Developers, MySQL, Percona Monitoring and Management, Percona Server for MySQL, Performance Tuning, PMM

innodb row operations featured

One of the common ways to classify database workloads is whether it is  “read intensive” or “write intensive”. In other words, whether the workload is dominated by reads or writes. Why should you care? Because recognizing if the workload is read intensive or write intensive will impact your hardware choices, database configuration as well as […]

Read More

Extend Metrics for Percona Monitoring and Management Without Modifying Code

 | August 28, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB, MySQL, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL, PMM

PMM Extended Metrics

Percona Monitoring and Management (PMM) provides an excellent solution for system monitoring. Sometimes, though, you’ll have the need for a metric that’s not present in the list of node_exporter metrics out of the box. In this post, we introduce a simple method and show how to extend the list of available metrics without modifying the node_exporter […]

Read More

Webinar Wed 8/29: Databases in the Hosted Cloud

 | August 28, 2018 |  Posted In: Cloud and MySQL, Insight for DBAs, Insight for Developers, MariaDB, MySQL, MySQL 8.0, open source databases, Technical Webinars

databases-in-the-cloud

Please join Percona’s Chief Evangelist, Colin Charles on Wednesday, August 29th, 2018, as he presents Databases in the Hosted Cloud at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now   Nearly everyone today uses some form of database in the hosted cloud. You can use hosted MySQL, MariaDB, Percona Server, and PostgreSQL […]

Read More