SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Thread: Replication

  1. #1
    SitePoint Addict bbparis's Avatar
    Join Date
    Aug 2008
    Posts
    323
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Replication

    Hello,

    I was talking with a friend about how it's possible to keep the speed of search ( I'm building a small search engine ) very high if we have many visitors, so he tell me about ( Replication) he said that wikipedia uses this method to deliver data to its visitors, something like have a master server and many slave servers, I don't know more and I hope if you can provide me more information.

    Regards.

  2. #2
    Non-Member
    Join Date
    Oct 2009
    Posts
    1,852
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    First of all it is SQL administration question, not PHP programming.
    Second, I am sure you don't need replication for speed search. Usual fulltext search mechanism is enough.

  3. #3
    SitePoint Addict bbparis's Avatar
    Join Date
    Aug 2008
    Posts
    323
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks for your reply Shrapnel, I'm talking about MySQL, but you are right, I think it's better if I post the question in MySQL forum.

    What you mean exactly by saying ( Usual fulltext search mechanism is enough.) ?

  4. #4
    SitePoint Wizard cranial-bore's Avatar
    Join Date
    Jan 2002
    Location
    Australia
    Posts
    2,634
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    In a nutshell you have multiple database servers. One is the master, and there are one or more slaves. When data changes the master pushes updates to all of the slaves.
    So your app must send all write operations (INSERT, UPDATE, DELETE etc.) to the master, and distribute the read operations (SELECT) between the various slaves.

    MySQL supports statement based and row based replication. There can be replication lag where slaves are not fully up to date with the master.

    http://www.google.com.au/url?sa=t&so...aXzlSjrRMTnzVw

  5. #5
    Non-Member
    Join Date
    Oct 2009
    Posts
    1,852
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    bbparis I mean you don't need any replication.
    But if you just curious, you can read it from mysql documentation.


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
  •