Results 1 to 3 of 3

Thread: Developing two (2) websites with Replicated MySQL database.

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Jul 2007
    Posts
    17

    Default Developing two (2) websites with Replicated MySQL database.

    Hello guys at Bizhat.com

    I'm Lysender, a PHP + MySQL intermediate developer.

    I want my project website this way: There are two servers, one at the local campus and the other at some free hosting that supports PHP + MySQL. Each websites has its own database, and directory structure with files like user photos and avatars.

    I want it this way: Where ever the visitor wishes to visit, his/her accounts and photos are available on both servers.

    I'm not asking for source codes or whatever, I'm asking for a technique to make it work. Can anybody help me for that? Post the possible methodologies that can be applied.

    Thank you in advance guys.

  2. #2
    Join Date
    Jan 2008
    Posts
    2

    Default Re: Developing two (2) websites with Replicated MySQL databa

    hi Lysender,

    You can use mysql database replication for this.
    Use the concept of master slave relication
    configure one of the server as master and the other as slave.
    Data in master will be replicated to the slave.

    2. configure a proxy to redirect requests to 2 webservers.

    lemme know if you need any further help

    Regards
    Vinil

  3. #3
    Join Date
    Nov 2005
    Location
    AT DORRS NEAR HEAVEN
    Posts
    2,074

    Default

    Thanks vinil for helping people at time..cheers for ur work

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
  •