Schedule Meeting

a

MySQL Database
Health Checks

Get your MySQL instances audited by highly skilled database professionals!

Subscribe For Free eBook

Get a PDF version of our “MariaDB and MySQL indexes for DBAs and DevOps” ebook when subscribed. You’ll also receive our technical blog updates and the most notable industry news in the digest form.


Quick Intro to MySQL Health Checks

Our service covers MySQL and related technologies including its variants (Percona Server for MySQL), storage engines, proxies (ProxySQL, MySQL Router, HA Proxy) and service discovery tools (Consul). Our report will help you gain a better understanding of your MySQL setup.

When a Database Health Check Can Help

A database is the heart of your application, and you want it to work well. Without a proper health check, it may start to invisibly lead you to money and / or reputation losses. A thorough examination will cost much less.

Why is your database so slow?

We will find slowdowns and will scientifically investigate them to find the root causes. Then we will explain to you what to do to speed up your database.

Why can't your database 'just scale'?

Databases are complex multi-purpose technologies. Scaling is possible but it may require specific knowledge of database internals.

Why does your database demonstrate strange behavior?

Database problems can be complicated and counterintuitive. It might be hard to understand what exactly went wrong without the years of experience we have.

Are your queries and your schema well optimised?

Trying to scale a cluster is often useless when SQL queries and the schema are not optimised. We’ll find the slowest queries, and the queries that slow down your servers. Sometimes the only problem of a slow application is missing or poorly designed indexes.

Why is your database consuming so many resources?

In many cases, you can spend less on IT infrastructure by using less nodes with more optimal schema and queries. We can get you there!

What if I want to replace my database technology?

We can help you to weigh the pros and cons, and find out if you just need to optimise your current database, because migrations are expensive.

Supported Technologies

Vettabase professionals use open source tools trusted and recommended by experts developing databases for decades. If a technology is spoken about, chances are that we have worked with it, too. We decide on a toolkit with automation at heart.

Database Health Check: Process Description

To maximize the value of our database health checks, we follow a standardized procedure that proved to be efficient throughout the years. Below you will find the description of its stages and understand what to expect from each of them. Basically, our database health check takes three working days.

1

Intro Call

At our intro calls, we usually ask if there are any specific cases or issues to investigate. Tell us more!

2

Monitoring-based check

We will examine metrics from your existing monitoring systems and setup more advanced open source monitoring solutions if required.

3

Schema Check

We will check your existing database schemas to see the logical and physical structure of your data and propose changes.

4

Server Check

We will take a look at your server configurations and see whether they can be tuned for your database to function better.

5

Health Check Results

You will get a detailed report with your database health check results split into several sections, and recommendations.

6

Explanatory Call

You will get a call from a Vettabase consultant to discuss the report, our recommendations and actions to be taken.

MySQL Health Check Pricing

This pricing only applies to one MySQL database cluster consisting of 3 nodes. For N-node clusters, multi-database environments and all types of complex database setups, please contact us directly to get a precise quotation.

Periodical health checks & discounts

If you commit do database health checks with us for more than one year, we might negotiate a special discounted price for you. You can order any number of database health checks you need, but normally we recommend doing them on a quarterly basis. To get more information on applicable discounts, contact us via sales@vettabase.com.

Security Standards

We understand that you trust us your database and the data inside it. This is why we will follow the industry's highest security standards to protect the integral part of your business.

  • No password will ever be transferred via unsafe communication channels.
  • A Non-Disclosure Agreement will be signed upon your first request.
  • SSH connection and key-based authentication will be employed by our experts when connecting to your database.
  • A Virtual Private Network (VPN) or jumphosts will be used by our team connecting to your database if you find it reasonable.

For full information on what else we do to ensure your database security, read our Consultancy Policy.

Client Testimonials

Take a look at the testimonials provided by Vettabase customers and partners – many of them are key people of the open source database community. If you want to add your reference, please contact us.

Michael ‘Monty’ Widenius

At MariaDB Foundation, we asked Vettabase to produce an analysis of the differences between MariaDB and another database technology, from a user perspective. The outcome was helpful and accurate, showing how Vettabase thorough skills cover multiple technologies.

Michael 'Monty' Widenius
Tommaso Franceschi

Vettabase is a valuable partner for Treedom. Their consulting services allowed us to improve our databases performance, scalability and security over time. In the process, Vettabase automated several maintenance tasks for our databases, using Ansible and custom scripts. Vettabase also trained our developers to write faster and more expressive SQL queries. The feedback from the attendees was great.

Tommaso Franceschi
Justin Swanhart

Federico is a consultant who is extremely familiar with the entire MySQL ecosystem, and the LAMP stack, among other things. Federico has contributed source to Flexviews, part of the Swanhart Toolkit, and has tested my software extensively, offering bug reports and authoring code to fix problems and improve test cases. I would trust Federico to work on my systems, which is a trust that I extend to very few. He is an excellent engineer that I would be proud to have in any team that I work with.

Justin Swanhart
Vitali Tsevan

We’ve spent a year developing Catawiki platform together. During this year Federico helped a lot to improve our operational database setup.
Deep knowledge of MySQL internals helped us tuning our production database servers performance. We’ve created a bunch of meaningful charts in Grafana. They explained important MySQL metrics in a simple manner. This effort helped us to achieve better transparency in the database topic.
Federico showed ability to talk to developers simply and efficiently. During organized company events and private conversations he was explaining them do’s and dont’s of working with RDBMS. This guidance resulted not only in countless refactoring improvements in our applications but also in several wiki articles presented to our developers.

Vitali Tsevan

Get Started With Vettabase Today

Professional help for your database infrastructure is just one click away! Use our contact form to explain your recent and (or) critical database issues to us. Your message will remain strictly confidential to the Vettabase team. Our experts will respond to you as soon as possible. You can also book a meeting with Federico Razzoli, the Director and Founder of Vettabase Ltd.

We at Vettabase respect our customers and offer good value for money compared to many other database consulting companies. We automate things where others leave them as they are because it means more support incidents or consulting engagements. Unlike many other companies, we will not recommend you a solution we are interested in. Quite the opposite, we will remain unbiased and use the best tools and technologies that fit your existing infrastructure, plans for growth and budget.