[HELP] MySQL Downtime up to 20m in a VM when running backup

DCarnicer

New Member
Sep 13, 2022
1
0
1
Hi!

We are in the phase of moving from development to production and we have realized, while configuring the backup system, that the process usually takes up to 20 minutes to backup a node in snapshot mode.

Said time is a problem because leaves the MySQL service inoperative during 20-minutes period.

Each node (a total of 3) consists of two virtual machines (one scheduled @03:30 a.m and the other @04:00 a.m) without the qemu agent enabled, with ubuntu 20.04, one with mysql server (mysql Ver 14.14 Distrib 5.7.39, for Linux (x86_64)) from ubuntu repo and the other VM with a docker containers, and two volumes, one where the backups related to that node are stored and another that is the volume shared between all the virtual machines, together with the volumes that are created by default.

1663080584218.png

Is this normal? Are we misconfiguring the backup system? We believe that a 20-minute downtime for our service is excessive.

1663080551479.png 1663080728458.png1663080746043.png
 
Last edited:

About

The Proxmox community has been around for many years and offers help and support for Proxmox VE, Proxmox Backup Server, and Proxmox Mail Gateway.
We think our community is one of the best thanks to people like you!

Get your subscription!

The Proxmox team works very hard to make sure you are running the best software and getting stable updates and security enhancements, as well as quick enterprise support. Tens of thousands of happy customers have a Proxmox subscription. Get yours easily in our online shop.

Buy now!