Site unreachable every night

Discussion in 'Servers and Control Panels' started by I A 1, Jul 27, 2018.

  1. we_are_borg

    we_are_borg Moderator

    4,375
    807
    +1,684
    What you can do but your server will struggle a bit more is monitor the process and put it in a txt file then you know what happens during the backup. You only need to create a system that let appended the text file instead of overwrite it.
     
  2. I A 1

    I A 1 Enthusiast

    116
    28
    +24
    I was monitoring it during the backup using htop and it was simply running gzip (with >90% CPU) along with the other usual processes.

    There was nothing unusual other than that.
     
  3. we_are_borg

    we_are_borg Moderator

    4,375
    807
    +1,684
    If you have Plesk why not use the backup system of Plesk it designed to saveguard against high loads.
     
  4. I A 1

    I A 1 Enthusiast

    116
    28
    +24
    Using Plesk backup had the same effect.

    It seems like the issue I am facing is similar to the one discussed here: https://dba.stackexchange.com/questions/84223/how-to-backup-live-mysql-database

    Another tutorial says, (https://serversforhackers.com/c/mysqldump-with-modern-mysql)
    I have to look into this further and understand it better. It seems like I have to first convert all tables to InnoDB.
     
  5. we_are_borg

    we_are_borg Moderator

    4,375
    807
    +1,684
    Well i had an issue this year with plesk and it was easier to reinstall then to fix.
     
  6. eva2000

    eva2000 Habitué

    1,664
    857
    +716
    FYI, there's a page 2 and 3 for that blog article too https://vbtechsupport.com/675/2/

    Yes InnoDB tables will use more memory and disk space but also perform better than MyISAM because of the extra memory usage if InnoDB is tuned right. So make sure you have the disk free usage to spare BEFORE converting MyISAM tables to InnoDB. You can do a few tables at a time rather than all at once and see how disk usage changes.

    As to your backup scripts, instead of gzip which is single threaded, look at using pigz which is multi-threaded so can use more cpu cores for faster compression. Though you really need at least 2 cpu threads to benefit from pigz. I did benchmarks for gzip vs pigz and others like zstd and brotli, bzip2, lbzip2 etc at https://community.centminmod.com/th...d-vs-brotli-vs-pigz-vs-bzip2-vs-xz-etc.15126/ - faster multi-threaded compression tools use more memory and cpu so it's a balance depending on your system resources. Example in linked thread gzip vs pigz for level 6 default compression on 8 cpu thread server has pigz being 82% faster than gzip !
     
  7. unisecureus

    unisecureus Aspirant

    17
    3
    +1
    It is Server issue.. contact your Networking guy. He can solve this issue...
    Same issue happend with our Website.. we have increase the SSD storage... and also upgraded website latest version and plugins too.. now we are not facing any issue related to down website.
     
Verification:
Draft saved Draft deleted
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.