SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Addict
    Join Date
    Jun 2006
    Posts
    220
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    how to communicate between two server

    In one of my projects, we have two servers, say A and B. Now server B will be a replica of server A. If at any point of time server A goes down at that moment server B will be up. We have to provide a solution so that whenever server A goes down, automatically server A will be up. So at any point of time our site will be not down. To do this whenever we perform a database (mysql) operation in server A, we need to do the same thing in server B also. That means we have to perform inter server database communication. We have already made our site in server A. It's now only that the client has told us about the concept of server B. Can any one give some light how to manage this situation. FYI we are using php5, mysql5 and linux operating system.

  2. #2
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,580
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    MySQL has a built-in set of features called replication that provide exactly what you want: real-time mirroring of a database. All queries are executed on server B exactly as they were on server A. Search for "mysql replication" and you'll find both tutorials and the manual sections.

    http://dev.mysql.com/doc/refman/5.0/en/replication.html

  3. #3
    SitePoint Addict
    Join Date
    Jun 2006
    Posts
    220
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dan Grossman, Thank you


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
  •