Results 1 to 2 of 2
  1. #1

    Backing Up MySQL VPS

    Hello! (Finally Registered!)

    I currently have 2 VPS accounts. The first one runs cPanel and hosts my website's files. The second VPS hosts the mysql databases which the website uses. There are about 70 databases, each averaging about 120MB in size.

    At current, i use to backup each database over two days. (This crashes the server briefly for about 10 minutes per day ). I then use rsync on both servers to backup everything to off-site location.

    Obviously, I need to find a better solution. I was thinking about backing up the databases weekly instead. However, the 10 minute downtime period from the script will still happen. Any ideas?

    I look forward to reading your replies! Thank you!

  2. #2
    Join Date
    Dec 2007
    I'm a huge fan of using replication to a slave server and then using the slave server to run backups from. No downtime for the master server and the slave server will resume replication after the backups are done bringing it back up to current.

Similar Threads

  1. backing up mysql
    By HostTitan in forum Dedicated Server
    Replies: 5
    Last Post: 12-02-2004, 02:52 PM
  2. Backing up a large mysql db?
    By MegaCGI in forum Hosting Security and Technology
    Replies: 8
    Last Post: 11-01-2004, 03:12 AM
  3. Backing up a MySQL Database
    By GameStudioD in forum Programming Discussion
    Replies: 9
    Last Post: 09-08-2004, 04:51 PM
  4. Backing up mysql
    By InsightStats in forum Hosting Security and Technology
    Replies: 0
    Last Post: 04-08-2004, 12:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts