Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


How to take automatic hourly or more frequently backup easily
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

How to take automatic hourly or more frequently backup easily

hostkarhostkar Member

Hello,

I have 1 website where I need to set hourly or even more frequently backup system.

and obviously without giving huge pressure on the server.

Can you please tell me which is the best method to do this?

Thanks in advance.

Comments

  • NetDynamics24NetDynamics24 Member, Host Rep

    Is it VPS or shared hosting? Also, which panel? It is cpanel or DA or other?

    Thanked by 1hostkar
  • @NetDynamics24 said: Is it VPS or shared hosting? Also, which panel? It is cpanel or DA or other?

    Currently using VPS with cpanel, but moving to webuzo in 1-2 days and want to setup on webuzo.

  • NetDynamics24NetDynamics24 Member, Host Rep

    In cpanel you can open the crontab editor and add something like the below:

    0 */6 * * * /usr/local/cpanel/bin/backup --force

    I guess something similar can be done with webuzo as well.

  • I have daily rsync with replication for mariadb. Databases are not supposed to support rsync.

  • Incremental backups are better suited to your use case. This allows for more frequent backups and is less likely to cause too much stress. Exactly how to incrementally backup depends on your environment, e.g. whether it's for panels, or virtual machines, or databases ......

  • @hostkar said: Currently using VPS with cpanel, but moving to webuzo in 1-2 days and want to setup on webuzo.

    Webuzo seems to have a built-in admin backup function.

    https://webuzo.com/docs/admin/admin-backup/

    Thanked by 1NetDynamics24
  • jarjar Patron Provider, Top Host, Veteran
    edited April 2023

    @davide said:
    I have daily rsync with replication for mariadb. Databases are not supposed to support rsync.

    Hold my beer while I rsync my MySQL dir 🤣

    (I actually do this for migrations but I shut down the DB server for a final sync, and it's definitely a "hold my beer" moment lol)

  • @jar said:

    (I actually do this for migrations but I shut down the DB server for a final sync, and it's definitely a "hold my beer" moment lol)

    If the server versions are exactly the same, this method works great and can save a lot of time vs. a database dump and import. I've used this technique lots of times to create new replication slaves.

    If the MySQL server versions are not the same, then you may be in for some surprises. :D

    Thanked by 1jar
  • davidedavide Member
    edited April 2023

    @aj_potc said:
    If the server versions are exactly the same.

    I did this very successfully between Mysql 5.6 to MariaDB 10, so not exactly the same version. But the DB (InnoDB) was only used for simple write / read operations, so that might have contributed to extra luck.

  • @davide said:

    @aj_potc said:
    If the server versions are exactly the same.

    I did this very successfully between Mysql 5.6 to MariaDB 10, so not exactly the same version. But the DB (InnoDB) was only used for simple write / read operations, so that might have contributed to extra luck.

    At a certain point, MariaDB and MySQL were pretty close, but then started to differ from each other more and more. I know I've had failures when trying to do this between older and newer MariaDB instances.

    But if it worked for you, then that's all that matters. ;)

  • nhdnhd Member

    Depending on what's backed up on the server, a combo of crontab and rsync should do it. There's a nice calc you can use to setup the right crontab arguments: https://crontab.guru/

  • @nhd said: Depending on what's backed up on the server, a combo of crontab and rsync should do it. There's a nice calc you can use to setup the right crontab arguments: https://crontab.guru/

    can you please share me a URL of tutorial to setup it. I am using Almalinux with webuzo.

  • WebProjectWebProject Host Rep, Veteran

    @hostkar said:
    Hello,

    I have 1 website where I need to set hourly or even more frequently backup system.

    and obviously without giving huge pressure on the server.

    Can you please tell me which is the best method to do this?

    Thanks in advance.

    If you do have a second VM so you be able to pull the the files/databases across instead of pushing, this way less pressure on the production server.

  • You could try rsnapshot. A little bit complicated to set up, but one done it's really great and reliable

    I first learned about it from this LEB post: https://lowendbox.com/blog/incremental-remote-backups-using-rsnapshot/

  • @WebProject said: If you do have a second VM so you be able to pull the the files/databases across instead of pushing, this way less pressure on the production server.

    how to setup this ?

  • @weasel said: You could try rsnapshot. A little bit complicated to set up, but one done it's really great and reliable

    I first learned about it from this LEB post: https://lowendbox.com/blog/incremental-remote-backups-using-rsnapshot/

    thanks, will read it carefully and will try to implement if all fine with my project.

  • WebProjectWebProject Host Rep, Veteran

    @hostkar said:

    @WebProject said: If you do have a second VM so you be able to pull the the files/databases across instead of pushing, this way less pressure on the production server.

    how to setup this ?

    Example: https://stackoverflow.com/questions/9090817/copying-files-using-rsync-from-remote-server-to-local-machine

    You can also zip or tar the files on a go so process done by backup server

  • Without knowing what stack or platform you are using, my recommendation would be to check Backupsheep. They have integrations for Hetzner, OVH, Digitalocean, Lightsail, Vultr and few more. If you are not using one of the providers they have plugins for, you can configure your website backups via FTP/SFTP. And there are few options to set the automations.

    It lets you add your own S3 or cloud storage accounts to save your backups. You've got the option to add google drive, onedrive, Amazon S3, Backblaze, Wasabi, Scaleway, pCloud, etc. There are quite a few to select. They also provide their own storage via Amazon S3, just in case if you don't want to add your own cloud storage.

    Their free account lets you add one integration, or what they call as a 'node', with a 6 hours interval between each backup. If you have a single website, their free account should be more than enough for your needs. I am on one of their paid plans and I use them to trigger snapshots of my Hetzner cloud VMs and save copies of the site backup to our Backblaze as well as our google drive account.

    For what I know they are not a big company, but they are certainly growing. And for what it's worth, I've been using them for over a year and have not experienced any issues.

    If you or anyone here decide to sign up with them, I'd appreciate if you can use my affiliate link. You'll get 15% off for first year.

    Affiliate link: https://backupsheep.com/?via=netsujit
    Direct link: https://backupsheep.com

  • @hostkar said:

    @weasel said: You could try rsnapshot. A little bit complicated to set up, but one done it's really great and reliable

    I first learned about it from this LEB post: https://lowendbox.com/blog/incremental-remote-backups-using-rsnapshot/

    thanks, will read it carefully and will try to implement if all fine with my project.

    Protip: check out the documentation from the project itself... I'm pretty sure you haven't.

    https://webuzo.com/docs/v2/webuzo-backup-and-restore/

Sign In or Register to comment.