MySQL Health Checks

Health Check ReportWhat’s wrong in your production environment?

Discover your current problems and your potential future problems. Learn how to fix or prevent them. Usually many cures are low hanging fruits, as simple as changing a setting in MySQL or rewriting a query. Other problems can be more complex to solve, and I can offer my help. Or you could be lucky, maybe your production databases have no relevant problems. But even in that case, you may want to hear that from an expert.

How the service works

Database Health Checks are very simple for you. First, I will have a meeting (remotely or onsite) with a DBA or system administrator, to find out how you use your databases and what your concerns are. Then I will require an access to your databases and your monitoring systems. I will collect information and metrics, and I will spend one or two days analysing them. I will then deliver a document listing your current and potential problems, my detailed recommendations to fix them, and your safe areas. Eventually, we will have a final meeting, so you can ask me questions about the document.

What you will get

The outcome of the Health Check is a document that covers all aspects of your databases:

  • Hardware or virtual resources
  • OS configuration
  • MySQL configuration, replication topology, backups
  • Schema design (mainly indexes)
  • 8 most impacting queries
  • Security

For each area, you will see a set of current problems or potential future problems, based on the metrics I have. For each problem, you will see a clear recommendation on how to solve it.

It is important to understand that Health Checks come with no lock-ins at all. All problems are explained in simple terms. Final recommendations can be followed by any competent professional. While I offer my help, it will not be necessary to fix the problems I will highlight.

During the whole duration of the work, I do my best to guarantee your data security and your privacy. See Consulting Policy for details.

Supported technologies

Technologies covered by this service:

  • MySQL, Percona Server, MariaDB, Galera Cluster
    • Including very old versions: 3.23, 4.0, 4.1, 5.0, …
    • Storage engines: RocksDB/MyRocks, TokuDB, SPIDER, CONNECT, Federated, MyISAM/Aria…
  • Others: memcached, ClickHouse, Sphinx
  • ProxySQL, MySQL Router, HAProxy
  • Service discovery: Consul, etcd

A Database Health Check normally covers no more than 3 servers from the same replication chain, or 2 servers and 1 proxy. Service discovery solutions can also be covered.

Benefits

I believe that Database Health Checks are a good idea for:

  • New customers. You will see how I work, and I will familiarise with your environment and needs. We will discuss and set clear expectations.
  • Recurring customers. A periodic Health Check will spot problems that may have appeared over time.

The benefits for both are:

  • List of current/potential problems, with their priorities.
  • List of low-effort improvements.
  • Identify the problematic areas that need improvements, plan future work.
  • Fix mistakes and bad practices.
  • Better understanding of your database technologies, where it is needed.

Next steps

Investigations on specific complex problems are not part of a Database Health Check. After we discuss your problems, I can offer my support to implement solutions, but this is not part of a Database Health Check.

As mentioned before, further assistance is purely optional and not necessary to apply my recommendations.

Cost and timing

Usually, the price of this service is 1,250 GBP.

The work is articulated in two phases:

  • Metrics collection. 2 days since the moment the proper technologies have been setup.
  • Metrics analysis. 3 working days.
  • A wrap-up call, to be scheduled.

These are indicative timings. The final document’s due date will be agreed before the start of the work.

The cost and timing are higher for onsite health checks, and health checks on more than two servers.

Other factors that may affect the cost are the use of non-common technologies or very old software versions. The reason is that this may require some research.

← Back to Services