Featured
Percona Products
Percona Services
Use Cases
Peter ZaitsevOne of the most exciting features Amazon Aurora Serverless brings to the table is its ability to go to sleep (pause) when idle. This is a fantastic feature for development and test environments. You get access to a powerful database to run tests quickly, but it goes easy on your wallet as you only pay […]
Amazon Aurora with MySQL Compatibility comes in three editions which, at the time of writing, have quite a few differences around the features that they support. Make sure you don’t assume the newer Aurora 2.x supports everything in Aurora 1.x. On the contrary, right now Aurora 1.x (MySQL 5.6 based) supports most Aurora features. The […]
When I attended AWS Re:Invent 2018, I saw there was a lot of attention from both customers and the AWS team on Amazon RDS Aurora Serverless. So I decided to take a deeper look at this technology, and write a series of blog posts on this topic. In this first post of the series, you will learn […]
At AWS Re:Invent 2018 there were many great announcements of AWS New Services and New Features, but one basic feature that I’ve been waiting for years to be released is still nowhere to be found. AWS Elastic Block Storage (EBS) is great and it’s got better through the years, adding different storage types and features like Provisioned […]
Please join Percona’s CEO Peter Zaitsev as he presents MySQL 8 for Developers on Wednesday, December 12th, 2018 at 11:00 AM PST (UTC-7) / 2:00 PM EST (UTC-5). Register Now There are many great new features in MySQL 8, but how exactly can they help your application? This session takes a practical look at MySQL […]
As MongoDB® has changed their license from AGPL to SSPL many are concerned by this change, and by how sudden it has been. Will SSPL be protective enough for MongoDB, or will the next change be to go to an altogether proprietary license? According to our poll, many are going to explore MongoDB alternatives. This blog […]
MongoDB, Inc. announced it has elected to change its license for MongoDB Community Server from AGPLv3 to a new license type they have created called a “Server Side Public License (SSPL)” citing the need to have a license better suited for the age of Software-as-a-Service. First, it is important to state that MongoDB, Inc. is […]
Starting with PMM 1.13, PMM uses Prometheus 2 for metrics storage, which tends to be heaviest resource consumer of CPU and RAM. With Prometheus 2 Performance Improvements, PMM can scale to more than 1000 monitored nodes per instance in default configuration. In this blog post we will look into PMM scaling and capacity planning—how to […]
Prometheus 2 time series database (TSDB) is an amazing piece of engineering, offering a dramatic improvement compared to “v2” storage in Prometheus 1 in terms of ingest performance, query performance and resource use efficiency. As we’ve been adopting Prometheus 2 in Percona Monitoring and Management (PMM), I had a chance to look into the performance […]
Please note: This blog refers to Percona Monitoring and Management v1. For information on v2, please visit Understanding Processes Running on Linux Host with Percona Monitoring and Management. A few months ago I wrote a blog post on How to Capture Per Process Metrics in PMM. Since that time, Nick Cabatoff has made a lot […]
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 […]
In his excellent blog post, Pavel Trukhanov showed the value of S.M.A.R.T. metric collections, so I wondered how hard would it be to enable their collection in Percona Monitoring and Management (PMM) A quick search led me to the text_collector plugin SmartMon, which can be easily integrated with any Prometheus Installation For PMM, Vadim Yalovets recently […]
Please join Percona’s CEO, Peter Zaitsev as he presents Choosing the Right Open Source Database on Wednesday, September 5th, 2018 at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Watch Now The world of open-source databases is overwhelming. There are dozens of types of databases – relational DBMS, time-series, graph, document, etc. – not to […]
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 […]
Please join Percona’s CEO, Peter Zaitsev as he presents Forking or Branching – Lessons from the MySQL Community on Tuesday, August 28th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now The MySQL Community offers a great example of various forks and branches, with MariaDB being the most well-known fork, […]
Please join Percona’s CEO, Peter Zaitsev as he presents MySQL vs MongoDB – Choosing the Right Technology for Your Application on Thursday, August 23, 2018, at 10:30 AM PDT (UTC-7) / 1:30 PM EDT (UTC-4). Register Now Are you considering to adopt the most popular open source relational database or the most popular open source […]
When deployed through Docker Percona Monitoring and Management (PMM) uses environment variables for its configuration For example, if you want to adjust metrics resolution you can pass -e METRICS_RESOLUTION=Ns as an option to the docker run command:
|
1 2 3 4 5 6 7 |
docker run -d \ -p 80:80 \ --volumes-from pmm-data \ --name pmm-server \ --restart always \ -e METRICS_RESOLUTION=2s \ percona/pmm-server:1 |
You would think if you want to change the setting for existing installation you can just stop the container with docker stop and […]
In Percona Monitoring and Management (PMM) 1.13 we have adopted Prometheus 2, and with this comes a dramatic improvement in resource usage, along with performance improvements! What does it mean for you? This means you can have a significantly larger number of servers and database instances monitored by the same PMM installation. Or you can […]
Please join Percona’s CEO, Peter Zaitsev as he presents Using MySQL for Distributed Database Architectures on Tuesday, July 31st, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now In modern data architectures, we’re increasingly moving from single-node design systems to distributed architectures using multiple nodes – often spread across multiple […]
If you’re reading consumer SSD reviews and using them to estimate SSD performance under database workloads, you’d better stop. Databases are not your typical consumer applications and they do not use IO in the same way. Let’s look, for example, at this excellent AnandTech review of Samsung 960 Pro – a consumer NVMe device that […]