Skip to content
  • +44 7739 427279
  • info@federico-razzoli.com

Federico Razzoli

Database Specialist    |    MySQL Consultant

  • About Me
  • Testimonials
  • Services
  • Newsletter
  • Webinars
  • Contacts

Category: Monitoring

Testing database backups

Federico Razzoli February 18, 2020May 30, 2020 Leave a comment

Backups need to be tested to avoid epic incidents like the one occurred to GitLab in 2017. But how should they be tested, and what should we monitor exactly?

Read more
Monitoring

Understanding tables usage with User Statistics (Percona Server, MariaDB) (→Vettabase)

Federico Razzoli January 6, 2020November 21, 2020 Leave a comment

Let’s use Percona User Statistics to analyse our most used tables, and to look for problems where they mostly matter.

Read more
Monitoring Operations

Setting performance and availability objectives (SLO)

Federico Razzoli April 17, 2019February 18, 2020 Leave a comment

How to define realistic speed and availability goals. Understand what a SLO (service-level objective) is, and the cost of violating it.

Read more
Monitoring Operations

Monitoring ProxySQL with PMM in Docker

Federico Razzoli February 21, 2019July 23, 2020 Leave a comment

How to add ProxySQL to our MySQL/MariaDB environment, and have it monitored by PMM. Docker allows to do this in minutes, for testing purposes.

Read more
Monitoring

Testing PMM with Docker

Federico Razzoli February 15, 2019July 23, 2020 12 Comments

Testing PMM as a monitoring solution for MySQL and MariaDB involves installing a lot of stuff. Let’s see how to so this in minutes with Docker.

Read more
Monitoring

Learning Time

When do you learn job-related topics?
Vote

Recent Articles

  • DROP TABLE improvements in MariaDB (→Vettabase)
  • MariaDB RETURNING Statements (→Vettabase)
  • Do languages need NULL? – Rust example
  • Webinar: Database Design most common pitfalls
  • Consistency Level patterns for high accuracy in Cassandra
  • MySQL backup methods comparison
  • Sizing Aria Pagecache
  • Webinar: MySQL Backups
  • Can we shrink InnoDB Buffer Pool?
  • Is InnoDB Buffer Pool big enough? (→Vettabase)

Categories

  • Amazon Redshift
  • Cassandra
  • Community and news
  • InnoDB
  • Monitoring
  • MySQL and MariaDB
  • MySQL for devs
  • Operations
  • PostgreSQL
  • Query optimisation
  • SQL
  • Stored procedures
  • Uncategorized

Recent Comments

  • Federico Razzoli on Practical advice for MySQL/MariaDB live migrations
  • Krzys on Practical advice for MySQL/MariaDB live migrations
  • Federico Razzoli on Practical advice for MySQL/MariaDB live migrations

Archives

  • July 2020 (2)
  • June 2020 (4)
  • May 2020 (3)
  • April 2020 (5)
  • March 2020 (3)
  • February 2020 (2)
  • January 2020 (3)
  • December 2019 (2)
  • November 2019 (1)
  • October 2019 (2)
  • September 2019 (3)
  • August 2019 (3)
  • July 2019 (1)
  • June 2019 (5)
  • May 2019 (6)
  • April 2019 (7)
  • March 2019 (4)
  • February 2019 (6)
Copyright © 2021 Federico Razzoli.
Powered by WordPress. | Theme: colorskin by Dimitrakopoulos.