One place for hosting & domains

      Monitoring

      How to Deploy Percona Monitoring and Management (PMM) with One-Click Apps


      Updated by Linode

      Contributed by
      Linode

      Marquee image for How to Deploy Percona Monitoring and Management (PMM) with One-Click Apps

      Percona (PMM) One-Click App

      Percona Monitoring and Management (PMM) is an open-source tool which provides a GUI powered by Grafana for monitoring and managing MySQL, MariaDB, PostgreSQL, and MongoDB databases. You can use PMM to easily observe important metrics, logging, and statistics related to your databases and the hosts they run on. Additionally, it includes a number of tools which can help to optimize your database’s performance, manage all database instances, and track and identify potential security threats. Linode’s Percona (PMM) One-Click App deploys a Linode with PMM installed and ready for you to begin monitoring your databases.

      PMM Architecture Overview

      The PMM tool uses a client-server model which makes it easy to scale monitoring across several databases hosted on various remote hosts. See the table below to better understand how each PMM component fits into the context of Linode’s Percona (PMM) One-Click App.

      Component Description
      PMM Server The Percona (PMM) One-Click App deploys an instance of the PMM Server, which includes the Grafana web interface to visualize all the data collected from the databases it monitors.
      PMM Client You will need to install the PMM Client on any Linode that hosts a database that you would like to monitor. The PMM Client will help you connect to the PMM Server and relay host and database performance metrics to the PMM Server.

      Note

      Deploy a Percona (PMM) One-Click App

      Linode’s One-Click App Marketplace allow you to easily deploy software on a Linode using the Linode Cloud Manager. To access Linode’s One-Click App Marketplace:

      1. Log in to your Linode Cloud Manager account.

      2. From the Linode dashboard, click on the Marketplace button in the left-hand navigation menu.

      3. The Linode creation page will appear, with the One-Click and Marketplace tabs pre-selected.

      4. Under the Select App section, select the app you would like to deploy:

        Select a One-Click App to deploy

      5. Once you have selected the app, proceed to the app’s Options section and provide values for the required fields.

      Percona (PMM) Options

      Configuration Description
      Hostname The hostname to assign to your new Linode. Required.

      Linode Options

      The following configuration options are possible for your Linode server:

      Configuration Description
      Select an Image Debian 10 and Ubuntu 20.04 are currently the only images supported by the Percona (PMM) One-Click App. Required.
      Region The region where you would like your Linode to reside. In general, it’s best to choose a location that’s closest to you. For more information on choosing a DC, review the How to Choose a Data Center guide. You can also generate MTR reports for a deeper look at the network routes between you and each of our data centers. Required.
      Linode Plan Your Linode’s hardware resources. Percona recommends roughly 1 GB of storage on your PMM Server for each database node you would like to monitor. For more information on Percona’s system requirements see their official documentation. If you decide that you need more or fewer hardware resources after you deploy your app, you can always resize your Linode to a different plan. Required.
      Linode Label The name for your Linode, which must be unique between all of the Linodes on your account. This name will be how you identify your server in the Cloud Manager’s Dashboard. Required.
      Root Password The primary administrative password for your Linode instance. This password must be provided when you log in to your Linode via SSH. It must be at least 6 characters long and contain characters from two of the following categories: lowercase and uppercase case letters, numbers, and punctuation characters. Your root password can be used to perform any action on your server, so make it long, complex, and unique. Required.

      When you’ve provided all required Linode Options, click on the Create button. Your PMM app will complete installation anywhere between 1-5 minutes after your Linode has finished provisioning.

      Software Included

      The Percona (PMM) One-Click App will install the following required software on your Linode:

      Software Description
      Docker Docker is used to containerize PMM.
      Grafana Grafana is the visualization tool used by PMM to provides charts, graphs, and alerts for the databases that are being monitored.
      pmm-admin pmm-admin is a command-line tool used to manage PMM Clients.

      Note

      Currently, Linode does not manage software and systems updates for One-Click Apps. It is up to the user to perform routine maintenance on software deployed in this fashion.

      Getting Started after Deployment

      Access your PMM Server’s Grafana Dashboard

      After the PMM Server has finished installing, you will be able to access its Grafana dashboard over http:// and your Linode’s IPv4 address. To find your Linode’s IPv4 address:

      1. Click on the Linodes link in the sidebar. You will see a list of all your Linodes.

      2. Find the Linode you just created when deploying your app and select it.

      3. Navigate to the Networking tab.

      4. Your IPv4 address will be listed under the Address column in the IPv4 table.

      5. Copy and paste the IPv4 address into a browser window. Ensure you are using http://.

      6. You will see the PMM Home Dashboard actively monitoring your server:

        Percona Home Page

      Installing the PMM Client

      To begin monitoring a database node, you will need to install the PMM Client on the Linode that hosts your database and connect the node to the PMM Server.

      Note

      The PMM Server deployed with Linode’s Percona (PMM) One-Click App is compatible with PMM Client version 1.
      1. Connect to your Linode via SSH.

      2. Update your system’s software.

        Debian or Ubuntu:

        sudo apt-get update && apt-get upgrade
        

        CentOS:

        sudo yum update
        
      3. Install the PMM Client (version 1):

        Debian or Ubuntu:

        sudo apt-get install pmm-client
        

        CentOS:

        sudo yum install pmm-client
        
      4. Connect your database node to the PMM Server. Replace 192.0.2.0 with your PMM Server’s IPv4 address.

        Note

        sudo pmm-admin config --server 192.0.2.0
        

        Once complete, you should see a similar output:

          
        OK, PMM server is alive.
        
        PMM Server      | 192.0.2.0
        Client Name     | li222-111
        Client Address  | 192.0.2.1
              
        

      Monitor a Database Instance

      Once your database node and your PMM Server are communicating, the final step is to add your database instance to be monitored by your PMM Server. These steps are completed on your Database node.

      1. Connect to your Linode via SSH.

      2. Add your database instance to be monitored by your PMM Server. This command will add a MySQL database instance to be monitored. You can replace mysql with the database type that your node is hosting (i.e. postgresql or mongodb). See Percona’s Managing PMM Client documentation for details.

        pmm-admin add mysql
        

        Your Percona dashboard should now be monitoring your MySQL service.

        https://www.linode.com/perconafinal.png

        Note

      Next Steps

      The Percona Monitoring Management Tool is very powerful and can be configured to monitor and display various pieces of your database instances. Once you have completed the basic configurations outlined in this guide, you should review Percona’s documentation to learn more about the PMM tool. Here are some suggested topics:

      This guide is published under a CC BY-ND 4.0 license.



      Source link

      Survey: Monitoring and OS Maintenance are IT Pros Biggest Infrastructure Time Wasters


      If time is considered a finite resource, IT pros are feeling a shortage.

      For INAP’s second annual State of IT Infrastructure Management report, we asked IT professionals to list the routine infrastructure activities taking too much and too little of their time. Once again, monitoring topped the “too much time” list, while designing and implementing new solutions ranked No. 1 in the “not enough time” category.

      Overall, 59 percent of IT pros are frustrated by the time spent on routine infrastructure activities and 84 percent agreed that they “could bring more value to their organization if they spent less time on routine tasks”—up 7 points from 2018.

      The survey was conducted late last year among 500 IT senior leaders and infrastructure managers in the United States and Canada. The margin of error was +/- 5 percent.

      Participants also shared how often their personal time is interrupted and how they would spend their time if they were given 16 hours back to use as they please.

      Check out the results below and download a copy of the full report here.

      How IT Pros Spend (And Don’t Spend) Their Time

      Here’s the full list of routine infrastructure activities alongside IT’s assessment of whether each is getting the attention it deserves.

      IT's Time

      Only 23 percent of participants said they don’t spend enough time monitoring infrastructure, which is less than half the rate of those who consider this routine activity to be something that is eating into time that could be spent elsewhere (48 percent).

      Operating system and hardware maintenance came in second and third, at 42 percent and 40 percent, respectively.

      Nearly half (47 percent) of IT pros want to spend more time on designing and implementing new solutions, compared to 28 percent who already spend too much time.

      IT pros remain polarized, as they were in the 2018 report, as to whether the amount of time spent securing their infrastructure is hitting the mark, with 39 percent saying it’s too much and 42 percent saying it’s not enough. Information security management/vulnerability migration is also the activity where the highest percentage of IT pros went one way or another on the issue, as only 19 percent fell into the “neither” category.

      Senior leaders were far more likely to say they spend too much time on security compared to non-senior infrastructure managers—30 percent vs. 13 percent. They were also more likely to say they don’t focus enough on OS maintenance—20 percent vs 6 percent of non-leaders.

      How IT Pros Would Like to Spend Their Time

      Survey respondents say their personal time is disrupted by work responsibilities related to server and/or cloud infrastructure an average of 6.24 times per month—up slightly from 5.9 times in 2018’s report.

      With so much time—on and off the clock—being dedicated to upkeep and maintenance, we once again asked, “What would you do if we gave you 16 hours back in your week?”

      16 hours

      Application related answers make up three of the top four activities this year, with “enhancing existing applications” and “optimizing existing environments for application performance” coming in third and fourth, respectively. Reclaiming work-life balance fell to second, after claiming the top spot in 2018.

      In the first annual State of IT Infrastructure Management report, IT pros noted that their departments are the key driver of their organization’s digital transformation initiatives, but they are spending too much time on routine tasks, focusing on functions that are “just keeping the lights on.” This sentiment continued in 2019. The list of activities noted in the chart above can be considered the opportunity costs of these routine tasks.

      Have you read checked out our second annual State of IT Infrastructure Management report yet? If not, download a free copy and get your report card for the hybrid IT and multicloud era:

      Laura Vietmeyer


      READ MORE



      Source link

      Exploring the Features of Intelligent Monitoring, powered by INAP INblue


      What would you do if you didn’t have to spend time on routine server- or cloud-related maintenance and monitoring?

      According to INAP’s The State of IT infrastructure Management report, a vast majority of IT professionals say they are not spending enough time designing or implementing new solutions, working on expansions or upgrades, or focusing on information security projects. As it stands, 25 percent of participants say they spend too many hours on monitoring, and it’s clear that there’s a desire to set aside the busywork for value-added projects, allowing IT to be a center for innovation, rather than viewed as “purely keeping the lights on” by the company’s senior management.

      Intelligent Monitoring, powered by INAP INblue—a multicloud infrastructure management platform, gives you time for what matters. It’s a premium managed cloud and monitoring service—available today for INAP Bare Metal customers—that raises the bar for managed hosting solutions by ensuring proactive support, service transparency and consistent performance.

      “Infrastructure monitoring strategies are only as good as the actions that follow alerts,” said Jennifer Curry, SVP of Global Cloud Services at INAP. “We built Intelligent Monitoring to not only improve cloud performance and availability, but to set a new benchmark for managed services transparency.”

      In addition to an improved service experience, Managed Bare Metal customers also have access to the same enterprise-grade monitoring and management tools used by INAP technicians, offering functionality and control that will eliminate the need for customers to invest in third-party remote monitoring and management solutions, including remote execution and scripting, unified log management, patch management and automation, and port, service and URL monitoring.

      Let’s take a closer look at the features that make Intelligent Monitoring a one-of-a-kind solution.

      Advanced Monitoring & Action Items

      Built from the ground up with leading technologies like SaltStack and Elastic Beats, the Intelligent Monitoring agent tracks everything from server resource usage to Apache and MySQL connections. The in-depth, proprietary monitoring technology is installed directly onto your server, enabling INAP technicians to respond to alerts before performance degrading issues arise. Default trigger thresholds are chosen by INAP’s support team based on years of data and first-hand expertise. You have full access to all monitoring metrics and can request custom alert triggers, or modifications to trigger thresholds.

      When you log into INblue, the dashboard will give you a snapshot of your server environment through system events called Action Items. If you subscribe to the fully managed Service First edition, these items allow your INAP support team to proactively manage your environment and rapidly respond to alerts. Action Items are triggered in a variety of ways, including when infrastructure or network monitoring thresholds are surpassed, when a critical service shuts down or when a new software patch becomes available.

      Action Items

      Support Remediation Aided by Smart Workflow System

      INAP technicians remediate Action Items using our proprietary Smart Workflow System, which enables fast, accurate and consistent troubleshooting. Here’s a brief look how it works:

      1. The Smart Workflow System defines the Action Item type and initiates appropriate workflow process.
      2. The system automatically creates a support case for the Action Item, pulling historical correlated issue data, trigger metrics and detailed log info.
      3. Using the data and Action Item type, the assigned INAP Service First support technician investigates the issue following a branching series of software-defined and expert-tested remediation steps. Customers may request custom workflows for scenarios unique to their environment.
      4. Upon resolution of the Action Item, your assigned technician will notify you via the Action Item details page and include relevant root cause data.
      5. The Smart Workflow System constantly improves as new system data and insights from INAP experts modify issue definitions and remediation steps.

      On the other side of the glass, the INblue platform is your vehicle for ensuring absolute transparency. At the top of any Action Item details page, you’ll see the INAP technician assigned to the workflow, the current status of the event and tasks they are currently performing or have already performed. You can review information about correlated past issues, metric and log data pinpointing a trigger, and your full support history for any Action Item.

      However, for most Action Items, you won’t have to do a single thing. Intelligent Monitoring’s Smart Workflow System and the INAP Service First support team are on top of every case.

      Patching and Log Management

      Intelligent Monitoring radically simplifies two activities that most IT professionals consider especially tedious: patching and log management.

      The patching update process is streamlined, as all available patches for your server are proactively listed in groups. You can handle this process in one of two ways, depending on how much control you want. You can confirm and schedule the patch to complete the process with INAP support, or—if you want a hands-off approach—you can choose to auto-patch your server daily and your team will receive calendar invites for each scheduled patch.

      Intelligent Monitoring will also save you from manually browsing events by providing a chronological event log for all your servers. Easily filter by server and file path, or dive deep with a keyword search. You’ll be able to accelerate analysis and locate critical information. Plus, the log management feature provides your INAP technicians critical, actionable intelligence to keep your environment compliant and secure.

      Log Management

      Remote Execution and Scripting

      Intelligent Monitoring allows you to easily create and run remote execution scripts to any of your installed servers, giving you a single portal for taking control of your environment. You can choose from scripts you’ve already created and schedule them by inserting a token from your two-factor authentication application. You will automatically receive an email when the script successfully executes.

      If you want to create your own Bash or Powershell scripts, you can do so via the Script Editor, located in the side navigation of the INblue platform.

      Port, Service and URL Monitoring

      Under the Ports tab on any Server Details page, you can review, edit and monitor triggers for your server’s open and closed ports. Port Status changes will be shown in your Action Items list.

      Intelligent Monitoring also allows you to monitor any available services running on your system. You can also stop, start or restart services from the Services tab. For example, you can enable service monitoring on Chron Dee, enabling the auto-restart feature. With this monitoring feature enabled, you can rest assured that if a service ever fails, it will automatically create a new Action Item.

      Looking Ahead

      This is just the beginning for Intelligent Monitoring, powered by the INAP INblue platform. Many more features and capabilities are on the way, but in the meantime, we hope you enjoy exploring the tool and look forward to hearing your feedback.

      Demo INAP Intelligent Monitoring Today

      GET THE DEMO

      Laura Vietmeyer


      READ MORE



      Source link