SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Enthusiast
    Join Date
    Apr 2012
    Location
    Poole, Dorset, United Kingdom
    Posts
    72
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Backup & Restore Solution Without Down Time for MYSQL 10gig+

    Hi All
    I'm putting together a online booking company for services and are now looking at the backup and restore methods available.

    I need zero down time and constant backup what would be the best method, I have used mysql dump and rsync in the past but the
    lock down is going to cause issues.

    Any thoughts

  2. #2
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    4,910
    Mentioned
    96 Post(s)
    Tagged
    0 Thread(s)
    What storage engine does the table(s) use at the moment?
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  3. #3
    SitePoint Enthusiast
    Join Date
    Apr 2012
    Location
    Poole, Dorset, United Kingdom
    Posts
    72
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi
    MyISAM is the storage engine

  4. #4
    SitePoint Enthusiast
    Join Date
    Jul 2007
    Location
    San Sebastian, Spain
    Posts
    93
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    In your situation I would look at replication from your primary MySQL server to a secondary server. This would then mean that your primary will continue to function and that you use the replicated version for taking your backups. It also means that if you have a disaster you can use your secondary server as the primary until the old primary gets rebuilt.

  5. #5
    SitePoint Enthusiast
    Join Date
    Apr 2012
    Location
    Poole, Dorset, United Kingdom
    Posts
    72
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the reply would replication be to another server ie different IP or a different partition on the same drive or another physical drive.

  6. #6
    SitePoint Enthusiast
    Join Date
    Jul 2007
    Location
    San Sebastian, Spain
    Posts
    93
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    You could either have it on the same server or on a different server. If I was doing it and budget was available I would definitely put it onto a small server. This way the backup will use only the resources of the replicated server and not the primary server where you want to keep your resources to handle the SQL requests coming.

  7. #7
    SitePoint Member
    Join Date
    Jun 2010
    Posts
    10
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Try Handy Backup 7, it can do zero, mysql and rsync very well.


Bookmarks

Posting Permissions

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