SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    Keeper of the SFL StarLion's Avatar
    Join Date
    Feb 2006
    Location
    Atlanta, GA, USA
    Posts
    3,748
    Mentioned
    71 Post(s)
    Tagged
    0 Thread(s)

    Replication Questions

    Two questions;

    1: How often is the default interval between replications? Or is it a on-update event?

    2: If I have a Master-Master replication setup, what happens in the event of a collision on a autoincrement?

  2. #2
    SitePoint Zealot
    Join Date
    Apr 2005
    Location
    London
    Posts
    163
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I've had limited experience, but this is what I've seen myself:
    1. it is asynchronous, slaves can 'catch up' when they reconnect to the master and read the binlog. It is done on any write to the database. e.g. insert/update/ddl change.
    2. not familiar, and after googling it sounds like this isn't supported. Do you mean cluster?

    Jurn

  3. #3
    Keeper of the SFL StarLion's Avatar
    Join Date
    Feb 2006
    Location
    Atlanta, GA, USA
    Posts
    3,748
    Mentioned
    71 Post(s)
    Tagged
    0 Thread(s)
    2: Each server (2 in this case, for simplicity) is set up as Master of the other, and Slave of the other.

    I'm not the one designing this, I'm just following the installation instructions I was given for a product.

  4. #4
    SitePoint Zealot
    Join Date
    Apr 2005
    Location
    London
    Posts
    163
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    oh I did some more googling. you can use settings
    auto_increment_increment & auto_increment_offset
    to avoid id clashes on each server.
    I don't see how this will avoid duplicate data though.. e.g. if you use unique constraints in your application.


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
  •