Redundant MySQL Database

Discussion in 'MySQL' started by Jackson_Hu, Jan 1, 2007.

  1. #1
    Hi

    Currently I am running a VB base forum , I am wondering if there is any way I can run a redundant MySQL Data base on different hosting service provider?:rolleyes:
     
    Jackson_Hu, Jan 1, 2007 IP
  2. The Stealthy One

    The Stealthy One Well-Known Member Affiliate Manager

    Messages:
    3,042
    Likes Received:
    54
    Best Answers:
    0
    Trophy Points:
    105
    #2
    This can certainly be done, but it depends on your budget as to whether you'd really want to do it or not. :) You would probably need two dedicated servers, as you would want to replicate the database (i.e. only one is written to, and the other is just a copy of that one, ready to kick in if #1 fails). If you've got a small budget, I would recommend maybe setting up a cron to back it up every day. Or, manually back it up every day.
     
    The Stealthy One, Jan 2, 2007 IP