Results 1 to 5 of 5

Thread: how to do MYSQL online backup of huge database

  1. #1
    Junior Member
    Join Date
    Jun 2007
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Default how to do MYSQL online backup of huge database

    hello
    This is Manish. Well I want to do mysql online backup of databases up to 120GB size. I tried mysqldump and mysqlhotcopy and also mysqlzrm. but none of them works and the version of mysql is 4.X. on gentoo. So is there any opensource soultion for the mysql database backup.

    Thanking you
    Manish

  2. #2
    Is that all you got? rockdalinux's Avatar
    Join Date
    May 2005
    Location
    Planet Vegeta
    Posts
    987
    Thanks
    27
    Thanked 71 Times in 62 Posts
    Rep Power
    19

    Default

    Yes large or huge database is problem for live backup. If you have performance problems with your server while making hot / live backups, try any one of the solution

    #1. Set up replication and perform backups on the slave rather than on the master ... see this tutorial ONLamp.com -- Live Backups of MySQL Using Replication

    #2. Use a Veritas filesystem to make snapshots (you need Veritas products)
    Rocky Jr.
    What's wrong? I hope I am not making you uncomfortable...

    Never send a boy to do a mans job.

  3. #3
    Senior Member raj's Avatar
    Join Date
    Jun 2005
    Location
    Hyderabad
    Posts
    565
    Thanks
    57
    Thanked 40 Times in 37 Posts
    Rep Power
    13

    Default

    ZRM for MySQL Enterprise and Cluster Editions does work with large databases you need to purchase this software, it is not a free version. Zmanda Recovery Manager for MySQL - Enterprise Edition. You can also use free version which requires a lot of config option. I suggest try replication option as suggested by rockdalinux
    Raj
    Linux rulz.
    I have never turned back in my life ; I shall not do so today.. haha

  4. #4
    Senior Member
    Join Date
    Jul 2006
    Location
    India, Delhi
    Posts
    208
    Thanks
    3
    Thanked 1 Time in 1 Post
    Rep Power
    8

    Default backup with mixed utilities-- try to find and mix up them

    for online backup, if u r going to use replication, then u need huge amount of RAM, by which ur application, queries, and so on... and even live backup takes place.

    so look at it if have enough amount of RAM, my opinion is 8GB RAM will be fair for this task.

    but why don't u a shell script or use any user tweakable source application in which the process is like this

    1) first it make dump compressed with tar.gz then transfer to storage.
    ofcourse it will also take much memory but with less bandwidth.

  5. #5
    Junior Member
    Join Date
    Jul 2008
    Location
    Washington, US
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Default

    Sounds like you need regular downtime (those tables must be terribly slow to repair, too.)

    Have you considered doing LVM snapshotting? The big drawback to that is the load-spike caused by copying extends once you restart and data starts getting written again. If you're doing a lot of data collection using the ARCHIVE engine, then that load spike won't be so big.

    But--if you're not using replication now, I very much think you're going to want to soon. Come up with an LVM snapshot process and rsync the data to a slave ... that will be the fastest way to get replication started.

    Good luck!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. need to convert text files into mysql database
    By zafar466 in forum Databases servers
    Replies: 2
    Last Post: 12th July 2008, 12:31 PM
  2. ssh backup particular mysql table / database
    By brothers in forum Databases servers
    Replies: 11
    Last Post: 25th October 2007, 05:06 PM
  3. MySql FTP server backup script
    By zafar466 in forum Shell scripting
    Replies: 3
    Last Post: 25th September 2007, 05:43 PM
  4. MySQL Backup Script
    By krisa in forum Shell scripting
    Replies: 1
    Last Post: 2nd February 2007, 11:57 PM
  5. How do I backup MySQL Databases?
    By chiku in forum All about FreeBSD/OpenBSD/NetBSD
    Replies: 2
    Last Post: 19th August 2006, 07:15 PM

Posting Permissions

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