Showing entries 1 to 10 of 178
10 Older Entries »
Displaying posts with tag: monitoring (reset)
Optimizing VividCortex’s Samples View: Part 2

A few weeks ago, I wrote a blog post explaining how sketch sampling methods can be employed to achieve fast 30-day data visibility for monitoring users. The problem we faced was that with that standard of retention, we’ve frequently seen systems that involve nearly a million query samples in a 30-day window, meaning that special solutions are needed in order to avoid overloading users’ browsers.

The solution we’ve found lies in a hash ordering that's proven to be both surprisingly simple and efficient. In this Part 2 post, I’ll look at why it works so well.

Ordering with a Hash

VividCortex’s query samples are stored in MySQL tables. The simplified schema definition looks like this:

[Read more]
pmp-check-pt-table-checksum Percona Monitoring Plugin

Recently, I worked on a customer case where the customer needed to monitor the checksum via Nagios monitoring. The pmp-check-pt-table-checksum plugin from Percona Monitoring Plugins for MySQL achieves this goal. I thought it was worth a blogpost.


 alerts you when the pt-table-checksum tool from Percona Toolkit finds data drifts on …

[Read more]
5 Monitoring Myths That Deserve to Be Busted

There’s no doubt that effective application performance management can be a daunting goal. As businesses have demanded increasingly complex tasks from their technology, the solutions required to keep their systems in top shape need to be ever more insightful and precise. While things like efficiency and uptime are the bottomline indicators of an app or database’s performance, there’s a variety of potential methods that can be used to achieve those ideals.

As in any other industry, false information proliferates where people are eager for quick, simple solutions. Naturally, we all want the fastest, most direct ways to fortify our APM. But where ambitious ideas can be powerful and positive, they can also be too good to be true or send the wrong message. Whether these involve — for example — overestimation of …

[Read more]
Percona Monitoring and Management 1.0.2 Beta

Percona announces the release of Percona Monitoring and Management 1.0.2 Beta on 28 July 2016.

Like prior versions, PMM is distributed through Docker Hub and is free to download. Full instructions for download and installation of the server and client are available in the documentation.

Notable changes to the tool include:

  • Upgraded to Grafana 3.1.0.
  • Upgraded to Prometheus 1.0.1.
  • Set default metrics retention to 30 days.
  • Eliminated port 9001. Now the container uses only one configurable port, 80 by default.
  • Eliminated the need to specify ADDRESS variable …
[Read more]
Why Adaptive Fault Detection is Powerful and Unique

Adaptive Fault Detection is a patented, algorithm-based technology and one of the important central components of the VividCortex app . Unlike other monitoring methodologies — such as anomaly detection or threshold alerting — adaptive fault detection is designed to detect events that are, by definition, detrimental to a system. It looks for issues that actually prevent work from completeing — not just anomalies or outliers. With this quick blog post, we want to help readers understand the definition and value of fault detection. To do so, it helps to delve into several key concepts:

  • Why is it important to identify faults?
  • How does VividCortex’s detect faults?
  • How does our app help users address faults when they appear?

Why is it important to identify faults?

A fault is most easily defined as a certain kind of …

[Read more]
5 Database Insights Easy to See with VividCortex SaaS Monitoring

There are manifold ways to collect, visualize, and analyze data… but not all methods are equally useful. VividCortex, however, is singular as a database-centric SaaS monitoring platform, and it's designed to provide you with powerful insights into your system that are both inherently actionable and unique. Within minutes of first booting up VividCortex, users frequently discover new aspects of their system. They understand it in brand new ways, just by viewing our app’s basic dashboards and metrics.

But that's just the start. Even beyond those initial revelations, there are many more powerful insights that VividCortex can provide, if you know how and where to look. These views aren’t entirely automatic, but they’re simple to discover with a few tips. Here are 5 insights easy to see with VividCortex.

Find which queries affect the most rows

Understanding which queries are …

[Read more]
VividCortex's SQL Injection Detection

For data-driven applications, security is of absolute importance. Virtually all modern tech-driven organizations must treat the protection of sensitive information as an imperative. At VividCortex, we know that our customers value the premium we put on data-security, along with the specific defenses we have in place that keep their data out of the wrong hands.

One such defense is VividCortex’s SQL injection detection. As all DBAs know, SQL injections are one of the most nefarious threats to a data system. For those less familiar, a SQL injection is an attack that exploits poorly validated or sanitized user inputs as they are used to construct database queries. An injection aims to gain access or destroy data by using those unsanitized inputs to alter the structure of an SQL query in ways unanticipated by its developer.

Of course, destroyed or …

[Read more]
CloudWatch Integration in VividCortex

Until recently, VividCortex was still in the process of building some important support mechanisms for Amazon RDS. RDS is an extremely powerful database service, and for some purposes it requires its own, unique tooling. We needed to find a way to provide important operating system metrics, which are normally very useful in an environment and allow us to understand how a database interacts with available resources.


With our recent integration of CloudWatch, all of that changes. We’re now able to pull in all metrics regarding a database instance’s resources. We can chart items like CPU utilization, memory usage, and disk IO. From an operational standpoint, this insight makes it possible to diagnose problems both inside the database and outside of it, in the operating system.

With CloudWatch, agents will automatically …

[Read more]
Why Use Slow Query Logs When There’s VividCortex?

At VividCortex, we believe that database monitoring can be much, much better than what many people currently settle for. In fact, we know that monitoring needs to be better -- more reliable and more efficient than what many engineering and operations teams currently use. Databases are getting larger and more complex all the time, and older monitoring techniques can’t properly optimize modern systems or keep up with issues when they arise. For instance, we consider slow query logs a prime example of a monitoring tool that’s become virtually obsolete in a world where you can find an alternative such as VividCortex.

We tell people to beware of slow query logs for …

[Read more]
Addressing a Problematic MySQL Query and its Effects on Amazon Aurora

Since we announced our support for Amazon Web Service's Aurora last year, we've had great experiences working with customers who use Aurora as their database system of choice. And not only is Amazon's RDS excellent, so is their team and support.

Recently, we encountered a MySQL bug that was, in turn, having effects on Amazon’s RDS. The MySQL issue involved a problematic query that caused Aurora instances to crash under load; upon discovering this issue, we had the opportunity to work with AWS to identify the error in MySQL and fix it, so that it would avoid an impact on AWS’s systems. It turned out that the query itself posed a potential problem for all monitoring services -- not just VividCortex; fortunately, however, once AWS addresses the bug, the problem will be fixed for all monitoring products that might come across it, …

[Read more]
Showing entries 1 to 10 of 178
10 Older Entries »