Welcome to the second day of the Percona Live Open Source Database Conference 2017, and the second set of Percona Live keynotes! It’s a bit rainy outside today, but that isn’t bothering the Percona Live attendees (we’re all indoors learning about new open source technologies)!

Day two of the conference kicked off with another four keynote talks, all of which discussed issues and technologies that are addressed by open source solutions:

The Open Source Database Business Model is Under Siege

Paul Dix (InfluxData)

Paul Dix’s keynote may have ruffled a few feathers, as he looked at possible futures for the open …

In this blog post, I will discuss the solutions for monitoring databases (which includes alerting) I have worked with and recommended in the past to my clients. This survey will mostly focus on MySQL solutions. 

One of the most common issues I come across when working with clients is monitoring and alerting. Many times, companies will fall into one of these categories:

• No monitoring or alerting. This means they have no idea what’s going on in their environment whatsoever.
• Inadequate monitoring. Maybe people in this camp are using a platform that just tells them the database is up or connections are happening, but there is no insight into what the database is doing.
• Too much monitoring and alerting. Companies in this camp have tons of dashboards filled with graphs, and their inbox is full of alerts that get promptly ignored. This type of monitoring is just as useful as the first option. Alert …

Intro

The purpose of this project was to measure the potential overhead of VividCortex Agent, which is used by VividCortex.com database monitoring system. This benchmark is part of a consulting engagement with VividCortex and paid by the customer.

The assumption is that VividCortex agent uses CPU processing time, and we should see an impact on user queries when the workload is CPU-intensive (how much is to be measured). The impact on IO-bound should be small or insignificant.

Workload Description
For this, we use LinkBenchX benchmark in a combination of different options.

Workloads

There are 3 different workloads we want to look into:

• CPU bound. …

I was talking with a Percona Support customer earlier this week who was looking for Galera data on Percona Cloud Tools. (Percona Cloud Tools, now in free beta, is a hosted service providing access to query performance insights for all MySQL uses.)

The customer mentioned they were already keeping track of some Galera stats on Cacti, and given they were inclined to use Percona Cloud Tools more and more, they wanted to know if it was already supporting Percona XtraDB Cluster. My answer was: “No, not yet: you can install agents in each node (the regular way in the first node, then …

I was talking with a Percona Support customer earlier this week who was looking for Galera data on Percona Cloud Tools. (Percona Cloud Tools, now in free beta, is a hosted service providing access to query performance insights for all MySQL uses.)

The customer mentioned they were already keeping track of some Galera stats on Cacti, and given they were inclined to use Percona Cloud Tools more and more, they wanted to know if it was already supporting Percona XtraDB Cluster. My answer was: “No, not yet: you can install agents in each node (the regular way in the first node, then …

At the Brainiac Corner, we meet with some of the sharpest minds in the system, database, devops, and IT world. If you’d like to share your thoughts on pirates, ninjas, the future of system administration, or any other relevant topic, please don’t hesitate to contact us.

This week we are lucky to interview Sam Lambert, GitHub Database Administrator, and general all around badass. When he’s not surrounded by many leather bound books, Sam tweets @isamlambert, even sometimes about VividCortex

How did you get from stork to brainiac (i.e. …

At the Brainiac Corner, we meet with some of the sharpest minds in the system, database, devops, and IT world. If you’d like to share your thoughts on pirates, ninjas, the future of system administration, or any other relevant topic, please don’t hesitate to contact us.

This week we are lucky to hear from Amrith Kumar, a Founder and CTO at ParElastic, a venture-backed, pre-built MySQL sharding solution. We’ve gotten to know Amrith through the conference circuit and were even more excited to share his thoughts with our readers.

How did you get from stork to brainiac (i.e. what do you do today and how did you get there)?

I’ve always been fascinated by computers and …

Hello Charlottesville and Montevideo, we are looking for talented software engineers to join our team.

Background

Our company builds database management tools for the world’s leading technology companies. Our users are recognizable, leading websites that you use everyday. We run agents on highly critical production systems, collect a large amount of data, and our clients use our webapp to run their systems better and faster, automatically identify problems, and look at systems in a new way.

We are backed by some very smart investors (#2 on the Netflix Challenge, founder of IPOed tech company, founder of leading AdWords consulting firm), Battery Ventures, and a lot of other cool folks.

Our …