MySQL Health Check

A checklist on a screen

Quanto ti fidi del tuo ambiente di produzione?

  • Scopri i tuoi problemi attuali.
  • Previenti i problemi futuri prima che si verifichino.

Many fixes 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 we can offer 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.

What you will get

The outcome of the Health Check is a document containing:

  • A list of all found current problems;
  • A list of potential future problems;
  • Precise recommendations on how to fix them.

The document covers all aspects of your databases:

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

Benefits

The benefits of a Health Check are:

  • Discover current and potential problems.
  • Get practical recommendations that can be quickly applied, to immediately improve your database reliability or performance.
  • Understand which areas need more complex changes, and plan future work.
  • Fix mistakes and bad practices.
  • You will gain a better understanding of your database technologies.
Health Checks come with no lock-ins at all.
All encountered problems are explained in simple terms. Final recommendations can be applied by your team without support, if you wish so.
 

Supported technologies

Technologies covered by this service:

  • MySQL, Percona Server, Galera Cluster
    • Including very old versions: 3.23, 4.0, 4.1, 5.0, …
    • Storage engines: RocksDB/MyRocks, TokuDB, and all the storage engines distributed with MySQL, Percona Server
  • ProxySQL, MySQL Router, HAProxy
  • Service discovery: Consul

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.

How the service works

MySQL Health Checks are very simple for you. Normally health checks are remote, and they happen in the following way.

First, we will have a remote meeting with some DBAs, devops, or system administrators, to find out how you use your databases and what your concerns are. Then we will require access to your databases and your monitoring systems. We will collect information and metrics, and we will spend one or two days analysing them. We will then deliver a document listing your current and potential problems and detailed recommendations to fix them. Eventually, we will have a final meeting, so you can ask us questions about the document.

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

Next steps

Investigations on specific complex problems are not part of a Database Health Check. After we discuss your problems, we can offer 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 our recommendations.

Cost and timing

The base price for this service is 1,500 GBP, but please keep reading to understand how it can vary.

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 uncommon technologies or very old software versions. The reason is that this may require some research, or specialist advise.

The cost will be agreed before the beginning of the work.

Regular Health Checks

Database workloads change over time, because applications change and the user base increases. Repeating health checks periodically is a good idea to discover problems – or potential problems – that couldn’t be foreseen some months before.

Se si pianificano più Health Check in un anno, è possibile negoziare uno sconto.

← Torna ai Servizi

Contattaci

Contact us now to book a MySQL Health Check!

Dopo una breve discussione sui tuoi problemi e bisogni, pianificheremo un'analisi approfondita dei tuoi sistemi.

Contatti