Join the community today
Register Now

Centminmod based server and Backupsy, What is the most ideal way to backup?

Discussion in 'Virtual Private Server (VPS) hosting' started by rdan, Nov 5, 2014.

Tags:
  1. rdan

    rdan Well-Known Member

    5,439
    1,399
    113
    May 25, 2014
    Ratings:
    +2,188
    Local Time:
    1:11 AM
    Mainline
    10.2
    What kind of backup method did you use?
    rsnapshot, rsync, etc..

     
  2. eva2000

    eva2000 Administrator Staff Member

    53,811
    12,159
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,710
    Local Time:
    3:11 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  3. rdan

    rdan Well-Known Member

    5,439
    1,399
    113
    May 25, 2014
    Ratings:
    +2,188
    Local Time:
    1:11 AM
    Mainline
    10.2
    rsnapshot already take care both files and mysql database?
    Is there any basic guide how to implement that?

    Thanks Eva!
     
  4. eva2000

    eva2000 Administrator Staff Member

    53,811
    12,159
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,710
    Local Time:
    3:11 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    nope you need to have you own mysql database backup script to backup to sql files on your server and then use rsnapshot to point to directories you want backed up including the directory containing your mysql backup sql files.

    You're on your own but plenty of centos + rsnapshot guides via google :D + official how to at rsnapshot.org/howto/1.2/rsnapshot-HOWTO.en.html (difference is no need to source compile rsnapshot just use yum install rsnapshot)
     
  5. rdan

    rdan Well-Known Member

    5,439
    1,399
    113
    May 25, 2014
    Ratings:
    +2,188
    Local Time:
    1:11 AM
    Mainline
    10.2
    Yes I already have in place :)
    For the last several months I'm using Dropbox though :D
    But out of capacity, only database is uploaded there daily.
     
  6. eva2000

    eva2000 Administrator Staff Member

    53,811
    12,159
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,710
    Local Time:
    3:11 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    you don't care about files ? attachments ? you should backup database and files together :)

    doesn't dropbox have a 1TB plan now ? :D
     
  7. rdan

    rdan Well-Known Member

    5,439
    1,399
    113
    May 25, 2014
    Ratings:
    +2,188
    Local Time:
    1:11 AM
    Mainline
    10.2
    I care that's why I'm seeking of another way other than Dropbox.
    Cause I only have 7GB+ storage on Dropbox, Forum files is not enough on that space.
    Maybe backupsy will work for me, need to study on how to properly setup rsnapshot first.
     
  8. eva2000

    eva2000 Administrator Staff Member

    53,811
    12,159
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,710
    Local Time:
    3:11 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Yeah I use backupsy 500GB VPS plan and pay extra $2/month for full VPS usage instead of just backup only. Install Centmin Mod on the server so it acts as both VPS web server and backup server fully protected by CSF Firewall and all :)

    just install rsnapshot via yum and not source as directed in how to on official site and then proceed with steps 4, 5 and 6 at rsnapshot HOWTO
     
  9. rdan

    rdan Well-Known Member

    5,439
    1,399
    113
    May 25, 2014
    Ratings:
    +2,188
    Local Time:
    1:11 AM
    Mainline
    10.2
  10. eva2000

    eva2000 Administrator Staff Member

    53,811
    12,159
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,710
    Local Time:
    3:11 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    perfect.. was going to say step 4.3 at rsnapshot HOWTO for changing default snapshot storage directory, but that guide explains it all :) Just remember if you have CSF Firewall on either source and/or backup servers, to whitelist IP addresses

    still good read of how rsnapshot works at rsnapshot HOWTO
     
  11. rdan

    rdan Well-Known Member

    5,439
    1,399
    113
    May 25, 2014
    Ratings:
    +2,188
    Local Time:
    1:11 AM
    Mainline
    10.2
    Need to install that on both server right?
     
  12. eva2000

    eva2000 Administrator Staff Member

    53,811
    12,159
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,710
    Local Time:
    3:11 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    install what ? rsnapshot is only needed on backup server = backupsy server

    rsnapshot is pull based backups - so it connects to your origin server and transfers backup directories and files you configure rsnapshot to backup
     
  13. Andy

    Andy Active Member

    542
    89
    28
    Aug 6, 2014
    Ratings:
    +132
    Local Time:
    12:11 PM
    I have a Synology NAS, does anyone know how do I can backup my db/files on the backup folder?
     
  14. eva2000

    eva2000 Administrator Staff Member

    53,811
    12,159
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,710
    Local Time:
    3:11 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    never used Synology NAS myself but if you have SSH, ftp/sftp or something probably it's just like any Linux server ?
     
  15. rdan

    rdan Well-Known Member

    5,439
    1,399
    113
    May 25, 2014
    Ratings:
    +2,188
    Local Time:
    1:11 AM
    Mainline
    10.2
    Following this guide: How to Install Rsnapshot on Ubuntu 12.04 | DigitalOcean
    On this part:
    Code:
    sudo ssh-copy-id -i /root/.ssh/id_rsa.pub root@example.com
    How can I append my custom port properly?
    I tried some commands I know but not working :/

    1234 is custom port of my server wnat to backup and 123.123.12.12 is the IP address.
    Code:
    root@install:~# sudo ssh-copy-id -i /root/.ssh/id_rsa.pub 'ssh -p 1234' root@123.123.12.12
    ssh: Could not resolve hostname ssh: Name or service not known
    root@install:~# sudo ssh-copy-id -i /root/.ssh/id_rsa.pub '-p 1234' root@123.123.12.12
    Pseudo-terminal will not be allocated because stdin is not a terminal.
    ssh: Could not resolve hostname umask 077; test -d ~/.ssh || mkdir ~/.ssh ; cat >> ~/.ssh/authorized_keys: Name or service not k       nown
    root@install:~# sudo ssh-copy-id -i /root/.ssh/id_rsa.pub -p 1234 root@123.123.12.12
    Bad port 'umask 077; test -d ~/.ssh || mkdir ~/.ssh ; cat >> ~/.ssh/authorized_keys'
    root@install:~#
     
  16. rdan

    rdan Well-Known Member

    5,439
    1,399
    113
    May 25, 2014
    Ratings:
    +2,188
    Local Time:
    1:11 AM
    Mainline
    10.2
    Got it now with
    sudo ssh-copy-id -i /root/.ssh/id_rsa.pub "root@123.123.12.12 -p 1234"
    :)
     
  17. eva2000

    eva2000 Administrator Staff Member

    53,811
    12,159
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,710
    Local Time:
    3:11 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Code:
    ssh-copy-id -i ~/.ssh/id_rsa.pub "root@sourceserveripaddress -p 22"
    :)
     
  18. eva2000

    eva2000 Administrator Staff Member

    53,811
    12,159
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,710
    Local Time:
    3:11 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Heh posted at same time :D
     
  19. rdan

    rdan Well-Known Member

    5,439
    1,399
    113
    May 25, 2014
    Ratings:
    +2,188
    Local Time:
    1:11 AM
    Mainline
    10.2
    Should be merge or consider double post, LoL
    Thanks Eva!
     
  20. rdan

    rdan Well-Known Member

    5,439
    1,399
    113
    May 25, 2014
    Ratings:
    +2,188
    Local Time:
    1:11 AM
    Mainline
    10.2
    Now on this part:
    Code:
    sudo ssh root@example.com
    How can I append my custom port again? :(
    Old method is not working.