share a datebase among 2 or more sites

Discussion in 'MySQL' started by lamontgreen, May 25, 2008.

0
  1. #1
    how do you share username and password on one domain 3 sites one datebase 3 prefixes
     
    lamontgreen, May 25, 2008 IP
  2. mooseweb

    mooseweb Banned

    Messages:
    1,154
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    0
    #2
    You connect them all to the same database. Make a central site, connect all the users from that one central place.

    Plus this is HTML & Website Design, post this in MySQL Database Administration...
     
    mooseweb, May 25, 2008 IP
  3. kmap

    kmap Well-Known Member

    Messages:
    2,215
    Likes Received:
    29
    Best Answers:
    2
    Trophy Points:
    135
    #3
    This has some disadvantages if the master site is down all sites will stop working

    Regards

    Alex
     
    kmap, May 25, 2008 IP
  4. mooseweb

    mooseweb Banned

    Messages:
    1,154
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Ok, if you want to get technical.

    Put the database on a separate server with a backup on your main one. In case of a power outage or database failure you can always switch to the backup...
     
    mooseweb, May 25, 2008 IP
  5. lamontgreen

    lamontgreen Active Member

    Messages:
    154
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    55
    #5
    ill pay someone to do this for me
     
    lamontgreen, Jun 13, 2008 IP