Tag: Insight for DBAs

Feed: Planet PostgreSQL. Jobin Augustine, Avinash Vallarapu and Fernando Laudares | September 28, 2018 |  Posted In: High-availability, Insight for DBAs, Insight for Developers, PostgreSQL PREVIOUS POST High availability (HA) and database replication is a major topic of discussion for database technologists. There are a number of informed choices to be made to optimize PostgreSQL replication so that you achieve HA. In this post we introduce an overview of the topic, and cover some options available to achieve high availability in PostgreSQL. We’ll then focus in on just one way to implement HA for postgres, using Patroni.   In our previous blog posts, we ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Peter Zaitsev | September 28, 2018 |  Posted In: Benchmarks, Hardware and Storage, Insight for DBAs, MySQL, Percona Monitoring and Management, PMM, Prometheus PREVIOUS POST 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 estimate the resources required, and what drives resource consumption. We have now tested PMM with up ... Read More

Feed: Planet PostgreSQL. Avinash Vallarapu, Fernando Laudares and Jobin Augustine | September 21, 2018 |  Posted In: Events and Announcements, Insight for DBAs, Insight for Developers, PostgreSQL, Security PREVIOUS POST 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 aspects an enterprise should consider for their PostgreSQL environments. This series of blogs addressing particular aspects of the ... Read More

Feed: Planet PostgreSQL. Avinash Vallarapu, Jobin Augustine and Fernando Laudares | September 14, 2018 |  Posted In: Insight for DBAs, Insight for Developers, PostgreSQL, Technical Webinars PREVIOUS POST 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. “We built our application on top of PostgreSQL. It works great but only now that we took it to the market and it ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Peter Zaitsev | September 11, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Percona Monitoring and Management, PMM PREVIOUS POST 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 the deployed Linode and then click on the “Rebuild” Link 3. Click on Deploy Using StackScripts 4. On ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Jervin Real | September 7, 2018 |  Posted In: Amazon Aurora, AWS, Insight for DBAs, MySQL, Technical Webinars PREVIOUS POST Please join Percona’s Senior Consultant, Jervin Real, as he presents Migrating to AWS Aurora: A Checklist for Success. The event will take place on Tuesday, September 11th, 2018, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). In the last few weeks, we have shown you how to successfully migrate from on-premise MySQL installations to AWS Aurora. What comes next is how to successfully ensure that your Aurora cluster performs and operates as you expect ... Read More

Feed: Planet MySQL; Author: Colin Charles; Colin Charles | August 24, 2018 |  Posted In: Cloud and MySQL, Insight for DBAs, MariaDB, MySQL, Percona Live, PostgreSQL PREVIOUS POST Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Grading is underway for talks at Percona Live Europe 2018. I understand that by next week you will see the tutorial schedule released. As part of the program committee, I have enjoyed reviewing tutorials, and I reckon there is great competition for the schedule. I suggest you register now, and don’t forget to book your ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Peter Zaitsev | 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 PREVIOUS POST 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 what techniques you can apply for performance optimization and scalability ... Read More

Feed: Planet PostgreSQL. Ibrar Ahmed | August 29, 2018 |  Posted In: Insight for DBAs, Kernel Parameter, Performance Tuning, PostgreSQL PREVIOUS POST For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. Poorly configured OS kernel parameters can cause degradation in database server performance. Therefore, it is imperative that these parameters are configured according to the database server and its workload. In this post, we will discuss some important kernel parameters that can affect database server performance and how these should be tuned. SHMMAX / SHMALL SHMMAX is a kernel parameter used to define the maximum size of a single ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Vadim Yalovets | 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 PREVIOUS POST 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 code. It’s based on the textfile collector. Enable the textfile ... Read More